Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 SET SESSION wsrep_sync_wait = 0;
5 SET SESSION lock_wait_timeout = 60;
6 SET SESSION innodb_lock_wait_timeout=60;
7 SET SESSION wait_timeout=60;
8 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
9 FLUSH TABLE t1 WITH READ LOCK;
10 connection node_2;
11 ALTER TABLE t1 ADD COLUMN f2 INTEGER;
12 connection node_1;
13 SELECT 1 FROM DUAL;
14 1
15 1
16 SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE LIKE 'Waiting for table metadata lock%' OR STATE LIKE 'Waiting to execute in isolation%');
17 COUNT(*) = 1
18 1
19 UNLOCK TABLES;
20 SET SESSION wsrep_sync_wait = 15;
21 SHOW CREATE TABLE t1;
22 Table Create Table
23 t1 CREATE TABLE `t1` (
24 `f1` int(11) NOT NULL,
25 `f2` int(11) DEFAULT NULL,
26 PRIMARY KEY (`f1`)
27 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
28 SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE USER = 'system user' AND (STATE LIKE 'Waiting for table metadata lock%' OR STATE LIKE 'Waiting to execute in isolation%');
29 COUNT(*) = 0
30 1
31 DROP TABLE t1;