以下语句再输出时,没有包含 global 索引的分区说明信息。
create table mytt (
field1 int,
field2 int,
field3 int,
field4 int,
PRIMARY KEY(field1, field2)
) DEFAULT CHARSET=utf8mb4 COMMENT='test表';
CREATE INDEX f4 ON mytt(field4) GLOBAL PARTITION by key(field4) partitions 3;
show create table mytt;
会输出如下格式:
CREATE TABLE `mytt` (
`field1` int(11) NOT NULL,
`field2` int(11) NOT NULL,
`field3` int(11) DEFAULT NULL,
`field4` int(11) DEFAULT NULL,
PRIMARY KEY (`field1`, `field2`),
KEY `f4` (`field4`) BLOCK_SIZE 16384 GLOBAL
) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = COMPACT COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0 COMMENT = 'test表'