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