Debian Codegraph @

mysql-test/suite/galera/t/MDEV-34594.test

raw
1 --source include/galera_cluster.inc
2 --source include/log_bin.inc
3
4 --echo #
5 --echo # Case 1: test with binlog_format ROW
6 --echo #
7 --connection node_1
8 SET @@binlog_format=ROW;
9 CREATE TABLE t1 (a INT UNIQUE) SELECT 1 AS a,2 AS b UNION SELECT 2 AS a,3 AS c;
10 #
11 # Note that this has two rows (1,2) and (1,3) where (1,3) contains duplicate key
12 # but we requested REPLACE --> ::update_row() is called to update (1,2) --> (1,3)
13 #
14 CREATE TABLE t2 (a INT UNIQUE) REPLACE SELECT 1 AS a,2 AS b UNION SELECT 1 AS a,3 AS c;
15 SELECT * FROM t1;
16 SELECT * FROM t2;
17
18 --connection node_2
19 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2'
20 --source include/wait_condition.inc
21
22 SELECT * FROM t1;
23 SELECT * FROM t2;
24 DROP TABLE t1,t2;
25
26 --echo #
27 --echo # Case 2: test with binlog_format MIXED
28 --echo #
29 --connection node_1
30 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2'
31 --source include/wait_condition.inc
32 SET @@binlog_format=MIXED;
33 CREATE TABLE t1 (a INT UNIQUE) SELECT 1 AS a,2 AS b UNION SELECT 2 AS a,3 AS c;
34 CREATE TABLE t2 (a INT UNIQUE) REPLACE SELECT 1 AS a,2 AS b UNION SELECT 1 AS a,3 AS c;
35 SELECT * FROM t1;
36 SELECT * FROM t2;
37
38 --connection node_2
39 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2'
40 --source include/wait_condition.inc
41
42 SELECT * FROM t1;
43 SELECT * FROM t2;
44 DROP TABLE t1,t2;
45
46 --echo #
47 --echo # Case 3: test with binlog_format STATEMENT
48 --echo #
49 --connection node_1
50 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2'
51 --source include/wait_condition.inc
52 SET @@binlog_format=STATEMENT;
53 CREATE TABLE t1 (a INT UNIQUE) SELECT 1 AS a,2 AS b UNION SELECT 2 AS a,3 AS c;
54 CREATE TABLE t2 (a INT UNIQUE) REPLACE SELECT 1 AS a,2 AS b UNION SELECT 1 AS a,3 AS c;
55 SELECT * FROM t1;
56 SELECT * FROM t2;
57
58 --connection node_2
59 --let $wait_condition = SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2' OR TABLE_NAME = 't1'
60 --source include/wait_condition.inc
61
62 SELECT * FROM t1;
63 SELECT * FROM t2;
64 DROP TABLE t1,t2;
65
66 --connection node_1
67 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2'
68 --source include/wait_condition.inc