diff options
Diffstat (limited to '')
-rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/t/tbl_opt_key_block_size.test | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/t/tbl_opt_key_block_size.test b/storage/rocksdb/mysql-test/rocksdb/t/tbl_opt_key_block_size.test new file mode 100644 index 00000000..d927c785 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/t/tbl_opt_key_block_size.test @@ -0,0 +1,23 @@ +--source include/have_rocksdb.inc + +# +# Check whether KEY_BLOCK_SIZE option +# is supported in CREATE and ALTER TABLE +# +# Note: the test does not check whether the option +# has any real effect on the table, only +# that it's accepted +# + +--disable_warnings +DROP TABLE IF EXISTS t1; +--enable_warnings + +CREATE TABLE t1 (a INT PRIMARY KEY, b CHAR(8)) ENGINE=rocksdb KEY_BLOCK_SIZE=8; +SHOW CREATE TABLE t1; + +ALTER TABLE t1 KEY_BLOCK_SIZE=1; +SHOW CREATE TABLE t1; + +DROP TABLE t1; + |