Debian Codegraph @

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

raw
1 #
2 # ALTER TABLE ... ADD PRIMARY KEY under Rolling Schema Upgrade
3 #
4
5 --source include/big_test.inc
6 --source include/galera_cluster.inc
7 --source include/have_innodb.inc
8
9 --connection node_1
10 CREATE TABLE ten (f1 INTEGER);
11 INSERT INTO ten VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
12
13 CREATE TABLE t1 (f1 INTEGER) Engine=InnoDB;
14
15 # Insert some values before the ALTER
16 INSERT INTO t1 (f1) SELECT 000000 + (10000 * a1.f1) + (1000 * a2.f1) + (100 * a3.f1) + (10 * a4.f1) + a5.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5;
17
18 # Insert more values while the ALTER is running
19 --send INSERT INTO t1 (f1) SELECT 100000 + (10000 * a1.f1) + (1000 * a2.f1) + (100 * a3.f1) + (10 * a4.f1) + a5.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5;
20
21 --connection node_2
22 SET SESSION wsrep_OSU_method = "RSU";
23 ALTER TABLE t1 ADD PRIMARY KEY (f1);
24 SET SESSION wsrep_OSU_method = "TOI";
25
26 # Insert values after the ALTER
27 INSERT INTO t1 (f1) SELECT 200000 + (10000 * a1.f1) + (1000 * a2.f1) + (100 * a3.f1) + (10 * a4.f1) + a5.f1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5;
28
29 --let $wait_condition = SELECT COUNT(*) = 300000 FROM t1;
30 --source include/wait_condition.inc
31
32 SELECT COUNT(*) AS EXPECT_300000 FROM t1;
33 SELECT MAX(f1) AS EXPECT_299999 FROM t1;
34
35 --connection node_1
36 --reap
37
38 --let $wait_condition = SELECT COUNT(*) = 300000 FROM t1;
39 --source include/wait_condition.inc
40
41 SELECT COUNT(*) AS EXPECT_300000 FROM t1;
42 SELECT MAX(f1) AS EXPECT_299999 FROM t1;
43
44 SET SESSION wsrep_OSU_method = "RSU";
45 ALTER TABLE t1 ADD PRIMARY KEY (f1);
46 SET SESSION wsrep_OSU_method = "TOI";
47
48 DROP TABLE t1;
49 DROP TABLE ten;