Debian Codegraph @

mysql-test/suite/galera/r/galera_toi_lock_shared.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 ALTER TABLE t1 ADD COLUMN f2 INTEGER, LOCK=SHARED;
7 connection node_1;
8 INSERT INTO t1 VALUES (2, 2);
9 SELECT COUNT(*) AS EXPECT_2 FROM t1;
10 EXPECT_2
11 2
12 SELECT * FROM t1;
13 id f2
14 1 NULL
15 2 2
16 connection node_2;
17 INSERT INTO t1 VALUES (3, 3);
18 SELECT COUNT(*) AS EXPECT_3 FROM t1;
19 EXPECT_3
20 3
21 SELECT * FROM t1;
22 id f2
23 1 NULL
24 2 2
25 3 3
26 DROP TABLE t1;