mariadb/storage/rocksdb/mysql-test/rocksdb/t/autoinc_secondary.test
Sergei Petrunia ebfc4e6ad0 Initial commit,
copy of
commit 86587affafe77ef555f7c3839839de44f0f203f3
Author: Tian Xia <tianx@fb.com>
Date:   Tue Oct 4 10:01:52 2016 -0700

    Allow filtering of show commands through admission control
2016-10-06 17:24:09 +00:00

16 lines
345 B
Text

--source include/have_rocksdb.inc
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
CREATE TABLE t1 (pk INT PRIMARY KEY, a INT AUTO_INCREMENT, KEY(a)) ENGINE=rocksdb;
INSERT INTO t1 (pk) VALUES (3), (2), (1);
SELECT * FROM t1;
--source include/restart_mysqld.inc
INSERT INTO t1 (pk) VALUES (4);
SELECT * FROM t1;
DROP TABLE t1;