Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
4 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
5 connection node_1;
6 CREATE TABLE t1 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 VARCHAR(100), FULLTEXT (f2)) ENGINE=InnoDB;
7 connection node_2;
8 SELECT COUNT(*) = 13 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE name LIKE 'test/%';
9 COUNT(*) = 13
10 1
11 connection node_1;
12 INSERT INTO t1 (f2) SELECT 'foobarbaz' FROM ten AS a1, ten AS a2, ten AS a3;
13 connection node_2;
14 SELECT COUNT(f2) = 1000 FROM t1 WHERE MATCH(f2) AGAINST ('foobarbaz');
15 COUNT(f2) = 1000
16 1
17 UPDATE t1 SET f2 = 'abcdefjhk';
18 connection node_1;
19 SELECT COUNT(f2) = 1000 FROM t1 WHERE MATCH(f2) AGAINST ('abcdefjhk');
20 COUNT(f2) = 1000
21 1
22 connection node_2;
23 DROP TABLE t1;
24 connection node_1;
25 CREATE TABLE t1 (f1 VARCHAR(100), FULLTEXT (f1)) ENGINE=InnoDB;
26 connection node_2;
27 INSERT INTO t1 (f1) SELECT 'foobarbaz' FROM ten AS a1, ten AS a2, ten AS a3;
28 connection node_1;
29 SELECT COUNT(f1) = 1000 FROM t1 WHERE MATCH(f1) AGAINST ('foobarbaz');
30 COUNT(f1) = 1000
31 1
32 UPDATE t1 SET f1 = 'abcdefjhk';
33 connection node_2;
34 SELECT COUNT(f1) = 1000 FROM t1 WHERE MATCH(f1) AGAINST ('abcdefjhk');
35 COUNT(f1) = 1000
36 1
37 DROP TABLE t1;
38 DROP TABLE ten;
39 connection node_1;
40 SET @value=REPEAT (1,5001);
41 CREATE TABLE t (a VARCHAR(5000),FULLTEXT (a)) engine=innodb;
42 INSERT IGNORE INTO t VALUES(@value);
43 Warnings:
44 Warning 1265 Data truncated for column 'a' at row 1
45 SELECT COUNT(*) FROM t;
46 COUNT(*)
47 1
48 connection node_2;
49 SELECT COUNT(*) FROM t;
50 COUNT(*)
51 1
52 connection node_1;
53 DROP TABLE t;
54 CREATE TABLE t (a VARCHAR(5000)) engine=innodb;
55 INSERT IGNORE INTO t VALUES(@value);
56 Warnings:
57 Warning 1265 Data truncated for column 'a' at row 1
58 SELECT COUNT(*) FROM t;
59 COUNT(*)
60 1
61 connection node_2;
62 SELECT COUNT(*) FROM t;
63 COUNT(*)
64 1
65 connection node_1;
66 DROP TABLE t;
67 connection node_1;
68 SET @value=REPEAT (1,5001);
69 CREATE TABLE t (a VARCHAR(5000),FULLTEXT (a)) engine=innodb DEFAULT CHARSET=utf8;
70 INSERT IGNORE INTO t VALUES(@value);
71 Warnings:
72 Warning 1265 Data truncated for column 'a' at row 1
73 SELECT COUNT(*) FROM t;
74 COUNT(*)
75 1
76 connection node_2;
77 SELECT COUNT(*) FROM t;
78 COUNT(*)
79 1
80 connection node_1;
81 DROP TABLE t;
82 CREATE TABLE t (a VARCHAR(5000)) engine=innodb DEFAULT CHARSET=utf8;
83 INSERT IGNORE INTO t VALUES(@value);
84 Warnings:
85 Warning 1265 Data truncated for column 'a' at row 1
86 SELECT COUNT(*) FROM t;
87 COUNT(*)
88 1
89 connection node_2;
90 SELECT COUNT(*) FROM t;
91 COUNT(*)
92 1
93 connection node_1;
94 DROP TABLE t;