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

1 files changed, 14 insertions, 0 deletions

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;