Debian Codegraph @

mysql-test/suite/galera/r/MDEV-34594.result

raw
1 connection node_2;
2 connection node_1;
3 #
4 # Case 1: test with binlog_format ROW
5 #
6 connection node_1;
7 SET @@binlog_format=ROW;
8 CREATE TABLE t1 (a INT UNIQUE) SELECT 1 AS a,2 AS b UNION SELECT 2 AS a,3 AS c;
9 CREATE TABLE t2 (a INT UNIQUE) REPLACE SELECT 1 AS a,2 AS b UNION SELECT 1 AS a,3 AS c;
10 SELECT * FROM t1;
11 a b
12 1 2
13 2 3
14 SELECT * FROM t2;
15 a b
16 1 3
17 connection node_2;
18 SELECT * FROM t1;
19 a b
20 1 2
21 2 3
22 SELECT * FROM t2;
23 a b
24 1 3
25 DROP TABLE t1,t2;
26 #
27 # Case 2: test with binlog_format MIXED
28 #
29 connection node_1;
30 SET @@binlog_format=MIXED;
31 Warnings:
32 Warning 1105 MariaDB Galera and flashback do not support 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 Warnings:
35 Warning 1105 Galera does not support binlog_format = MIXED in CREATE TABLE [SELECT|REPLACE] forcing ROW
36 Warning 1105 Galera does not support binlog_format = MIXED in CREATE TABLE [SELECT|REPLACE] forcing ROW
37 CREATE TABLE t2 (a INT UNIQUE) REPLACE SELECT 1 AS a,2 AS b UNION SELECT 1 AS a,3 AS c;
38 Warnings:
39 Warning 1105 Galera does not support binlog_format = MIXED in CREATE TABLE [SELECT|REPLACE] forcing ROW
40 Warning 1105 Galera does not support binlog_format = MIXED in CREATE TABLE [SELECT|REPLACE] forcing ROW
41 SELECT * FROM t1;
42 a b
43 1 2
44 2 3
45 SELECT * FROM t2;
46 a b
47 1 3
48 connection node_2;
49 SELECT * FROM t1;
50 a b
51 1 2
52 2 3
53 SELECT * FROM t2;
54 a b
55 1 3
56 DROP TABLE t1,t2;
57 #
58 # Case 3: test with binlog_format STATEMENT
59 #
60 connection node_1;
61 SET @@binlog_format=STATEMENT;
62 Warnings:
63 Warning 1105 MariaDB Galera and flashback do not support binlog format: STATEMENT
64 CREATE TABLE t1 (a INT UNIQUE) SELECT 1 AS a,2 AS b UNION SELECT 2 AS a,3 AS c;
65 Warnings:
66 Warning 1105 Galera does not support binlog_format = MIXED in CREATE TABLE [SELECT|REPLACE] forcing ROW
67 Warning 1105 Galera does not support binlog_format = MIXED in CREATE TABLE [SELECT|REPLACE] forcing ROW
68 CREATE TABLE t2 (a INT UNIQUE) REPLACE SELECT 1 AS a,2 AS b UNION SELECT 1 AS a,3 AS c;
69 Warnings:
70 Warning 1105 Galera does not support binlog_format = MIXED in CREATE TABLE [SELECT|REPLACE] forcing ROW
71 Warning 1105 Galera does not support binlog_format = MIXED in CREATE TABLE [SELECT|REPLACE] forcing ROW
72 SELECT * FROM t1;
73 a b
74 1 2
75 2 3
76 SELECT * FROM t2;
77 a b
78 1 3
79 connection node_2;
80 SELECT * FROM t1;
81 a b
82 1 2
83 2 3
84 SELECT * FROM t2;
85 a b
86 1 3
87 DROP TABLE t1,t2;
88 connection node_1;