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/select_jcl6.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/select_jcl6.result')
| -rw-r--r-- | mysql-test/main/select_jcl6.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/main/select_jcl6.result b/mysql-test/main/select_jcl6.result index 7276814114f..2de5df60901 100644 --- a/mysql-test/main/select_jcl6.result +++ b/mysql-test/main/select_jcl6.result @@ -523,7 +523,7 @@ insert into tmp select * from t3; insert into t3 select * from tmp; alter table t3 add t2nr int not null auto_increment primary key first; drop table tmp; -SET BIG_TABLES=1; +set tmp_memory_table_size=0; select distinct concat(fld3," ",fld3) as namn from t2,t3 where t2.fld1=t3.t2nr order by namn limit 10; namn Abraham Abraham @@ -536,7 +536,7 @@ ammonium ammonium analyzable analyzable animals animals animized animized -SET BIG_TABLES=0; +set tmp_memory_table_size=default; select distinct concat(fld3," ",fld3) from t2,t3 where t2.fld1=t3.t2nr order by fld3 limit 10; concat(fld3," ",fld3) Abraham Abraham @@ -573,7 +573,7 @@ attendants 1 bedlam 1 bedpost 1 boasted 1 -SET BIG_TABLES=1; +set tmp_memory_table_size=0; select distinct fld3,count(*) from t2 group by companynr,fld3 limit 10; fld3 count(*) affixed 1 @@ -586,7 +586,7 @@ attendants 1 bedlam 1 bedpost 1 boasted 1 -SET BIG_TABLES=0; +set tmp_memory_table_size=default; select distinct fld3,repeat("a",length(fld3)),count(*) from t2 group by companynr,fld3 limit 100,10; fld3 repeat("a",length(fld3)) count(*) circus aaaaaa 1 |