summaryrefslogtreecommitdiffstats
path: root/storage/rocksdb/mysql-test/rocksdb/t/duplicate_table.test
blob: 875f8514d8f59243e1b333e26a689a282d331616 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
--source include/have_rocksdb.inc
--disable_warnings
DROP TABLE IF EXISTS t;
--enable_warnings
CREATE TABLE t(id int primary key) engine=rocksdb;
INSERT INTO t values (1), (2), (3); 
--error ER_TABLE_EXISTS_ERROR 
CREATE TABLE t(id int primary key) engine=rocksdb;
FLUSH TABLES;
move_file $MYSQLTEST_VARDIR/mysqld.1/data/test/t.frm $MYSQLTEST_VARDIR/mysqld.1/data/test/t.frm.tmp;
--error ER_METADATA_INCONSISTENCY
CREATE TABLE t(id int primary key) engine=rocksdb;
move_file $MYSQLTEST_VARDIR/mysqld.1/data/test/t.frm.tmp $MYSQLTEST_VARDIR/mysqld.1/data/test/t.frm;
FLUSH TABLES;
SELECT * FROM t;
DROP TABLE t;