Debian Codegraph @

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

raw
1 #
2 # Test DDL errors under Rolling Schema Upgrade
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 CREATE TABLE t1 (f1 INTEGER) Engine=InnoDB;
9 INSERT INTO t1 VALUES (1), (1);
10
11 --connection node_2
12 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t1';
13 --source include/wait_condition.inc
14
15 SET SESSION wsrep_OSU_method = "RSU";
16 --error ER_DUP_ENTRY
17 ALTER TABLE t1 ADD PRIMARY KEY (f1);
18 SET SESSION wsrep_OSU_method = "TOI";
19
20 # The ALTER has no effect
21 SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME = 't1';
22
23 INSERT INTO t1 VALUES (1);
24
25 --connection node_1
26 SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME = 't1';
27 SELECT COUNT(*) = 3 FROM t1;
28
29 INSERT INTO t1 VALUES (1);
30
31 --connection node_2
32 SELECT COUNT(3) = 4 FROM t1;
33
34 DROP TABLE t1;