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_exists_to_in.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_exists_to_in.result')
| -rw-r--r-- | mysql-test/main/subselect_no_exists_to_in.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/subselect_no_exists_to_in.result b/mysql-test/main/subselect_no_exists_to_in.result index 84c415d1ce1..e830c8bdc91 100644 --- a/mysql-test/main/subselect_no_exists_to_in.result +++ b/mysql-test/main/subselect_no_exists_to_in.result @@ -7134,7 +7134,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); @@ -7143,7 +7143,7 @@ a 0 0 DROP TABLE t1; -SET SESSION big_tables=0; +set tmp_memory_table_size=default; # # MDEV-10776: Server crash on query # |