Debian Codegraph @

mysql-test/suite/galera_sr/t/galera_sr_insert_select.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Test large INSERT ... SELECT with SR
6 #
7
8 --connection node_1
9 CREATE TABLE ten (f1 INTEGER);
10 INSERT INTO ten VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
11 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT, f2 CHAR(255)) ENGINE=InnoDB;
12 SET SESSION wsrep_trx_fragment_size = 1;
13 SET AUTOCOMMIT=OFF;
14 START TRANSACTION;
15
16 # Insert 10K rows.
17 INSERT INTO t1 (f2) SELECT REPEAT('a', 255) FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
18
19 --connection node_2
20 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
21 --let $wait_condition = SELECT COUNT(*) > 99 FROM t1;
22 --source include/wait_condition.inc
23
24 --connection node_1
25 COMMIT;
26
27 --connection node_2
28 --let $wait_condition = SELECT COUNT(*) = 10000 FROM t1;
29
30 --connection node_1
31
32 DROP TABLE t1;
33 DROP TABLE ten;