Debian Codegraph @

mysql-test/suite/galera/r/galera_binlog_row_image.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 SET SESSION binlog_row_image=minimal;
5 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
6 CREATE TABLE t2 (f1 INTEGER NOT NULL UNIQUE) ENGINE=InnoDB;
7 CREATE TABLE t3 (f1 VARCHAR(1)) ENGINE=InnoDB;
8 INSERT INTO t1 VALUES (1);
9 INSERT INTO t2 VALUES (1);
10 INSERT INTO t3 VALUES (1);
11 connection node_2;
12 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 1;
13 COUNT(*) = 1
14 1
15 SELECT COUNT(*) = 1 FROM t2 WHERE f1 = 1;
16 COUNT(*) = 1
17 1
18 SELECT COUNT(*) = 1 FROM t3 WHERE f1 = 1;
19 COUNT(*) = 1
20 1
21 connection node_1;
22 UPDATE t1 SET f1 = 2 WHERE f1 = 1;
23 UPDATE t2 SET f1 = 2 WHERE f1 = 1;
24 UPDATE t3 SET f1 = 2 WHERE f1 = 1;
25 connection node_2;
26 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 2;
27 COUNT(*) = 1
28 1
29 SELECT COUNT(*) = 1 FROM t2 WHERE f1 = 2;
30 COUNT(*) = 1
31 1
32 SELECT COUNT(*) = 1 FROM t3 WHERE f1 = 2;
33 COUNT(*) = 1
34 1
35 connection node_1;
36 DELETE FROM t1;
37 DELETE FROM t2;
38 DELETE FROM t3;
39 connection node_2;
40 SELECT COUNT(*) = 0 FROM t1;
41 COUNT(*) = 0
42 1
43 SELECT COUNT(*) = 0 FROM t2;
44 COUNT(*) = 0
45 1
46 SELECT COUNT(*) = 0 FROM t3;
47 COUNT(*) = 0
48 1
49 DROP TABLE t1;
50 DROP TABLE t2;
51 DROP TABLE t3;
52 connection node_1;
53 SET SESSION binlog_row_image=noblob;
54 CREATE TABLE t1 (f1 BLOB, f2 INTEGER PRIMARY KEY) ENGINE=InnoDB;
55 CREATE TABLE t2 (f1 BLOB) ENGINE=InnoDB;
56 INSERT INTO t1 VALUES ('abc', 1);
57 INSERT INTO t2 VALUES ('abc');
58 connection node_2;
59 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 'abc';
60 COUNT(*) = 1
61 1
62 SELECT COUNT(*) = 1 FROM t2 WHERE f1 = 'abc';
63 COUNT(*) = 1
64 1
65 connection node_1;
66 UPDATE t1 SET f1 = 'xyz';
67 UPDATE t2 SET f1 = 'xyz';
68 connection node_2;
69 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 'xyz';
70 COUNT(*) = 1
71 1
72 SELECT COUNT(*) = 1 FROM t2 WHERE f1 = 'xyz';
73 COUNT(*) = 1
74 1
75 connection node_1;
76 UPDATE t1 SET f2 = 2 WHERE f2 = 1;
77 connection node_2;
78 SELECT COUNT(*) = 1 FROM t1 WHERE f2 = 2;
79 COUNT(*) = 1
80 1
81 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 'xyz';
82 COUNT(*) = 1
83 1
84 connection node_1;
85 DELETE FROM t1;
86 DELETE FROM t2;
87 connection node_2;
88 SELECT COUNT(*) = 0 FROM t1;
89 COUNT(*) = 0
90 1
91 SELECT COUNT(*) = 0 FROM t2;
92 COUNT(*) = 0
93 1
94 DROP TABLE t1;
95 DROP TABLE t2;