Debian Codegraph @

mysql-test/suite/galera_sr/t/mysql-wsrep-features#8.test

raw
1 --source include/big_test.inc
2 --source include/galera_cluster.inc
3 --source include/have_innodb.inc
4
5 #
6 # InnoDB FULLTEXT indexes
7 #
8
9 SET SESSION wsrep_trx_fragment_size = 1;
10 CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
11 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
12
13 #
14 # Fulltext index creation causes the creation of multiple system tables
15 #
16
17 --connection node_1
18 CREATE TABLE t1 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 VARCHAR(100), FULLTEXT (f2)) ENGINE=InnoDB;
19
20 --connection node_2
21 SELECT COUNT(*) = 13 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE name LIKE 'test/%';
22
23 #
24 # Fulltext insertion causes a flurry of updates on those system tables
25 #
26
27 --connection node_1
28 # Insert 10K rows
29 INSERT INTO t1 (f2) SELECT 'foobarbaz' FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
30
31 --connection node_2
32 SELECT COUNT(f2) = 10000 FROM t1 WHERE MATCH(f2) AGAINST ('foobarbaz');
33
34 UPDATE t1 SET f2 = 'abcdefjhk';
35
36 --connection node_1
37 SELECT COUNT(f2) = 10000 FROM t1 WHERE MATCH(f2) AGAINST ('abcdefjhk');
38
39 --connection node_2
40
41 DROP TABLE t1;
42
43 #
44 # Same on a table with no PK
45 #
46
47 --connection node_1
48 CREATE TABLE t1 (f1 VARCHAR(100), FULLTEXT (f1)) ENGINE=InnoDB;
49
50 --connection node_2
51 # We insert only 1K rows here, because updates without a PK are very slow
52 INSERT INTO t1 (f1) SELECT 'foobarbaz' FROM ten AS a1, ten AS a2, ten AS a3;
53
54 --connection node_1
55 SELECT COUNT(f1) = 1000 FROM t1 WHERE MATCH(f1) AGAINST ('foobarbaz');
56
57 UPDATE t1 SET f1 = 'abcdefjhk';
58
59 --connection node_2
60 SELECT COUNT(f1) = 1000 FROM t1 WHERE MATCH(f1) AGAINST ('abcdefjhk');
61
62 DROP TABLE t1;
63 DROP TABLE ten;