summaryrefslogtreecommitdiff
path: root/mysql-test/t/trigger.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/t/trigger.test')
-rw-r--r--mysql-test/t/trigger.test7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/t/trigger.test b/mysql-test/t/trigger.test
index a02dce34837..6e29761d0ba 100644
--- a/mysql-test/t/trigger.test
+++ b/mysql-test/t/trigger.test
@@ -2410,6 +2410,10 @@ USE test;
#
# Test that using a trigger will not open mysql.proc
#
+let $use_stat_tables_saved= `SELECT @@session.use_stat_tables`;
+--disable_query_log
+SET SESSION use_stat_tables=never;
+--enable_query_log
create table t1 (i int);
create table t2 (i int);
flush tables;
@@ -2428,6 +2432,9 @@ show status like 'Opened_tables';
select * from t1;
select * from t2;
drop table t1,t2;
+--disable_query_log
+eval SET SESSION use_stat_tables=$use_stat_tables_saved;
+--enable_query_log
--echo End of 5.2 tests.