-- create table with partitions ;
CREATE TABLE sbtest0000(
  id bigint,
  k bigint DEFAULT '0' NOT NULL,
  c CHAR(120) DEFAULT '' NOT NULL,
  pad CHAR(60) DEFAULT '' NOT NULL,
  UNIQUE KEY uk(id),
  key idx0(k,c),
  key idx1(c)
)SHARD_ROW_ID_BITS=3 PRE_SPLIT_REGIONS=2
PARTITION BY RANGE(id)(PARTITION p VALUES LESS THAN (MAXVALUE));
-- show regions for table;
show table sbtest0000 regions;

-- create table ;
CREATE TABLE sbtest1111(
  id bigint,
  k bigint DEFAULT '0' NOT NULL,
  c CHAR(120) DEFAULT '' NOT NULL,
  pad CHAR(60) DEFAULT '' NOT NULL,
  UNIQUE KEY uk(id),
  key idx0(k,c),
  key idx1(c)
)SHARD_ROW_ID_BITS=3 PRE_SPLIT_REGIONS=2;
-- show regions for table;
show table sbtest1111 regions;