Debian Codegraph @

mysql-test/suite/archive/flush.test

raw
1 --source include/have_archive.inc
2
3 let $MYSQLD_DATADIR= `SELECT @@datadir`;
4 CREATE TABLE t1(a INT) ENGINE=archive;
5 INSERT INTO t1 VALUES(1);
6 # Works correct if we uncomment next row
7 #FLUSH TABLE t1;
8
9 connect(con1, localhost, root);
10 LOCK TABLE t1 READ;
11
12 connection default;
13 FLUSH TABLES WITH READ LOCK;
14 copy_file $MYSQLD_DATADIR/test/t1.frm $MYSQLD_DATADIR/test/t2.frm;
15 copy_file $MYSQLD_DATADIR/test/t1.ARZ $MYSQLD_DATADIR/test/t2.ARZ;
16 UNLOCK TABLES;
17 --echo # Must return 1 row
18 SELECT * FROM t2;
19 SELECT * FROM t1;
20
21 connection con1;
22 UNLOCK TABLES;
23
24 connection default;
25 DROP TABLE t1, t2;