diff options
Diffstat (limited to '')
| -rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/r/i_s_ddl.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/r/i_s_ddl.result b/storage/rocksdb/mysql-test/rocksdb/r/i_s_ddl.result new file mode 100644 index 00000000..6bca2cba --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/r/i_s_ddl.result @@ -0,0 +1,22 @@ +DROP TABLE IF EXISTS is_ddl_t1; +DROP TABLE IF EXISTS is_ddl_t2; +DROP TABLE IF EXISTS is_ddl_t3; +CREATE TABLE is_ddl_t1 (i INT, j INT, k INT, l INT, +PRIMARY KEY (i), KEY (j), KEY (k, l) COMMENT 'kl_cf') +ENGINE = ROCKSDB; +CREATE TABLE is_ddl_t2 (x INT, y INT, z INT, +PRIMARY KEY (z, y) COMMENT 'zy_cf', +KEY (x)) ENGINE = ROCKSDB; +CREATE TABLE is_ddl_t3 (a INT, b INT, c INT, PRIMARY KEY (a)) ENGINE = ROCKSDB +COMMENT "ttl_duration=3600;"; +SELECT 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%'; +TABLE_SCHEMA TABLE_NAME PARTITION_NAME INDEX_NAME INDEX_TYPE KV_FORMAT_VERSION CF TTL_DURATION INDEX_FLAGS +test is_ddl_t1 NULL PRIMARY 1 13 default 0 0 +test is_ddl_t1 NULL j 2 13 default 0 0 +test is_ddl_t1 NULL k 2 13 kl_cf 0 0 +test is_ddl_t2 NULL PRIMARY 1 13 zy_cf 0 0 +test is_ddl_t2 NULL x 2 13 default 0 0 +test is_ddl_t3 NULL PRIMARY 1 13 default 3600 1 +DROP TABLE is_ddl_t1; +DROP TABLE is_ddl_t2; +DROP TABLE is_ddl_t3; |