CREATE TABLE t (curdate bigint, id integer, name varchar(20))
partition BY range(curdate)
subpartition BY range (id)
subpartition template
(
subpartition sp1,
subpartition sp2,
subpartition sp3,
subpartition sp4
)
(
partition p1 VALUES less than (100),
partition p2 VALUES less than (200),
partition p3 VALUES less than (300),
partition p4 VALUES less than (400)
);
我按照上述建的分区表，为什么子分区名字变成了p1sp0~p4sp3 名字应该是p1sp1~p4sp4才对啊。咋个自动把名字换了哪？
你是怎么查的？
我这在3.1.3-ce-bp版本上创建了，通过show create table 和select * from information_schema.partitions where table_name='x';两种方式查分区名称都是对的；
CREATE TABLE t_range_range (c1 int, c2 int, c3 int) partition BY range(c1)
subpartition BY range (c2)
subpartition template
(
subpartition rp1 VALUES less than (100),
subpartition rp2 VALUES less than (200),
subpartition rp3 VALUES less than (300)
)
(
partition p0 VALUES less than (100),
partition p1 VALUES less than (200),
partition p2 VALUES less than (300)
);
我看是他把我的建表语句的名字给变了
