diff options
Diffstat (limited to 'mysql-test/main/subselect_cache.result')
| -rw-r--r-- | mysql-test/main/subselect_cache.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/subselect_cache.result b/mysql-test/main/subselect_cache.result index abd978de9a5..0d6f459ce88 100644 --- a/mysql-test/main/subselect_cache.result +++ b/mysql-test/main/subselect_cache.result @@ -1860,8 +1860,8 @@ Variable_name Value Subquery_cache_hit 0 Subquery_cache_miss 4 drop table t1; -#test of sql_big_tables switch and outer table reference in subquery with grouping -set big_tables=1; +#test of big_tables switch and outer table reference in subquery with grouping +set tmp_memory_table_size=0; CREATE TABLE t1 (a INT PRIMARY KEY, b INT); INSERT INTO t1 VALUES (1,1),(2,1),(3,2),(4,2),(5,3),(6,3); SELECT (SELECT t1_outer.a FROM t1 AS t1_inner GROUP BY b LIMIT 1) FROM t1 AS t1_outer; @@ -1873,7 +1873,7 @@ SELECT (SELECT t1_outer.a FROM t1 AS t1_inner GROUP BY b LIMIT 1) FROM t1 AS t1_ 5 6 drop table t1; -set big_tables=0; +set tmp_memory_table_size=default; #test of function reference to outer query set local group_concat_max_len=400; create table t2 (a int, b int); |