diff options
Diffstat (limited to 'mysql-test/main/tmp_table_count-7586.test')
| -rw-r--r-- | mysql-test/main/tmp_table_count-7586.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/main/tmp_table_count-7586.test b/mysql-test/main/tmp_table_count-7586.test index 8bfb0e7c5cf..b994410650b 100644 --- a/mysql-test/main/tmp_table_count-7586.test +++ b/mysql-test/main/tmp_table_count-7586.test @@ -43,6 +43,7 @@ select sum(created_tmp_tables) from performance_schema.events_statements_history show status like '%Created_tmp%'; drop table t3; +set @@optimizer_switch="firstmatch=off"; EXPLAIN SELECT * FROM t1 WHERE a IN (SELECT * FROM t2 GROUP BY a); truncate table performance_schema.events_statements_history_long; flush status; @@ -50,6 +51,7 @@ CREATE TABLE t3 SELECT * FROM t1 WHERE a IN (SELECT * FROM t2 GROUP BY a); --echo # Performance schema should be the same as "Created_tmp_tables" variable below select sum(created_tmp_tables) from performance_schema.events_statements_history_long; show status like '%Created_tmp%'; +set @@optimizer_switch=default; drop table t1,t2,t3; |