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/win.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/win.result')
-rw-r--r-- | mysql-test/main/win.result | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/mysql-test/main/win.result b/mysql-test/main/win.result index 4adb5c84f1e..0eec38db611 100644 --- a/mysql-test/main/win.result +++ b/mysql-test/main/win.result @@ -1742,8 +1742,7 @@ drop table t1; # create table t1(a int); insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); -set @tmp=@@big_tables; -set big_tables=1; +set tmp_memory_table_size=0; select rank() over (order by a) from t1; rank() over (order by a) 1 @@ -1756,7 +1755,7 @@ rank() over (order by a) 8 9 10 -set big_tables=@tmp; +set tmp_memory_table_size=default; drop table t1; # # Check if "ORDER BY window_func" works |