diff options
Diffstat (limited to 'mysql-test/main/tmp_table_count-7586.result')
-rw-r--r-- | mysql-test/main/tmp_table_count-7586.result | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/main/tmp_table_count-7586.result b/mysql-test/main/tmp_table_count-7586.result index 637e7385..ebb23331 100644 --- a/mysql-test/main/tmp_table_count-7586.result +++ b/mysql-test/main/tmp_table_count-7586.result @@ -52,6 +52,7 @@ Created_tmp_disk_tables 0 Created_tmp_files 0 Created_tmp_tables 2 drop table t3; +set @@optimizer_switch="firstmatch=off"; EXPLAIN SELECT * FROM t1 WHERE a IN (SELECT * FROM t2 GROUP BY a); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t1 ALL NULL NULL NULL NULL 2 @@ -69,6 +70,7 @@ Variable_name Value Created_tmp_disk_tables 0 Created_tmp_files 0 Created_tmp_tables 1 +set @@optimizer_switch=default; drop table t1,t2,t3; truncate table performance_schema.events_statements_history_long; flush status; |