Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 CREATE DATABASE fts;
6 USE fts;
7 CREATE TABLE fts_t1 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 VARCHAR(100), FULLTEXT (f2)) ENGINE=InnoDB;
8 CREATE TABLE fts_t2 (f2 VARCHAR(100), FULLTEXT (f2)) ENGINE=InnoDB;
9 CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
10 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
11 INSERT INTO fts_t1 (f2) SELECT 'foobarbaz' FROM ten AS a1, ten AS a2, ten AS a3;
12 INSERT INTO fts_t2 (f2) SELECT 'foobarbaz' FROM ten AS a1, ten AS a2, ten AS a3;
13 DROP TABLE ten;
14 UPDATE fts_t1 SET f2 = 'abcd';
15 UPDATE fts_t2 SET f2 = 'efjh';
16 SELECT COUNT(*) AS EXPECT_1000 FROM fts_t1;
17 EXPECT_1000
18 1000
19 SELECT COUNT(*) AS EXPECT_1000 FROM fts_t2;
20 EXPECT_1000
21 1000
22 SELECT COUNT(*) AS EXPECT_1000 FROM fts_t1 where f2 = 'abcd';
23 EXPECT_1000
24 1000
25 SELECT COUNT(*) AS EXPECT_1000 FROM fts_t2 where f2 = 'efjh';
26 EXPECT_1000
27 1000
28 connection node_2;
29 connection node_1;
30 connection node_2;
31 SELECT COUNT(*) AS EXPECT_1000 FROM fts_t1;
32 EXPECT_1000
33 1000
34 SELECT COUNT(*) AS EXPECT_1000 FROM fts_t2;
35 EXPECT_1000
36 1000
37 SELECT COUNT(*) AS EXPECT_1000 FROM fts_t1 where f2 = 'abcd';
38 EXPECT_1000
39 1000
40 SELECT COUNT(*) AS EXPECT_1000 FROM fts_t2 where f2 = 'efjh';
41 EXPECT_1000
42 1000
43 connection node_1;
44 USE fts;
45 DROP TABLE fts_t1;
46 DROP TABLE fts_t2;
47 SHOW TABLES;
48 Tables_in_fts
49 DROP DATABASE fts;
50 connection node_2;
51 call mtr.add_suppression("WSREP: Failed to scan the last segment to the end\\. Last events may be missing\\. Last recovered event: ");
52 Warnings:
53 Note 1049 Unknown database 'fts'