Debian Codegraph @

mysql-test/suite/galera/t/MDEV-22227.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_log_bin.inc
3
4 CREATE TABLE t1 (a INT) ENGINE=MyISAM;
5 LOCK TABLE t1 WRITE CONCURRENT;
6
7 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
8 --connection node_1a
9 # TOI operations will ignore lock_wait_timeout
10 SET lock_wait_timeout= 1;
11 --send CREATE VIEW v1 AS SELECT * FROM t1
12
13 --connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1
14 --connection node_1b
15 SET SESSION wsrep_sync_wait = 0;
16 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE 'Waiting for table level lock'
17 --source include/wait_condition.inc
18
19 --connection node_1
20 UNLOCK TABLES;
21
22 --connection node_1a
23 --reap
24
25 DROP VIEW v1;
26 DROP TABLE t1;