Debian Codegraph @

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

raw
1 #
2 # Test that Galera works correctly with multiline statements, in particular involving DDLs
3 #
4
5 --source include/galera_cluster.inc
6
7 --connection node_1
8 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB; CREATE TABLE t2 (f1 INTEGER) ENGINE=InnoDB;
9
10 SHOW CREATE TABLE t1;
11 SHOW CREATE TABLE t2;
12
13 --connection node_2
14 SHOW CREATE TABLE t1;
15 SHOW CREATE TABLE t2;
16
17 --connection node_1
18 --send CREATE TABLE t3 (f1 INTEGER) ENGINE=InnoDB; CREATE TABLE t4 (f1 INTEGER) ENGINE=InnoDB;
19 --reap
20
21 SHOW CREATE TABLE t3;
22 SHOW CREATE TABLE t4;
23
24 --connection node_2
25 SHOW CREATE TABLE t3;
26 SHOW CREATE TABLE t4;
27
28 --connection node_1
29 INSERT INTO t1 VALUES (1); CREATE TABLE t5 (f1 INTEGER) ENGINE=InnoDB;
30
31 SELECT COUNT(*) = 1 FROM t1;
32 SHOW CREATE TABLE t5;
33
34 --connection node_2
35 SELECT COUNT(*) = 1 FROM t1;
36 SHOW CREATE TABLE t5;
37
38 --connection node_1
39 --send CREATE TABLE t6 (f1 INTEGER) ENGINE=InnoDB; INSERT INTO t2 VALUES (1);
40 --reap
41
42 SELECT COUNT(*) = 1 FROM t2;
43 SHOW CREATE TABLE t6;
44
45 --connection node_2
46 SELECT COUNT(*) = 1 FROM t2;
47 SHOW CREATE TABLE t6;
48
49 --let $diff_servers = 1 2
50 --source include/diff_servers.inc
51
52 --connection node_1
53 DROP TABLE t1, t2, t3, t4, t5, t6;