Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
4 INSERT INTO t1 VALUES (1);
5 connection node_2;
6 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t%';
7 NAME
8 test/t1
9 FLUSH TABLES t1 WITH READ LOCK;
10 connection node_1;
11 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
12 INSERT INTO t1 VALUES (2,3);
13 connection node_2;
14 UNLOCK TABLES;
15 ### t1 should have column f2
16 SHOW CREATE TABLE t1;
17 Table Create Table
18 t1 CREATE TABLE `t1` (
19 `id` int(11) NOT NULL,
20 `f2` int(11) DEFAULT NULL,
21 PRIMARY KEY (`id`)
22 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
23 SELECT * from t1;
24 id f2
25 1 NULL
26 2 3
27 connection node_1;
28 DROP TABLE t1;