github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/ddl/partition2.sql (about)

     1  drop table if exists t1;
     2  drop table if exists t2;
     3  drop table if exists t3;
     4  drop table if exists t4;
     5  drop table if exists t5;
     6  drop table if exists t6;
     7  drop table if exists t7;
     8  drop table if exists t8;
     9  drop table if exists t9;
    10  drop table if exists t10;
    11  drop table if exists t11;
    12  create table t1(a int,b int) partition by hash(a) partitions 2;
    13  create table t2(a int,b int) partition by hash(a) partitions 2 (partition x, partition y);
    14  create table t3(a int,b int) partition by hash(a) partitions 3 (partition x, partition y);
    15  create table t4(a int,b int) partition by key(a) partitions 2;
    16  create table t5(a int,b int) partition by key() partitions 2;
    17  create table t6(a int primary key ,b int) partition by key(a) partitions 2;
    18  create table t7(a int primary key ,b int) partition by key(b) partitions 2;
    19  create table t8(a int,b int,primary key (a,b)) partition by key(b) partitions 2;
    20  create table t9(a int unique key ,b int) partition by key(a) partitions 2;
    21  create table t10(a int,b int) partition by key(a) partitions 2 (partition x, partition y);
    22  create table t11(a int,b int) partition by key(a) partitions 3 (partition x, partition y);
    23  show tables;
    24  drop table if exists t1;
    25  drop table if exists t2;
    26  drop table if exists t3;
    27  drop table if exists t4;
    28  drop table if exists t5;
    29  drop table if exists t6;
    30  drop table if exists t7;
    31  drop table if exists t8;
    32  drop table if exists t9;
    33  drop table if exists t10;
    34  drop table if exists t11;