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_no_opts.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_no_opts.result')
-rw-r--r-- | mysql-test/main/subselect_no_opts.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/subselect_no_opts.result b/mysql-test/main/subselect_no_opts.result index 09f664d3c28..ec4d0d99a6d 100644 --- a/mysql-test/main/subselect_no_opts.result +++ b/mysql-test/main/subselect_no_opts.result @@ -7125,7 +7125,7 @@ drop table t1,t2,t3,t4; # MDEV-7122 # Assertion `0' failed in subselect_hash_sj_engine::init # -SET SESSION big_tables=1; +set tmp_memory_table_size=0; CREATE TABLE t1(a char(255) DEFAULT '', KEY(a(10))) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; INSERT INTO t1 VALUES(0),(0),(0); SELECT * FROM t1 WHERE a IN(SELECT MIN(a) FROM t1); @@ -7134,7 +7134,7 @@ a 0 0 DROP TABLE t1; -SET SESSION big_tables=0; +set tmp_memory_table_size=default; # # MDEV-10776: Server crash on query # |