1--source include/have_rocksdb.inc 2 3# 4# Check whether PASSWORD option 5# is supported in CREATE and ALTER TABLE 6# 7# Note: the test does not check whether the option 8# has any real effect on the table, only 9# that it's accepted 10# 11# This option is not supported by any known engines, 12# that's why the result file does not contain it; 13# but it's syntactically acceptable. 14# 15 16--disable_warnings 17DROP TABLE IF EXISTS t1; 18--enable_warnings 19 20CREATE TABLE t1 (a INT PRIMARY KEY, b CHAR(8)) ENGINE=rocksdb PASSWORD='password'; 21SHOW CREATE TABLE t1; 22 23ALTER TABLE t1 PASSWORD='new_password'; 24SHOW CREATE TABLE t1; 25 26DROP TABLE t1; 27 28