Debian Codegraph @

mysql-test/suite/galera/t/tmp_space_usage.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_sequence.inc
3 --source include/have_log_bin.inc
4 --source include/have_binlog_format_row.inc
5
6 --echo #
7 --echo # MDEV-37808 "Local temporary space limit reached" on not so rare
8 --echo # occasions
9 --echo #
10
11 --connection node_1
12
13 set @@max_tmp_session_space_usage=1024*1024*1024;
14
15 create user foo;
16 grant all privileges on *.* to foo;
17
18 use test;
19 create table t1(a int, b varchar(1024)) engine=innodb;
20 insert into t1 select seq, repeat("a", 500) from seq_1_to_100;
21 create table t2(a int, b varchar(1024)) engine=myisam;
22 insert into t2 select seq, repeat("a", 500) from seq_1_to_100;
23
24 show status like "%tmp_space%";
25
26 change_user foo;
27 use test;
28 select count(*) from t1;
29 show status like "%tmp_space%";
30
31 drop table t1,t2;
32 change_user root;
33 drop user foo;