diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb/t/tbl_standard_opts.test')
-rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/t/tbl_standard_opts.test | 42 |
1 files changed, 42 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/t/tbl_standard_opts.test b/storage/rocksdb/mysql-test/rocksdb/t/tbl_standard_opts.test new file mode 100644 index 00000000..5d60c02a --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/t/tbl_standard_opts.test @@ -0,0 +1,42 @@ +--source include/have_rocksdb.inc + +# +# Standard options in CREATE and ALTER TABLE +# +# Note: the test does not check whether the options +# have any real effect on the table, only +# that they are accepted +# + +--disable_warnings +DROP TABLE IF EXISTS t1; +--enable_warnings + +# Create table with standard options + +CREATE TABLE t1 (a INT PRIMARY KEY, b CHAR(8)) ENGINE=rocksdb + DEFAULT CHARACTER SET = utf8 + COLLATE = utf8_general_ci + COMMENT = 'standard table options' +; +SHOW CREATE TABLE t1; + +# Alter comment + +ALTER TABLE t1 COMMENT = 'table altered'; +SHOW CREATE TABLE t1; + +# Alter ENGINE value + +ALTER TABLE t1 ENGINE=MEMORY; +SHOW CREATE TABLE t1; +ALTER TABLE t1 ENGINE=rocksdb; +SHOW CREATE TABLE t1; + +# Alter character set and collation + +ALTER TABLE t1 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci; +SHOW CREATE TABLE t1; + +DROP TABLE t1; + |