Debian Codegraph @

mysql-test/suite/galera/t/GAL-480.test

raw
1 --source include/galera_cluster.inc
2
3 --connection node_1
4 CREATE TABLE t1 (f1 CHAR(10), f0 integer) ENGINE=InnoDB;
5
6 FLUSH TABLE t1 FOR EXPORT;
7 UNLOCK TABLES;
8
9 ALTER TABLE t1 DROP COLUMN f1;
10
11 SET SESSION wsrep_osu_method='RSU';
12 ALTER TABLE t1 ADD COLUMN f1 CHAR(10);
13 ALTER TABLE t1 DROP COLUMN f1;
14 ALTER TABLE t1 ADD COLUMN f2 CHAR(10);
15 ALTER TABLE t1 DROP COLUMN f2;
16 ALTER TABLE t1 ADD COLUMN f3 CHAR(10);
17 ALTER TABLE t1 DROP COLUMN f3;
18 ALTER TABLE t1 ADD COLUMN f4 CHAR(10);
19 ALTER TABLE t1 DROP COLUMN f4;
20 ALTER TABLE t1 ADD COLUMN f5 CHAR(10);
21 ALTER TABLE t1 DROP COLUMN f5;
22 ALTER TABLE t1 ADD COLUMN f6 CHAR(10);
23 ALTER TABLE t1 DROP COLUMN f6;
24 ALTER TABLE t1 ADD COLUMN f7 CHAR(10);
25 ALTER TABLE t1 DROP COLUMN f7;
26 ALTER TABLE t1 ADD COLUMN f8 CHAR(10);
27 ALTER TABLE t1 DROP COLUMN f8;
28 ALTER TABLE t1 ADD COLUMN f9 CHAR(10);
29 ALTER TABLE t1 DROP COLUMN f9;
30 ALTER TABLE t1 ADD COLUMN f10 CHAR(10);
31 ALTER TABLE t1 DROP COLUMN f10;
32 ALTER TABLE t1 ADD COLUMN f11 CHAR(10);
33 ALTER TABLE t1 DROP COLUMN f11;
34 ALTER TABLE t1 ADD COLUMN f12 CHAR(10);
35 ALTER TABLE t1 DROP COLUMN f12;
36 ALTER TABLE t1 ADD COLUMN f13 CHAR(10);
37 ALTER TABLE t1 DROP COLUMN f13;
38 ALTER TABLE t1 ADD COLUMN f14 CHAR(10);
39 ALTER TABLE t1 DROP COLUMN f14;
40 ALTER TABLE t1 ADD COLUMN f15 CHAR(10);
41 ALTER TABLE t1 DROP COLUMN f15;
42 ALTER TABLE t1 ADD COLUMN f16 CHAR(10);
43 ALTER TABLE t1 DROP COLUMN f16;
44
45 SET SESSION wsrep_osu_method='TOI';
46 DROP TABLE t1;