Debian Codegraph @

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

raw
1 #
2 # Test the operation of DDLs that affect multiple database objects
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 --let $galera_connection_name = node_1a
9 --let $galera_server_number = 1
10 --source include/galera_connect.inc
11
12 --connection node_1
13 CREATE DATABASE database1;
14 USE database1;
15
16 CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
17 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
18
19 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
20 CREATE TABLE t2 (f1 INTEGER) ENGINE=InnoDB;
21
22 # Make sure autocommit retrying does not kick in as this will mask the error we expect to get
23 SET SESSION wsrep_retry_autocommit = 0;
24 # Attemp to insert 1M rows
25 --send INSERT INTO t1 (f1) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5, ten AS a6;
26
27 --connection node_1a
28 USE database1;
29 SET SESSION wsrep_retry_autocommit = 0;
30 --send INSERT INTO t2 (f1) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5, ten AS a6;
31
32 --connection node_2
33 --sleep 1
34 --send DROP DATABASE database1;
35
36 --connection node_1
37 --sleep 1
38 --error ER_LOCK_DEADLOCK
39 --reap
40
41 --connection node_1a
42 --error ER_LOCK_DEADLOCK
43 --reap
44
45 --connection node_2
46 --reap
47
48 --connection node_1
49 SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'database1';
50 --error ER_BAD_DB_ERROR
51 USE database1;
52
53 --connection node_2
54 SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'database1';
55 --error ER_BAD_DB_ERROR
56 USE database1;