Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES (1);
5 connection node_2;
6 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
7 INSERT INTO t1 VALUES (2, 3);
8 connection node_1;
9 ALTER TABLE t1 DROP COLUMN f2;
10 INSERT INTO t1 VALUES (4);
11 connection node_2;
12 SHOW CREATE TABLE t1;
13 Table Create Table
14 t1 CREATE TABLE `t1` (
15 `f1` int(11) NOT NULL,
16 PRIMARY KEY (`f1`)
17 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
18 SELECT COUNT(*) = 3 FROM t1;
19 COUNT(*) = 3
20 1
21 SELECT * FROM t1 ORDER BY f1;
22 f1
23 1
24 2
25 4
26 connection node_1;
27 SHOW CREATE TABLE t1;
28 Table Create Table
29 t1 CREATE TABLE `t1` (
30 `f1` int(11) NOT NULL,
31 PRIMARY KEY (`f1`)
32 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
33 SELECT COUNT(*) = 3 FROM t1;
34 COUNT(*) = 3
35 1
36 SELECT * FROM t1 ORDER BY f1;
37 f1
38 1
39 2
40 4
41 DROP TABLE t1;