mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
7789726843
Add wait_condition so that INSERT is replicated before ALTER and ALTER is replicated before we try to INSERT with new number of columns.
26 lines
470 B
Text
26 lines
470 B
Text
connection node_2;
|
|
connection node_1;
|
|
CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
|
|
INSERT INTO t1 VALUES (1);
|
|
connection node_2;
|
|
ALTER TABLE t1 ADD COLUMN f2 INTEGER, LOCK=SHARED;
|
|
connection node_1;
|
|
INSERT INTO t1 VALUES (2, 2);
|
|
SELECT COUNT(*) AS EXPECT_2 FROM t1;
|
|
EXPECT_2
|
|
2
|
|
SELECT * FROM t1;
|
|
id f2
|
|
1 NULL
|
|
2 2
|
|
connection node_2;
|
|
INSERT INTO t1 VALUES (3, 3);
|
|
SELECT COUNT(*) AS EXPECT_3 FROM t1;
|
|
EXPECT_3
|
|
3
|
|
SELECT * FROM t1;
|
|
id f2
|
|
1 NULL
|
|
2 2
|
|
3 3
|
|
DROP TABLE t1;
|