github.com/matrixorigin/matrixone@v1.2.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 fields terminated by ',';
    24  select col1 from pt_table_1;
    25  col1
    26  -8
    27  21
    28  -62
    29  91
    30  -93
    31  33
    32  122
    33  121
    34  40
    35  -75
    36  110
    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 fields terminated by ',';
    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 fields terminated by ',';
    54  select col1 from pt_table_3;
    55  col1
    56  -8
    57  21
    58  -62
    59  91
    60  -93
    61  33
    62  122
    63  121
    64  40
    65  -75
    66  110
    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_5 fields terminated by ',';
    69  select col12 from pt_table_5;
    70  col12
    71  4149-04-30
    72  2865-02-22
    73  6316-02-16
    74  9948-05-08
    75  7854-05-11
    76  2316-05-27
    77  8499-01-03
    78  9687-10-15
    79  1295-04-12
    80  1619-06-04
    81  3674-02-25
    82  show create table pt_table_5;
    83  Table    Create Table
    84  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))
    85  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;
    86  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_6 fields terminated by ',';
    87  select col2 from pt_table_6;
    88  col2
    89  5807
    90  4300
    91  30792
    92  -30001
    93  19053
    94  775
    95  -23777
    96  19514
    97  -22564
    98  11896
    99  -18596
   100  create table pt_table_10(col1 tinyint,col2 smallint,col3 int,primary key(col1))partition by hash(col2);
   101  A PRIMARY KEY must include all columns in the table's partitioning function
   102  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;
   103  Field 'col9' is of a not allowed type for this type of partitioning
   104  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);
   105  Field 'col20' is of a not allowed type for this type of partitioning
   106  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);
   107  Field 'col12' is of a not allowed type for this type of partitioning
   108  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);
   109  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);";
   110  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;
   111  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_21 fields terminated by ',';
   112  select col2 from pt_table_21;
   113  col2
   114  5807
   115  -30001
   116  11896
   117  -23777
   118  19053
   119  4300
   120  -22564
   121  30792
   122  -18596
   123  19514
   124  775
   125  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;
   126  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_22 fields terminated by ',';
   127  select col2 from pt_table_22;
   128  col2
   129  -18596
   130  5807
   131  30792
   132  11896
   133  -23777
   134  19053
   135  -22564
   136  19514
   137  4300
   138  -30001
   139  775
   140  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;
   141  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_23 fields terminated by ',';
   142  select col19 from pt_table_23;
   143  col19
   144  +=Zab
   145  R.STU-_+=Zabcdefghigklmnopqrstuvw
   146  U-_+=Zabcdefghigklmno
   147  ;KL/MN?OPQR.STU-_+=Zabcdefghigklmno
   148  -_+=Zabcdefghigklmnopqr
   149  /MN?OPQR.STU-_+=Zabcdefghigklmnopqrstuvw
   150  R.STU-_+=Zabcdefghigklmnopqrstuvwxyz0123456
   151  TU-_+=Zabcdefghigklmnopqrstuvwxyz01234567
   152  STU-_+=Zabcdefghigklmnopqrstuvwxyz01
   153  I,G;KL/MN?OPQR.STU-_+=Zabcdefghigklmnopq
   154  DEF,GHI,G;KL/MN?OPQR.STU-_+=Zabcdefghigklmnopqrstuvwxyz0123456
   155  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;
   156  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_24 fields terminated by ',';
   157  select col13 from pt_table_24;
   158  col13
   159  3114-10-05 23:59:59
   160  3647-01-21 23:59:59
   161  4023-04-27 23:59:59
   162  1014-07-01 23:59:59
   163  7031-10-23 00:00:00
   164  5732-08-07 00:00:00
   165  6216-12-30 00:00:00
   166  6868-02-03 00:00:00
   167  4844-01-09 23:59:59
   168  9976-06-04 00:00:00
   169  6438-11-29 00:00:00
   170  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);
   171  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_31 fields terminated by ',';
   172  select col2 from pt_table_31;
   173  col2
   174  5807
   175  19514
   176  -30001
   177  11896
   178  -23777
   179  4300
   180  -22564
   181  30792
   182  775
   183  -18596
   184  19053
   185  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);
   186  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_32 fields terminated by ',';
   187  select col2 from pt_table_32;
   188  col2
   189  5807
   190  19514
   191  4300
   192  -22564
   193  30792
   194  -30001
   195  11896
   196  775
   197  -18596
   198  -23777
   199  19053
   200  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);
   201  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_33 fields terminated by ',';
   202  select col2 from pt_table_33;
   203  col2
   204  5807
   205  19514
   206  4300
   207  -22564
   208  30792
   209  -30001
   210  11896
   211  775
   212  -18596
   213  -23777
   214  19053
   215  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);
   216  Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed
   217  create table pt_table_35(col1 int 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));
   218  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_35 fields terminated by ',';
   219  select col14 from pt_table_35;
   220  col14
   221  1975-09-09 23:59:59
   222  1985-01-12 23:59:59
   223  2034-02-10 00:00:00
   224  1977-03-18 23:59:59
   225  2036-08-23 00:00:00
   226  2037-12-04 00:00:00
   227  2035-05-25 00:00:00
   228  2014-09-26 00:00:00
   229  2011-03-10 00:00:00
   230  1996-08-27 23:59:59
   231  2011-10-04 00:00:00
   232  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);
   233  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_36 fields terminated by ',';
   234  select col2 from pt_table_36;
   235  col2
   236  5807
   237  19514
   238  -30001
   239  11896
   240  -23777
   241  4300
   242  -22564
   243  30792
   244  775
   245  -18596
   246  19053
   247  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);
   248  Unknown column 'col90' in 'partition function'
   249  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);
   250  Field 'col11' is of a not allowed type for this type of partitioning
   251  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);
   252  Field 'col12' is of a not allowed type for this type of partitioning
   253  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);
   254  Field 'col11' is of a not allowed type for this type of partitioning
   255  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);
   256  Field 'ceil(col11)' is of a not allowed type for this type of partitioning
   257  create table pt_table_37(col1 tinyint,col11 float,col12 timestamp)partition by range(col1);
   258  For RANGE partitions each partition must be defined
   259  create table pt_table_37(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));
   260  Data truncation: data out of range: data type int8, value '300'
   261  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 (-6041648745842399623, 2267877015687134490, 7769629822818484334),PARTITION r1 VALUES IN (1234138289513302348, -3038428195984464330, -1681456935776973509),PARTITION r2 VALUES IN (-484407619835391694, -5246968895134993792, -3237107390156157130),PARTITION r3 VALUES IN (-2998549470145089608, 6123486173032718578, 6123486173032718570));
   262  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_41 fields terminated by ',';
   263  select col8 from pt_table_41 order by col8;
   264  col8
   265  3143191107533743301
   266  4029688785176298663
   267  6204822205090614210
   268  6625004793680807495
   269  7094376021034692269
   270  8740918055557791046
   271  13381191796017069332
   272  14999475422109240954
   273  16635491969502097586
   274  17397115807377870895
   275  18225693328091251880
   276  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 (14999475422109240954, 6204822205090614210, 6625004793680807490),PARTITION r1 VALUES IN (17397115807377870895, 3143191107533743301, 13381191796017069332),PARTITION r2 VALUES IN (8740918055557791046, 4029688785176298663, 6625004793680807495),PARTITION r3 VALUES IN (16635491969502097586, 7094376021034692269, 18225693328091251880));
   277  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_42 fields terminated by ',';
   278  select col8 from pt_table_42 order by col8;
   279  col8
   280  3143191107533743301
   281  4029688785176298663
   282  6204822205090614210
   283  6625004793680807495
   284  7094376021034692269
   285  8740918055557791046
   286  13381191796017069332
   287  14999475422109240954
   288  16635491969502097586
   289  17397115807377870895
   290  18225693328091251880
   291  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));
   292  Field 'col10' is of a not allowed type for this type of partitioning
   293  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( (-1889972806, 7769629822818484334), (NULL,NULL) ),PARTITION p1 VALUES IN( (-1030254547, -5246968895134993792),(-1006909301, -6041648745842399623),( -232972021, -3237107390156157130)) comment='list column comment' ,PARTITION p2 VALUES IN( (-179559641, 1234138289513302348),(330484802, -2998549470145089608),(476482983, -484407619835391694) ),PARTITION p3 VALUES IN( (837702822, 6123486173032718578),(1124555433, -1681456935776973509),(1287532466, -3038428195984464330),(1449911253, 2267877015687134490)));
   294  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_44 fields terminated by ',';
   295  select col3,col4 from pt_table_44 order by col3,col4;
   296  col3    col4
   297  -1889972806    7769629822818484334
   298  -1030254547    -5246968895134993792
   299  -1006909301    -6041648745842399623
   300  -232972021    -3237107390156157130
   301  -179559641    1234138289513302348
   302  330484802    -2998549470145089608
   303  476482983    -484407619835391694
   304  837702822    6123486173032718578
   305  1124555433    -1681456935776973509
   306  1287532466    -3038428195984464330
   307  1449911253    2267877015687134490
   308  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 (5732, 9976, 3647, 6216),PARTITION r1 VALUES IN (7031, 6868, 4844, 6438),PARTITION r2 VALUES IN (3114, 1014, 4023, 2008));
   309  load data infile '$resources/external_table_file/pt_table_data.csv' into table  pt_table_45 fields terminated by ',';
   310  select col3,col4 from pt_table_45 order by col3,col4;
   311  col3    col4
   312  -1889972806    7769629822818484334
   313  -1030254547    -5246968895134993792
   314  -1006909301    -6041648745842399623
   315  -232972021    -3237107390156157130
   316  -179559641    1234138289513302348
   317  330484802    -2998549470145089608
   318  476482983    -484407619835391694
   319  837702822    6123486173032718578
   320  1124555433    -1681456935776973509
   321  1287532466    -3038428195984464330
   322  1449911253    2267877015687134490
   323  show create table pt_table_45;
   324  Table    Create Table
   325  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 (5732, 9976, 3647, 6216), partition r1 values in (7031, 6868, 4844, 6438), partition r2 values in (3114, 1014, 4023, 2008))
   326  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));
   327  Field 'col20' is of a not allowed type for this type of partitioning
   328  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));
   329  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));";
   330  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));
   331  Field 'col10' is of a not allowed type for this type of partitioning
   332  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));
   333  Field 'col15' is of a not allowed type for this type of partitioning
   334  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));
   335  invalid input: operator / is not allowed in the partition expression
   336  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));
   337  Multiple definition of same constant in list partitioning
   338  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));
   339  A PRIMARY KEY must include all columns in the table's partitioning function
   340  create table pt_table_53(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));
   341  Multiple definition of same constant in list partitioning
   342  create table pt_table_54(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, 11, 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));
   343  create table dept(deptno int unsigned auto_increment, dname varchar(15), loc varchar(50), primary key(deptno));
   344  create table emp(empno int unsigned auto_increment, ename varchar(15), job varchar(10), mgr int unsigned, hiredate date, sal decimal(7,2), comm decimal(7,2), deptno int unsigned, primary key(empno), foreign key (deptno) references dept(deptno)) partition by key(empno) partitions 2;
   345  Foreign keys are not yet supported in conjunction with partitioning
   346  create table p_hash_table_test(col1 tinyint,col2 varchar(30),col3 decimal(6,3))partition by hash(ceil(col3)) partitions 2;
   347  The PARTITION function returns the wrong type