github.com/matrixorigin/matrixone@v0.7.0/test/distributed/cases/ddl/partition.result (about)

     1  drop table if exists pt_table_1;
     2  drop table if exists pt_table_2;
     3  drop table if exists pt_table_3;
     4  drop table if exists pt_table_5;
     5  drop table if exists pt_table_6;
     6  drop table if exists pt_table_21;
     7  drop table if exists pt_table_22;
     8  drop table if exists pt_table_23;
     9  drop table if exists pt_table_24;
    10  drop table if exists pt_table_31;
    11  drop table if exists pt_table_32;
    12  drop table if exists pt_table_33;
    13  drop table if exists pt_table_34;
    14  drop table if exists pt_table_35;
    15  drop table if exists pt_table_36;
    16  drop table if exists pt_table_37;
    17  drop table if exists pt_table_41;
    18  drop table if exists pt_table_42;
    19  drop table if exists pt_table_43;
    20  drop table if exists pt_table_44;
    21  drop table if exists pt_table_45;
    22  create table pt_table_1(col1 tinyint,col2 smallint,col3 int,clo4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text,primary key(col1))partition by hash(col1)partitions 4;
    23  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_1;
    24  select col1 from pt_table_1;
    25  col1
    26  -62
    27  91
    28  33
    29  121
    30  40
    31  -8
    32  -75
    33  21
    34  -93
    35  110
    36  122
    37  create table pt_table_2(col1 tinyint,col2 smallint,col3 int,clo4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text,primary key(col5))partition by hash(col5);
    38  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_2;
    39  select col5 from pt_table_2;
    40  col5
    41  154
    42  122
    43  104
    44  141
    45  79
    46  82
    47  234
    48  28
    49  89
    50  98
    51  56
    52  create table pt_table_3(col1 tinyint not null,col2 smallint,col3 int,clo4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 char(255) default 'style nine',primary key(col1,col20))partition by hash(col1)partitions 4;
    53  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_3;
    54  select col1 from pt_table_3;
    55  col1
    56  -62
    57  91
    58  33
    59  121
    60  40
    61  -8
    62  -75
    63  21
    64  -93
    65  110
    66  122
    67  create table pt_table_5(col1 tinyint,col2 smallint,col3 int,clo4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 char(255))partition by hash(year(col12));
    68  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_3;
    69  Duplicate entry '2813c14601473b4b4c2f4d4e3f4f5051522e5354552d5f2b3d5a616263646566676869676b6c00' for key '__mo_cpkey_004col1005col20'
    70  select col12 from pt_table_5;
    71  col12
    72  show create table pt_table_5;
    73  Table    Create Table
    74  pt_table_5    CREATE TABLE `pt_table_5` (\n`col1` TINYINT DEFAULT NULL,\n`col2` SMALLINT DEFAULT NULL,\n`col3` INT DEFAULT NULL,\n`clo4` BIGINT DEFAULT NULL,\n`col5` TINYINT UNSIGNED DEFAULT NULL,\n`col6` SMALLINT UNSIGNED DEFAULT NULL,\n`col7` INT UNSIGNED DEFAULT NULL,\n`col8` BIGINT UNSIGNED DEFAULT NULL,\n`col9` FLOAT DEFAULT NULL,\n`col10` DOUBLE DEFAULT NULL,\n`col11` VARCHAR(255) DEFAULT NULL,\n`col12` DATE DEFAULT NULL,\n`col13` DATETIME DEFAULT NULL,\n`col14` TIMESTAMP DEFAULT NULL,\n`col15` BOOL DEFAULT NULL,\n`col16` DECIMAL(5,2) DEFAULT NULL,\n`col17` TEXT DEFAULT NULL,\n`col18` VARCHAR(255) DEFAULT NULL,\n`col19` VARCHAR(255) DEFAULT NULL,\n`col20` CHAR(255) DEFAULT NULL\n) partition by hash (year(col12))
    75  create table pt_table_6(col1 tinyint,col2 smallint,col3 int,clo4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text)partition by LINEAR hash(col2)partitions 10;
    76  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_6;
    77  select col2 from pt_table_6;
    78  col2
    79  5807
    80  19514
    81  4300
    82  -22564
    83  30792
    84  -30001
    85  11896
    86  775
    87  -18596
    88  -23777
    89  19053
    90  create table pt_table_10(col1 tinyint,col2 smallint,col3 int,primary key(col1))partition by hash(col2);
    91  invalid input: partition key is not part of primary key
    92  create table pt_table_11(col1 tinyint,col2 smallint,col3 int,clo4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text)partition by hash(col9) partitions 6;
    93  SQL syntax error: type FLOAT not allowed in partition clause
    94  create table pt_table_12(col1 tinyint,col2 smallint,col3 int,clo4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 char(255))partition by hash(col20);
    95  SQL syntax error: type CHAR not allowed in partition clause
    96  create table pt_table_13(col1 tinyint,col2 smallint,col3 int,clo4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 char(255))partition by hash(col12);
    97  SQL syntax error: type DATE not allowed in partition clause
    98  create table pt_table_13(col1 tinyint,col2 smallint,col3 int,clo4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 char(255))partition by (col12);
    99  SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 351 near " (col12);";
   100  create table pt_table_21(col1 tinyint,col2 smallint,col3 int,clo4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text,primary key(col2))partition by key(col2)partitions 4;
   101  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_21;
   102  select col2 from pt_table_21;
   103  col2
   104  5807
   105  19514
   106  4300
   107  -22564
   108  30792
   109  -30001
   110  11896
   111  775
   112  -18596
   113  -23777
   114  19053
   115  create table pt_table_22(col1 tinyint,col2 smallint,col3 int,clo4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text,primary key(col6,col18))partition by key(col6,col18)partitions 4;
   116  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_22;
   117  select col2 from pt_table_22;
   118  col2
   119  5807
   120  19514
   121  4300
   122  -22564
   123  30792
   124  -30001
   125  11896
   126  775
   127  -18596
   128  -23777
   129  19053
   130  create table pt_table_23(col1 tinyint,col2 smallint,col3 int,clo4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text,primary key(col19))partition by key(col19)partitions 4;
   131  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_23;
   132  select col19 from pt_table_23;
   133  col19
   134  +=Zab
   135  R.STU-_+=Zabcdefghigklmnopqrstuvw
   136  U-_+=Zabcdefghigklmno
   137  /MN?OPQR.STU-_+=Zabcdefghigklmnopqrstuvw
   138  STU-_+=Zabcdefghigklmnopqrstuvwxyz01
   139  R.STU-_+=Zabcdefghigklmnopqrstuvwxyz0123456
   140  I,G;KL/MN?OPQR.STU-_+=Zabcdefghigklmnopq
   141  TU-_+=Zabcdefghigklmnopqrstuvwxyz01234567
   142  DEF,GHI,G;KL/MN?OPQR.STU-_+=Zabcdefghigklmnopqrstuvwxyz0123456
   143  ;KL/MN?OPQR.STU-_+=Zabcdefghigklmno
   144  -_+=Zabcdefghigklmnopqr
   145  create table pt_table_24(col1 tinyint,col2 smallint,col3 int,clo4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text)partition by key(col13)partitions 10;
   146  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_24;
   147  select col13 from pt_table_24;
   148  col13
   149  5732-08-07 00:00:00
   150  9976-06-04 00:00:00
   151  3647-01-21 23:59:59
   152  6216-12-30 00:00:00
   153  7031-10-23 00:00:00
   154  6868-02-03 00:00:00
   155  4844-01-09 23:59:59
   156  6438-11-29 00:00:00
   157  3114-10-05 23:59:59
   158  1014-07-01 23:59:59
   159  4023-04-27 23:59:59
   160  create table pt_table_31(col1 tinyint,col2 smallint,col3 int,col4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text,primary key(col3))partition by range(col3)(PARTITION p0 VALUES LESS THAN (100),PARTITION p1 VALUES LESS THAN (2000),PARTITION p2 VALUES LESS THAN (4000),PARTITION p3 VALUES LESS THAN (6000),PARTITION p5 VALUES LESS THAN MAXVALUE);
   161  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_31;
   162  select col2 from pt_table_31;
   163  col2
   164  5807
   165  19514
   166  4300
   167  -22564
   168  30792
   169  -30001
   170  11896
   171  775
   172  -18596
   173  -23777
   174  19053
   175  create table pt_table_32(col1 tinyint,col2 smallint,col3 int,col4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text)partition by range(col7)(PARTITION p0 VALUES LESS THAN (100),PARTITION p1 VALUES LESS THAN (2000),PARTITION p2 VALUES LESS THAN (4000),PARTITION p3 VALUES LESS THAN (6000),PARTITION p5 VALUES LESS THAN MAXVALUE);
   176  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_32;
   177  select col2 from pt_table_32;
   178  col2
   179  5807
   180  19514
   181  4300
   182  -22564
   183  30792
   184  -30001
   185  11896
   186  775
   187  -18596
   188  -23777
   189  19053
   190  create table pt_table_33(col1 tinyint,col2 smallint,col3 int,col4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 char(255),primary key(col3,col7))partition by range(col7)(PARTITION p0 VALUES LESS THAN (100),PARTITION p1 VALUES LESS THAN (2000),PARTITION p2 VALUES LESS THAN (4000),PARTITION p3 VALUES LESS THAN (6000),PARTITION p5 VALUES LESS THAN MAXVALUE);
   191  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_33;
   192  select col2 from pt_table_33;
   193  col2
   194  5807
   195  19514
   196  4300
   197  -22564
   198  30792
   199  -30001
   200  11896
   201  775
   202  -18596
   203  -23777
   204  19053
   205  create table pt_table_34(col1 tinyint,col2 smallint,col3 int,col4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text)partition by range(year(col14))(PARTITION p0 VALUES LESS THAN (1991) comment ='expression range',PARTITION p1 VALUES LESS THAN (2000),PARTITION p2 VALUES LESS THAN (2009)comment ='range',PARTITION p3 VALUES LESS THAN (2010),PARTITION p5 VALUES LESS THAN MAXVALUE);
   206  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_34;
   207  select col14 from pt_table_34;
   208  col14
   209  1975-09-09 23:59:59
   210  1985-01-12 23:59:59
   211  2034-02-10 00:00:00
   212  2011-03-10 00:00:00
   213  1977-03-18 23:59:59
   214  2036-08-23 00:00:00
   215  2037-12-04 00:00:00
   216  2035-05-25 00:00:00
   217  2014-09-26 00:00:00
   218  1996-08-27 23:59:59
   219  2011-10-04 00:00:00
   220  create table pt_table_35(col1 tinyint not null,col2 smallint,col3 int not null,col4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text,primary key(col3,col1))partition by range columns(col1,col3)(PARTITION p0 VALUES LESS THAN (100,300),PARTITION p1 VALUES LESS THAN (300,500),PARTITION p2 VALUES LESS THAN (500,MAXVALUE),PARTITION p3 VALUES LESS THAN (6000,MAXVALUE),PARTITION p4 VALUES LESS THAN (MAXVALUE,MAXVALUE));
   221  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_35;
   222  select col14 from pt_table_35;
   223  col14
   224  1975-09-09 23:59:59
   225  1985-01-12 23:59:59
   226  2034-02-10 00:00:00
   227  2011-03-10 00:00:00
   228  1977-03-18 23:59:59
   229  2036-08-23 00:00:00
   230  2037-12-04 00:00:00
   231  2035-05-25 00:00:00
   232  2014-09-26 00:00:00
   233  1996-08-27 23:59:59
   234  2011-10-04 00:00:00
   235  create table pt_table_36(col1 tinyint,col2 smallint,col3 int,col4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text,primary key(col3))partition by range(col3)(PARTITION p0 VALUES LESS THAN (100+50),PARTITION p1 VALUES LESS THAN (2000+100),PARTITION p2 VALUES LESS THAN (4000),PARTITION p3 VALUES LESS THAN (6000),PARTITION p5 VALUES LESS THAN MAXVALUE);
   236  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_36;
   237  select col2 from pt_table_36;
   238  col2
   239  5807
   240  19514
   241  4300
   242  -22564
   243  30792
   244  -30001
   245  11896
   246  775
   247  -18596
   248  -23777
   249  19053
   250  create table pt_table_37(col1 tinyint,col2 smallint,col3 int,col4 bigint)partition by range(col90)(PARTITION p0 VALUES LESS THAN (100),PARTITION p1 VALUES LESS THAN (2000),PARTITION p2 VALUES LESS THAN (4000),PARTITION p3 VALUES LESS THAN (6000),PARTITION p5 VALUES LESS THAN MAXVALUE);
   251  invalid input: column col90 does not exist
   252  create table pt_table_37(col1 tinyint,col11 varchar(255),col12 Date)partition by range(col11)(PARTITION p0 VALUES LESS THAN (100),PARTITION p1 VALUES LESS THAN (2000),PARTITION p2 VALUES LESS THAN (4000),PARTITION p3 VALUES LESS THAN (6000),PARTITION p5 VALUES LESS THAN MAXVALUE);
   253  SQL syntax error: type VARCHAR not allowed in partition clause
   254  create table pt_table_37(col1 tinyint,col11 varchar(255),col12 timestamp)partition by range(col12)(PARTITION p0 VALUES LESS THAN (100),PARTITION p1 VALUES LESS THAN (2000),PARTITION p2 VALUES LESS THAN (4000),PARTITION p3 VALUES LESS THAN (6000),PARTITION p5 VALUES LESS THAN MAXVALUE);
   255  SQL syntax error: type TIMESTAMP not allowed in partition clause
   256  create table pt_table_37(col1 tinyint,col11 float,col12 timestamp)partition by range(col11)(PARTITION p0 VALUES LESS THAN (1991),PARTITION p1 VALUES LESS THAN (2000),PARTITION p2 VALUES LESS THAN (2009),PARTITION p3 VALUES LESS THAN (2010),PARTITION p5 VALUES LESS THAN MAXVALUE);
   257  SQL syntax error: type FLOAT not allowed in partition clause
   258  create table pt_table_37(col1 tinyint,col11 float,col12 timestamp)partition by range(ceil(col11))(PARTITION p0 VALUES LESS THAN (100),PARTITION p1 VALUES LESS THAN (2000),PARTITION p2 VALUES LESS THAN (4000),PARTITION p3 VALUES LESS THAN (6000),PARTITION p5 VALUES LESS THAN MAXVALUE);
   259  SQL syntax error: type DOUBLE not allowed in partition clause
   260  create table pt_table_37(col1 tinyint,col11 float,col12 timestamp)partition by range(col1);
   261  invalid input: range partition cannot be empty
   262  create table pt_table_41(col1 tinyint,col2 smallint,col3 int,col4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text,primary key(col4))partition by list(col4) (PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
   263  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_41;
   264  select col8 from pt_table_41;
   265  col8
   266  14999475422109240954
   267  6204822205090614210
   268  17397115807377870895
   269  3143191107533743301
   270  13381191796017069332
   271  8740918055557791046
   272  4029688785176298663
   273  6625004793680807495
   274  16635491969502097586
   275  7094376021034692269
   276  18225693328091251880
   277  create table pt_table_42(col1 tinyint,col2 smallint,col3 int,col4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text)partition by list(col8) (PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
   278  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_42;
   279  select col8 from pt_table_42;
   280  col8
   281  14999475422109240954
   282  6204822205090614210
   283  17397115807377870895
   284  3143191107533743301
   285  13381191796017069332
   286  8740918055557791046
   287  4029688785176298663
   288  6625004793680807495
   289  16635491969502097586
   290  7094376021034692269
   291  18225693328091251880
   292  create table pt_table_43(col1 tinyint,col2 smallint,col3 int,col4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text)partition by list(col10) (PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
   293  SQL syntax error: type DOUBLE not allowed in partition clause
   294  create table pt_table_44(col1 tinyint,col2 smallint,col3 int,col4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text,primary key(col3,col4))partition by list columns(col3,col4) (PARTITION p0 VALUES IN( (0,0), (NULL,NULL) ),PARTITION p1 VALUES IN( (0,1), (0,2), (0,3), (1,1), (1,2)) comment='list column comment' ,PARTITION p2 VALUES IN( (1,0), (2,0), (2,1), (3,0), (3,1) ),PARTITION p3 VALUES IN( (1,3), (2,2), (2,3), (3,2), (3,3) ));
   295  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_44;
   296  select col3,col4 from pt_table_44;
   297  col3    col4
   298  -1889972806    7769629822818484334
   299  -179559641    1234138289513302348
   300  1287532466    -3038428195984464330
   301  1124555433    -1681456935776973509
   302  476482983    -484407619835391694
   303  -1030254547    -5246968895134993792
   304  -232972021    -3237107390156157130
   305  330484802    -2998549470145089608
   306  837702822    6123486173032718578
   307  -1006909301    -6041648745842399623
   308  1449911253    2267877015687134490
   309  create table pt_table_45(col1 tinyint,col2 smallint,col3 int,col4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text)partition by list(year(col13))(PARTITION r0 VALUES IN (1999, 2001, 2003),PARTITION r1 VALUES IN (2002, 2004, 2005),PARTITION r2 VALUES IN (2006, 2007, 2008));
   310  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_45;
   311  select col3,col4 from pt_table_45;
   312  col3    col4
   313  -1889972806    7769629822818484334
   314  -179559641    1234138289513302348
   315  1287532466    -3038428195984464330
   316  1124555433    -1681456935776973509
   317  476482983    -484407619835391694
   318  -1030254547    -5246968895134993792
   319  -232972021    -3237107390156157130
   320  330484802    -2998549470145089608
   321  837702822    6123486173032718578
   322  -1006909301    -6041648745842399623
   323  1449911253    2267877015687134490
   324  show create table pt_table_45;
   325  Table    Create Table
   326  pt_table_45    CREATE TABLE `pt_table_45` (\n`col1` TINYINT DEFAULT NULL,\n`col2` SMALLINT DEFAULT NULL,\n`col3` INT DEFAULT NULL,\n`col4` BIGINT DEFAULT NULL,\n`col5` TINYINT UNSIGNED DEFAULT NULL,\n`col6` SMALLINT UNSIGNED DEFAULT NULL,\n`col7` INT UNSIGNED DEFAULT NULL,\n`col8` BIGINT UNSIGNED DEFAULT NULL,\n`col9` FLOAT DEFAULT NULL,\n`col10` DOUBLE DEFAULT NULL,\n`col11` VARCHAR(255) DEFAULT NULL,\n`col12` DATE DEFAULT NULL,\n`col13` DATETIME DEFAULT NULL,\n`col14` TIMESTAMP DEFAULT NULL,\n`col15` BOOL DEFAULT NULL,\n`col16` DECIMAL(5,2) DEFAULT NULL,\n`col17` TEXT DEFAULT NULL,\n`col18` VARCHAR(255) DEFAULT NULL,\n`col19` VARCHAR(255) DEFAULT NULL,\n`col20` TEXT DEFAULT NULL\n) partition by list(year(col13)) (partition r0 values in (1999, 2001, 2003), partition r1 values in (2002, 2004, 2005), partition r2 values in (2006, 2007, 2008))
   327  create table pt_table_46(col1 tinyint,col2 smallint,col3 int,col4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text)partition by list(col20) (PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
   328  SQL syntax error: type TEXT not allowed in partition clause
   329  create table pt_table_47(col13 DateTime,col14 timestamp,col15 bool,partition by list(col13) (PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
   330  SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 76 near "partition by list(col13) (PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));";
   331  create table pt_table_48(col1 tinyint,col2 smallint,col10 decimal)partition by list(col10) (PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22));
   332  SQL syntax error: type DECIMAL128 not allowed in partition clause
   333  create table pt_table_49(col1 tinyint,col2 smallint,col15 bool)partition by list(col15) (PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22));
   334  SQL syntax error: type BOOL not allowed in partition clause
   335  create table pt_table_50(col1 tinyint,col2 smallint,col3 int,col4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text,primary key(col4,col3,col11))partition by list(col3) (PARTITION r0 VALUES IN (1, 5*2, 9, 13, 17-20, 21),PARTITION r1 VALUES IN (2, 6, 10, 14/2, 18, 22),PARTITION r2 VALUES IN (3, 7, 11+6, 15, 19, 23),PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
   336  internal error: VALUES value for partition 'r1' must have type INT
   337  create table pt_table_51(col1 tinyint,col2 smallint,col3 int,col4 bigint,col5 tinyint unsigned,col6 smallint unsigned,col7 int unsigned,col8 bigint unsigned,col9 float,col10 double,col11 varchar(255),col12 Date,col13 DateTime,col14 timestamp,col15 bool,col16 decimal(5,2),col17 text,col18 varchar(255),col19 varchar(255),col20 text)partition by list(year(col13))(PARTITION r0 VALUES IN (1999, 2001, 2003),PARTITION r1 VALUES IN (1999, 2001, 2003),PARTITION r2 VALUES IN (1999, 2001, 2003));
   338  internal error: Multiple definition of same constant in list partitioning
   339  create table pt_table_52(col1 tinyint,col2 smallint,col3 int,col4 bigint,col11 varchar(255),col12 Date,col13 DateTime,primary key(col4,col3,col11))partition by list(col2) (PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24));
   340  invalid input: partition key is not part of primary key