Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 SET GLOBAL wsrep_provider_options = 'repl.key_format=FLAT16';
5 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
6 INSERT INTO t1 VALUES (123);
7 CREATE TABLE t2 (f1 VARCHAR(256)) ENGINE=InnoDB;
8 INSERT INTO t2 VALUES (REPEAT('a', 256));
9 connection node_2;
10 SELECT COUNT(*) = 1 FROM t1;
11 COUNT(*) = 1
12 1
13 UPDATE t1 SET f1 = 234;
14 UPDATE t2 SET f1 = REPEAT('b', 256);
15 connection node_1;
16 SELECT COUNT(*) = 1 FROM t1 WHERE f1 = 234;
17 COUNT(*) = 1
18 1
19 SELECT COUNT(*) = 1 FROM t2 WHERE f1 = REPEAT('b', 256);
20 COUNT(*) = 1
21 1
22 DROP TABLE t1;
23 DROP TABLE t2;