tidb4.0.0 关于分区语法的问题(REORGANIZE PARTITION)

前提:

  • tidb版本4.0.0

问题:

1、使用分区语句REORGANIZE PARTITION tidb报错不支持,想问下tidb后续版本是否会支持这个拆分分区的语句。

image
使用例子:

CREATE TABLE `deliver_sale` (
  `code` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '客户编码',
  `name` varchar(200) COLLATE utf8_bin DEFAULT NULL COMMENT '客户名称',
  `file_id` varchar(500) COLLATE utf8_bin DEFAULT NULL COMMENT '原始文件ID',
  `seller_date` date NOT NULL COMMENT '销售日期',
  PRIMARY KEY (`seller_date`),
  KEY `index_source_file_id` (`file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='销售数据'
PARTITION BY RANGE ( TO_DAYS(`seller_date`) ) (
  PARTITION `p01` VALUES LESS THAN ( TO_DAYS('2020-01-25')),
  PARTITION `p02` VALUES LESS THAN ( TO_DAYS('2020-02-25')),
  PARTITION `p03` VALUES LESS THAN ( TO_DAYS('2020-03-25')),
  PARTITION `p04` VALUES LESS THAN ( TO_DAYS('2020-04-25')),
  PARTITION `p05` VALUES LESS THAN ( TO_DAYS('2020-05-25')),

);

# 新增分区
ALTER TABLE test.deliver_sale ADD PARTITION (PARTITION p06 VALUES LESS THAN ( TO_DAYS('2020-06-25')));
ALTER TABLE test.deliver_sale ADD PARTITION (PARTITION p07 VALUES LESS THAN ( TO_DAYS('2020-07-25')));

# 拆分分区
ALTER TABLE test.deliver_sale REORGANIZE PARTITION p07 INTO (
		PARTITION s0 VALUES LESS THAN ( TO_DAYS('2020-07-15')),
		PARTITION s1 VALUES LESS THAN ( TO_DAYS('2020-07-25'))
);

您好,目前此 功能 还没有计划进行支持.
也欢迎您在 github 上提交此 Feature 需求
https://docs.pingcap.com/zh/tidb/stable/report-issue

好的多谢

:ok_hand:

https://github.com/pingcap/tidb/issues/15000