mysql-test/suite/archive/flush.result
raw| 1 | CREATE TABLE t1(a INT) ENGINE=archive; |
| 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 | DROP TABLE t1, t2; |