Debian Codegraph @

mysql-test/suite/galera/r/galera_rsu_drop_pk.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE ten (f1 INTEGER) Engine=InnoDB;
5 INSERT INTO ten VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
6 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) Engine=InnoDB;
7 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;
8 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;;
9 connection node_2;
10 SET SESSION wsrep_OSU_method = "RSU";
11 ALTER TABLE t1 DROP PRIMARY KEY;
12 SET SESSION wsrep_OSU_method = "TOI";
13 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;
14 SELECT COUNT(*) as expect_300000 FROM t1;
15 expect_300000
16 300000
17 SELECT MAX(f1) as expect_299999 FROM t1;
18 expect_299999
19 299999
20 connection node_1;
21 SELECT COUNT(*) as expect_300000 FROM t1;
22 expect_300000
23 300000
24 SELECT MAX(f1) as expect_299999 FROM t1;
25 expect_299999
26 299999
27 SET SESSION wsrep_OSU_method = "RSU";
28 ALTER TABLE t1 DROP PRIMARY KEY;
29 SET SESSION wsrep_OSU_method = "TOI";
30 connection node_2;
31 INSERT INTO t1 (f1) VALUES (1);
32 INSERT INTO t1 (f1) VALUES (10);
33 connection node_1;
34 SELECT COUNT(*) as expect_2 FROM t1 WHERE f1 = 1;
35 expect_2
36 2
37 SELECT COUNT(*) as expect_2 FROM t1 WHERE f1 = 10;
38 expect_2
39 2
40 INSERT INTO t1 (f1) VALUES (100);
41 INSERT INTO t1 (f1) VALUES (1000);
42 connection node_2;
43 SELECT COUNT(*) as expect_2 FROM t1 WHERE f1 = 100;
44 expect_2
45 2
46 SELECT COUNT(*) as expect_2 FROM t1 WHERE f1 = 1000;
47 expect_2
48 2
49 DROP TABLE t1;
50 DROP TABLE ten;