Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
4 CREATE TABLE t2 (id INT PRIMARY KEY) ENGINE=InnoDB;
5 connection node_2;
6 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t%';
7 NAME
8 test/t1
9 test/t2
10 LOCK TABLE t1 READ;
11 connection node_1;
12 INSERT INTO t1 VALUES (1);
13 INSERT INTO t2 VALUES (1);
14 connection node_2a;
15 SET SESSION wsrep_sync_wait=0;
16 SELECT COUNT(*) = 0 FROM t1;
17 COUNT(*) = 0
18 1
19 SELECT COUNT(*) = 0 FROM t2;
20 COUNT(*) = 0
21 1
22 connection node_2;
23 UNLOCK TABLES;
24 SELECT COUNT(*) = 1 FROM t1;
25 COUNT(*) = 1
26 1
27 SELECT COUNT(*) = 1 FROM t2;
28 COUNT(*) = 1
29 1
30 DROP TABLE t1;
31 DROP TABLE t2;