Debian Codegraph @

mysql-test/suite/galera/t/galera_lock_tables_in_transaction.test

raw
1 #
2 # Check `LOCK TABLES` command with or without existing table in database.
3 # Test case for MDEV-22222 / MDEV-22223
4 #
5
6 --source include/galera_cluster.inc
7 --source include/have_innodb.inc
8
9 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
10
11 START TRANSACTION;
12 INSERT INTO t1 VALUES (1);
13 --error ER_NO_SUCH_TABLE
14 LOCK TABLES t2 READ;
15
16 START TRANSACTION;
17 INSERT INTO t1 VALUES (1);
18 LOCK TABLES t1 READ;
19 UNLOCK TABLES;
20
21 DROP TABLE t1;