Debian Codegraph @

mysql-test/suite/galera/t/galera_forced_binlog_ctas_test.inc

raw
1 --connection node_1
2 CREATE TABLE t1(a int not null primary key auto_increment, b int) ENGINE=InnoDB;
3 CREATE TABLE t2(a int not null primary key, b int) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES (NULL,1),(NULL,2);
5 INSERT INTO t1(b) SELECT b+1 from t1;
6 INSERT INTO t1(b) SELECT b+1 from t1;
7 INSERT INTO t1(b) SELECT b+1 from t1;
8 INSERT INTO t1(b) SELECT b+1 from t1;
9 CREATE TABLE t3 AS SELECT * FROM t1;
10 CREATE TABLE t4 AS SELECT * FROM t2;
11 CREATE TABLE t5 (a INT UNIQUE) AS SELECT 1 AS a;
12 CREATE TABLE t6 (a INT UNIQUE) REPLACE SELECT 1 AS a;
13 CREATE TABLE t7 (a INT UNIQUE) REPLACE SELECT 1 AS a,2 AS b UNION SELECT 1 AS a,
14 3 AS c;
15
16 SELECT COUNT(*) AS EXPECT_32 FROM t1;
17 SELECT COUNT(*) AS EXPECT_0 FROM t2;
18 SELECT COUNT(*) AS EXPECT_32 FROM t3;
19 SELECT * FROM t4;
20 SELECT * FROM t5;
21 SELECT * FROM t6;
22 SELECT * FROM t7;
23
24 --connection node_2
25 --echo # Veryfy CTAS replication
26 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'
27 --source include/wait_condition.inc
28 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2'
29 --source include/wait_condition.inc
30 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't3'
31 --source include/wait_condition.inc
32 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't4'
33 --source include/wait_condition.inc
34 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't5'
35 --source include/wait_condition.inc
36 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't6'
37 --source include/wait_condition.inc
38 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't7'
39 --source include/wait_condition.inc
40
41 SELECT COUNT(*) AS EXPECT_32 FROM t1;
42 SELECT COUNT(*) AS EXPECT_0 FROM t2;
43 SELECT COUNT(*) AS EXPECT_32 FROM t3;
44 SELECT * FROM t4;
45 SELECT * FROM t5;
46 SELECT * FROM t6;
47 SELECT * FROM t7;
48
49 --connection node_1
50 DROP TABLE t1,t2,t3,t4,t5,t6,t7;