1--source include/have_rocksdb.inc 2 3# 4# Information Schema DDL 5# 6 7--disable_warnings 8DROP TABLE IF EXISTS is_ddl_t1; 9DROP TABLE IF EXISTS is_ddl_t2; 10DROP TABLE IF EXISTS is_ddl_t3; 11--enable_warnings 12 13CREATE TABLE is_ddl_t1 (i INT, j INT, k INT, l INT, 14 PRIMARY KEY (i), KEY (j), KEY (k, l) COMMENT 'kl_cf') 15 ENGINE = ROCKSDB; 16 17CREATE TABLE is_ddl_t2 (x INT, y INT, z INT, 18 PRIMARY KEY (z, y) COMMENT 'zy_cf', 19 KEY (x)) ENGINE = ROCKSDB; 20CREATE TABLE is_ddl_t3 (a INT, b INT, c INT, PRIMARY KEY (a)) ENGINE = ROCKSDB 21 COMMENT "ttl_duration=3600;"; 22 23--sorted_result 24SELECT TABLE_SCHEMA,TABLE_NAME,PARTITION_NAME,INDEX_NAME,INDEX_TYPE,KV_FORMAT_VERSION,CF,TTL_DURATION,INDEX_FLAGS FROM INFORMATION_SCHEMA.ROCKSDB_DDL WHERE TABLE_NAME like 'is_ddl_t%'; 25 26# cleanup 27DROP TABLE is_ddl_t1; 28DROP TABLE is_ddl_t2; 29DROP TABLE is_ddl_t3; 30