Debian Codegraph @

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

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