From f0a1a571b330a9ca87f81992cdbf8272bcb08934 Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 24 Jan 2003 01:54:39 +0200 Subject: fixed table invalidation in simple renaming mysql-test/r/query_cache.result: test of simple renaming & QC mysql-test/t/query_cache.test: test of simple renaming & QC --- mysql-test/t/query_cache.test | 14 ++++++++++++++ 1 file changed, 14 insertions(+) (limited to 'mysql-test/t/query_cache.test') diff --git a/mysql-test/t/query_cache.test b/mysql-test/t/query_cache.test index 6c3f3d6ac52..f77ea3c3b2a 100644 --- a/mysql-test/t/query_cache.test +++ b/mysql-test/t/query_cache.test @@ -383,3 +383,17 @@ disable_result_log; select * from mysql.db; enable_result_log; show status like "Qcache_queries_in_cache"; + + +# +# simple rename test +# +create table t1(id int auto_increment primary key); +insert into t1 values (NULL), (NULL), (NULL); +select * from t1 where id=2; +alter table t1 rename to t2; +-- error 1146 +select * from t1 where id=2; +drop table t2; +-- error 1146 +select * from t1 where id=2; -- cgit v1.2.1