diff options
Diffstat (limited to 'mysql-test/r/partition_error.result')
| -rw-r--r-- | mysql-test/r/partition_error.result | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/mysql-test/r/partition_error.result b/mysql-test/r/partition_error.result index 3abd39c3d8c..a51aaf22f69 100644 --- a/mysql-test/r/partition_error.result +++ b/mysql-test/r/partition_error.result @@ -89,6 +89,9 @@ partitions 3 partition x2 tablespace ts2, partition x3 tablespace ts3); ERROR HY000: Field in list of fields for partition function not found in table +select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par'); +load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par') +NULL CREATE TABLE t1 ( a int not null, b int not null, @@ -163,6 +166,9 @@ partitions 2 (partition x1 values less than (4), partition x2 values less than (5)); ERROR HY000: Only RANGE PARTITIONING can use VALUES LESS THAN in partition definition +select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par'); +load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par') +NULL CREATE TABLE t1 ( a int not null, b int not null, @@ -173,6 +179,9 @@ partitions 2 (partition x1 values in (4), partition x2 values in (5)); ERROR HY000: Only LIST PARTITIONING can use VALUES IN in partition definition +select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par'); +load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par') +NULL CREATE TABLE t1 ( a int not null, b int not null, @@ -183,6 +192,9 @@ partitions 2 (partition x1 values in (4,6), partition x2 values in (5,7)); ERROR HY000: Only LIST PARTITIONING can use VALUES IN in partition definition +select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par'); +load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par') +NULL CREATE TABLE t1 ( a int not null, b int not null, @@ -191,6 +203,9 @@ primary key (a,b)) partition by key (a) subpartition by key (b); ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning +select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par'); +load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par') +NULL CREATE TABLE t1 ( a int not null, b int not null, @@ -199,6 +214,9 @@ primary key (a,b)) partition by key (a) subpartition by key (a, b); ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning +select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par'); +load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par') +NULL CREATE TABLE t1 ( a int not null, b int not null, @@ -207,6 +225,9 @@ primary key (a,b)) partition by key (a) subpartition by hash (a+b); ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning +select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par'); +load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par') +NULL CREATE TABLE t1 ( a int not null, b int not null, @@ -215,6 +236,9 @@ primary key (a,b)) partition by key (a) subpartition by key (b); ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning +select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par'); +load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par') +NULL CREATE TABLE t1 ( a int not null, b int not null, @@ -223,6 +247,9 @@ primary key (a,b)) partition by key (a) subpartition by key (a, b); ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning +select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par'); +load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par') +NULL CREATE TABLE t1 ( a int not null, b int not null, @@ -231,6 +258,9 @@ primary key (a,b)) partition by key (a) subpartition by hash (a+b); ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning +select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par'); +load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par') +NULL CREATE TABLE t1 ( a int not null, b int not null, @@ -249,6 +279,9 @@ subpartition by hash (sin(a+b)) (partition x1 (subpartition x11, subpartition x12), partition x2 (subpartition x21, subpartition x22)); ERROR HY000: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning +select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par'); +load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par') +NULL CREATE TABLE t1 ( a int not null, b int not null, @@ -271,6 +304,9 @@ subpartition by key (a,d) (partition x1 values less than (1) (subpartition x11, subpartition x12), partition x2 values less than (2) (subpartition x21, subpartition x22)); ERROR HY000: Field in list of fields for partition function not found in table +select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par'); +load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par') +NULL CREATE TABLE t1 ( a int not null, b int not null, @@ -296,6 +332,9 @@ c int not null, primary key(a,b)) partition by range (a); ERROR HY000: For RANGE partitions each partition must be defined +select load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par'); +load_file('$MYSQLTEST_VARDIR/master-data/test/t1.par') +NULL CREATE TABLE t1 ( a int not null, b int not null, |