summaryrefslogtreecommitdiff
path: root/mysql-test/suite/galera/r/galera_lock_tables_in_transaction.result
blob: 68691a4efd2785d364950850ea5ac1471f2d47c9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
connection node_2;
connection node_1;
CREATE TABLE t1 (a INT) ENGINE=InnoDB;
START TRANSACTION;
INSERT INTO t1 VALUES (1);
LOCK TABLES t2 READ;
ERROR 42S02: Table 'test.t2' doesn't exist
START TRANSACTION;
INSERT INTO t1 VALUES (1);
LOCK TABLES t1 READ;
UNLOCK TABLES;
DROP TABLE t1;