Debian Codegraph @

mysql-test/suite/galera/t/galera_drop_database.test

raw
1 #
2 # This test tests a DROP empty database
3 #
4 --source include/galera_cluster.inc
5 --source include/have_innodb.inc
6
7 # Save original auto_increment_offset values.
8 --let $node_1=node_1
9 --let $node_2=node_2
10 --source include/auto_increment_offset_save.inc
11
12 # Create test database with two sets of the FTS indexes:
13 CREATE DATABASE fts;
14 USE fts;
15 CREATE TABLE fts_t1 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 VARCHAR(100), FULLTEXT (f2)) ENGINE=InnoDB;
16 CREATE TABLE fts_t2 (f2 VARCHAR(100), FULLTEXT (f2)) ENGINE=InnoDB;
17
18 # Insert 1K rows
19 CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
20 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
21 INSERT INTO fts_t1 (f2) SELECT 'foobarbaz' FROM ten AS a1, ten AS a2, ten AS a3;
22 INSERT INTO fts_t2 (f2) SELECT 'foobarbaz' FROM ten AS a1, ten AS a2, ten AS a3;
23 DROP TABLE ten;
24 UPDATE fts_t1 SET f2 = 'abcd';
25 UPDATE fts_t2 SET f2 = 'efjh';
26 SELECT COUNT(*) AS EXPECT_1000 FROM fts_t1;
27 SELECT COUNT(*) AS EXPECT_1000 FROM fts_t2;
28 SELECT COUNT(*) AS EXPECT_1000 FROM fts_t1 where f2 = 'abcd';
29 SELECT COUNT(*) AS EXPECT_1000 FROM fts_t2 where f2 = 'efjh';
30
31 # Restart the second node:
32 --connection node_2
33 --source include/restart_mysqld.inc
34
35 --connection node_1
36 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
37 --source include/wait_condition.inc
38
39 --connection node_2
40 --source include/wait_until_ready.inc
41 --let $wait_condition = SELECT COUNT(*) = 1000 FROM fts_t1 where f2 = 'abcd';
42 --source include/wait_condition.inc
43 --let $wait_condition = SELECT COUNT(*) = 1000 FROM fts_t2 where f2 = 'efjh';
44 --source include/wait_condition.inc
45 SELECT COUNT(*) AS EXPECT_1000 FROM fts_t1;
46 SELECT COUNT(*) AS EXPECT_1000 FROM fts_t2;
47 SELECT COUNT(*) AS EXPECT_1000 FROM fts_t1 where f2 = 'abcd';
48 SELECT COUNT(*) AS EXPECT_1000 FROM fts_t2 where f2 = 'efjh';
49
50 # Drop the tables and database after nodes restarted:
51 --connection node_1
52 USE fts;
53 DROP TABLE fts_t1;
54 DROP TABLE fts_t2;
55 SHOW TABLES;
56 DROP DATABASE fts;
57
58 --connection node_2
59 call mtr.add_suppression("WSREP: Failed to scan the last segment to the end\\. Last events may be missing\\. Last recovered event: ");
60 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'fts_t1';
61 --source include/wait_condition.inc
62 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'fts_t2';
63 --source include/wait_condition.inc
64 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'fts';
65 --source include/wait_condition.inc
66
67 # Restore original auto_increment_offset values.
68 --source include/auto_increment_offset_restore.inc