diff options
author | Sergei Golubchik <serg@mariadb.org> | 2019-09-18 14:17:26 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2019-09-28 19:21:14 +0200 |
commit | cd41ffe1f1e86891b12878af0d9efcc6f7320f59 (patch) | |
tree | 4ae44beaed8ca9eeaa5745c13c03bfd3d63533b8 /mysql-test/main/subselect_mat.result | |
parent | de9ef03ae6a6cf573062c89d22ca446154f435f5 (diff) | |
download | mariadb-git-cd41ffe1f1e86891b12878af0d9efcc6f7320f59.tar.gz |
MDEV-19713 Remove big_tables system variable
mark big_tables deprecated, the server can put temp tables on disk
as needed avoiding "table full" errors.
in case someone would really need to force a tmp table to be created
on disk from the start and for testing allow tmp_memory_table_size
to be set to 0.
fix tests to use that instead (and add a test that it actually
works).
make sure in-memory TREE size limit is never 0 (it's [ab]using
tmp_memory_table_size at the moment)
remove few sys_vars.*_basic tests
Diffstat (limited to 'mysql-test/main/subselect_mat.result')
-rw-r--r-- | mysql-test/main/subselect_mat.result | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/mysql-test/main/subselect_mat.result b/mysql-test/main/subselect_mat.result index 34b58daa50e..c5fa7ddc92c 100644 --- a/mysql-test/main/subselect_mat.result +++ b/mysql-test/main/subselect_mat.result @@ -2118,8 +2118,7 @@ DROP VIEW v2; # # MDEV-5811: Server crashes in best_access_path with materialization+semijoin and big_tables=ON # -SET @tmp_mdev5811= @@big_tables; -SET big_tables = ON; +set tmp_memory_table_size=0; CREATE TABLE t1 (a INT); INSERT INTO t1 VALUES (1),(2); CREATE TABLE t2 (b INT); @@ -2128,7 +2127,7 @@ SELECT * FROM t1 AS t1_1, t1 AS t1_2 WHERE ( t1_1.a, t1_2.a ) IN ( SELECT MAX(b), MIN(b) FROM t2 ); a a DROP TABLE t1,t2; -SET big_tables=@tmp_mdev5811; +set tmp_memory_table_size=default; # End of 5.3 tests # # MDEV-5056: Wrong result (extra rows) with materialization+semijoin, IN subqueries |