Debian Codegraph @

mysql-test/suite/galera_sr/r/mysql-wsrep-features#8.result

raw
1 connection node_2;
2 connection node_1;
3 SET SESSION wsrep_trx_fragment_size = 1;
4 CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
5 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
6 connection node_1;
7 CREATE TABLE t1 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 VARCHAR(100), FULLTEXT (f2)) ENGINE=InnoDB;
8 connection node_2;
9 SELECT COUNT(*) = 13 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE name LIKE 'test/%';
10 COUNT(*) = 13
11 1
12 connection node_1;
13 INSERT INTO t1 (f2) SELECT 'foobarbaz' FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
14 connection node_2;
15 SELECT COUNT(f2) = 10000 FROM t1 WHERE MATCH(f2) AGAINST ('foobarbaz');
16 COUNT(f2) = 10000
17 1
18 UPDATE t1 SET f2 = 'abcdefjhk';
19 connection node_1;
20 SELECT COUNT(f2) = 10000 FROM t1 WHERE MATCH(f2) AGAINST ('abcdefjhk');
21 COUNT(f2) = 10000
22 1
23 connection node_2;
24 DROP TABLE t1;
25 connection node_1;
26 CREATE TABLE t1 (f1 VARCHAR(100), FULLTEXT (f1)) ENGINE=InnoDB;
27 connection node_2;
28 INSERT INTO t1 (f1) SELECT 'foobarbaz' FROM ten AS a1, ten AS a2, ten AS a3;
29 connection node_1;
30 SELECT COUNT(f1) = 1000 FROM t1 WHERE MATCH(f1) AGAINST ('foobarbaz');
31 COUNT(f1) = 1000
32 1
33 UPDATE t1 SET f1 = 'abcdefjhk';
34 connection node_2;
35 SELECT COUNT(f1) = 1000 FROM t1 WHERE MATCH(f1) AGAINST ('abcdefjhk');
36 COUNT(f1) = 1000
37 1
38 DROP TABLE t1;
39 DROP TABLE ten;