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/variables.test | |
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/variables.test')
-rw-r--r-- | mysql-test/main/variables.test | 11 |
1 files changed, 2 insertions, 9 deletions
diff --git a/mysql-test/main/variables.test b/mysql-test/main/variables.test index b303958dff8..eab323dda3d 100644 --- a/mysql-test/main/variables.test +++ b/mysql-test/main/variables.test @@ -113,8 +113,6 @@ explain extended select last_insert_id(345); select @@IDENTITY,last_insert_id(), @@identity; explain extended select @@IDENTITY,last_insert_id(), @@identity; -set big_tables=OFF, big_tables=ON, big_tables=0, big_tables=1, big_tables="OFF", big_tables="ON"; - set global concurrent_insert=2; show variables like 'concurrent_insert'; select * from information_schema.session_variables where variable_name like 'concurrent_insert'; @@ -241,10 +239,6 @@ SELECT @@version_compile_os LIKE 'non-existent'; # The following should give errors ---error ER_WRONG_VALUE_FOR_VAR -set big_tables=OFFF; ---error ER_WRONG_VALUE_FOR_VAR -set big_tables="OFFF"; --error ER_UNKNOWN_SYSTEM_VARIABLE set unknown_variable=1; --error ER_WRONG_TYPE_FOR_VAR @@ -252,7 +246,7 @@ set max_join_size="hello"; --error ER_UNKNOWN_STORAGE_ENGINE set default_storage_engine=UNKNOWN_TABLE_TYPE; --error ER_WRONG_VALUE_FOR_VAR -set default_storage_engine=MERGE, big_tables=2; +set default_storage_engine=MERGE, sql_warnings=NULL; show local variables like 'default_storage_engine'; --error ER_UNKNOWN_CHARACTER_SET set character_set_client=UNKNOWN_CHARACTER_SET; @@ -276,8 +270,7 @@ set @@SQL_WARNINGS=NULL; # Test setting all variables set autocommit=1; -set big_tables=1; -select @@autocommit, @@big_tables; +select @@autocommit; set global binlog_cache_size=100; set bulk_insert_buffer_size=100; set character set cp1251_koi8; |