18 lines
766 B
Plaintext
18 lines
766 B
Plaintext
DROP TABLE IF EXISTS is_ddl_t1;
|
|
DROP TABLE IF EXISTS is_ddl_t2;
|
|
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 = XENGINE;
|
|
CREATE TABLE is_ddl_t2 (x INT, y INT, z INT,
|
|
PRIMARY KEY (z, y) COMMENT 'zy_cf',
|
|
KEY (x)) ENGINE = XENGINE;
|
|
SELECT TABLE_SCHEMA,TABLE_NAME,PARTITION_NAME,INDEX_NAME,INDEX_TYPE,KV_FORMAT_VERSION FROM INFORMATION_SCHEMA.XENGINE_DDL WHERE TABLE_NAME like 'is_ddl_t%' ORDER BY TABLE_NAME,INDEX_TYPE, INDEX_NAME;
|
|
TABLE_SCHEMA TABLE_NAME PARTITION_NAME INDEX_NAME INDEX_TYPE KV_FORMAT_VERSION
|
|
test is_ddl_t1 NULL PRIMARY 1 11
|
|
test is_ddl_t1 NULL j 2 11
|
|
test is_ddl_t1 NULL k 2 11
|
|
test is_ddl_t2 NULL PRIMARY 1 11
|
|
test is_ddl_t2 NULL x 2 11
|
|
DROP TABLE is_ddl_t1;
|
|
DROP TABLE is_ddl_t2;
|