Debian Codegraph @

mysql-test/suite/sys_vars/t/tmp_disk_table_size_func.test

raw
1 ###################### tmp_memory_table_size_func.test ########################
2
3 --source include/have_aria_used_for_temp_tables.inc
4
5 --source include/load_sysvars.inc
6 --source include/have_sequence.inc
7
8 --echo
9 --echo "Ensure that we get an error if we exceed tmp_disk_table_size"
10 --echo
11
12 SET @start_tmp_memory_table_size=@@session.tmp_memory_table_size;
13 SET @start_tmp_disk_table_size=@@session.tmp_disk_table_size;
14
15 set @@session.tmp_memory_table_size=16384;
16 set @@session.tmp_disk_table_size=3000000;
17
18 --disable_ps2_protocol
19 create table t1 (a int primary key, b varchar(2000));
20 insert into t1 select seq,repeat(char(mod(seq,62)+64),seq) from seq_1_to_2000;
21 insert into t1 values (20000,"A");
22 select count(*) as c from t1 group by b having c>1;
23 show status like "created_tmp_disk%";
24 set @@session.tmp_disk_table_size=1000000;
25 --error ER_RECORD_FILE_FULL
26 select count(*) as c from t1 group by b having c>1;
27 show status like "created_tmp_disk%";
28 drop table t1;
29 --enable_ps2_protocol