diff options
Diffstat (limited to 'mysql-test/main/cte_recursive.test')
-rw-r--r-- | mysql-test/main/cte_recursive.test | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/main/cte_recursive.test b/mysql-test/main/cte_recursive.test index 6a4f55cd408..ce3b817a937 100644 --- a/mysql-test/main/cte_recursive.test +++ b/mysql-test/main/cte_recursive.test @@ -2138,13 +2138,13 @@ SELECT * FROM cte; --echo # MDEV-15575: using recursive cte with big_tables enabled --echo # -set big_tables=1; +set tmp_memory_table_size=0; # force on-disk tmp table with recursive qn as (select 123 as a union all select 1+a from qn where a<130) select * from qn; -set big_tables=default; +set tmp_memory_table_size=default; --echo # --echo # MDEV-15571: using recursive cte with big_tables enabled @@ -2153,7 +2153,7 @@ set big_tables=default; create table t1 (a bigint); insert into t1 values(1); -set big_tables=1; +set tmp_memory_table_size=0; # force on-disk tmp table --error ER_DATA_OUT_OF_RANGE with recursive qn as @@ -2164,7 +2164,7 @@ with recursive qn as ) select * from qn; -set big_tables=default; +set tmp_memory_table_size=default; drop table t1; @@ -2173,7 +2173,7 @@ drop table t1; --echo # when recursive tables are accessed by key --echo # -SET big_tables=1; +set tmp_memory_table_size=0; # force on-disk tmp table CREATE TABLE t1 (id int, name char(10), leftpar int, rightpar int); INSERT INTO t1 VALUES @@ -2202,7 +2202,7 @@ eval EXPLAIN $q; DROP TABLE t1,t2; -SET big_tables=0; +set tmp_memory_table_size=default; --echo # --echo # MDEV-15840: recursive tables are accessed by key |