TableGroup支持Range 分区 example

OceanBase 技术问题
#1

【产品名称】

【产品版本】

【问题描述】社区版目前支持Range Columns 类型的分区表表组吗？

#2

在社区版3.1.2版本测试了，确实是不支持。

#3

可以支持的

create tablegroup tg1 partition by range columns 1 (partition p0 values less than ("ee" collate utf8_bin));
create tablegroup tg2 partition by list columns 1 (partition p0 values in ("ee" collate utf8_bin));
create table t(c1 varchar(10) collate utf8_bin, c2 int) tablegroup tg1 partition by range columns(c1) (partition p0 values less than ("ee"));
create table t2(c1 varchar(10) collate utf8_bin, c2 int) tablegroup tg2 partition by list columns(c1) (partition p0 values in ("ee"));

create tablegroup tg4 partition by range columns 1 
(
 PARTITION p9 VALUES LESS THAN (20180901) ,
 PARTITION p10 VALUES LESS THAN (20181001) ,
 PARTITION p11 VALUES LESS THAN (20181101) ,
  PARTITION p12 VALUES LESS THAN (20181201) 
);

CREATE TABLE testrange4(
  num      int NOT NULL,
  var           varchar(10)
)TABLEGROUP = tg4
PARTITION BY RANGE columns(num)
 (
 PARTITION p9 VALUES LESS THAN (20180901) ,
 PARTITION p10 VALUES LESS THAN (20181001) ,
 PARTITION p11 VALUES LESS THAN (20181101) ,
  PARTITION p12 VALUES LESS THAN (20181201) 
 );