Debian Codegraph @

mysql-test/suite/sys_vars/r/tmp_disk_table_size_func.result

raw
1
2 "Ensure that we get an error if we exceed tmp_disk_table_size"
3
4 SET @start_tmp_memory_table_size=@@session.tmp_memory_table_size;
5 SET @start_tmp_disk_table_size=@@session.tmp_disk_table_size;
6 set @@session.tmp_memory_table_size=16384;
7 set @@session.tmp_disk_table_size=3000000;
8 create table t1 (a int primary key, b varchar(2000));
9 insert into t1 select seq,repeat(char(mod(seq,62)+64),seq) from seq_1_to_2000;
10 insert into t1 values (20000,"A");
11 select count(*) as c from t1 group by b having c>1;
12 c
13 2
14 show status like "created_tmp_disk%";
15 Variable_name Value
16 Created_tmp_disk_tables 1
17 set @@session.tmp_disk_table_size=1000000;
18 select count(*) as c from t1 group by b having c>1;
19 ERROR HY000: The table '(temporary)' is full
20 show status like "created_tmp_disk%";
21 Variable_name Value
22 Created_tmp_disk_tables 2
23 drop table t1;