Debian Codegraph @

mysql-test/suite/csv/flush.test

raw
1 --source include/have_csv.inc
2
3 let $MYSQLD_DATADIR= `SELECT @@datadir`;
4 CREATE TABLE t1(a INT NOT NULL) ENGINE=csv;
5 INSERT INTO t1 VALUES(1);
6 # works correct if uncommented
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.CSV $MYSQLD_DATADIR/test/t2.CSV;
16 copy_file $MYSQLD_DATADIR/test/t1.CSM $MYSQLD_DATADIR/test/t2.CSM;
17 UNLOCK TABLES;
18 --echo # Must return 1 row
19 SELECT * FROM t2;
20 SELECT * FROM t1;
21 connection con1;
22 UNLOCK TABLES;
23
24 connection default;
25
26 INSERT INTO t2 VALUES(2);
27 INSERT INTO t2 VALUES(2);
28 SELECT * from t1,t2;
29
30 DROP TABLE t1, t2;