Debian Codegraph @

mysql-test/suite/csv/flush.result

raw
1 CREATE TABLE t1(a INT NOT NULL) ENGINE=csv;
2 INSERT INTO t1 VALUES(1);
3 connect con1, localhost, root;
4 LOCK TABLE t1 READ;
5 connection default;
6 FLUSH TABLES WITH READ LOCK;
7 UNLOCK TABLES;
8 # Must return 1 row
9 SELECT * FROM t2;
10 a
11 1
12 SELECT * FROM t1;
13 a
14 1
15 connection con1;
16 UNLOCK TABLES;
17 connection default;
18 INSERT INTO t2 VALUES(2);
19 INSERT INTO t2 VALUES(2);
20 SELECT * from t1,t2;
21 a a
22 1 1
23 1 2
24 1 2
25 DROP TABLE t1, t2;