diff options
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/partition.result | 23 | ||||
| -rw-r--r-- | mysql-test/r/partition_error.result | 2 |
2 files changed, 22 insertions, 3 deletions
diff --git a/mysql-test/r/partition.result b/mysql-test/r/partition.result index b76896f720f..50570894a51 100644 --- a/mysql-test/r/partition.result +++ b/mysql-test/r/partition.result @@ -1,5 +1,24 @@ drop table if exists t1; -create table t1 (a bigint unsigned); +create table t1 (a bigint) +partition by range (a) +(partition p0 values less than (0xFFFFFFFFFFFFFFFF), +partition p1 values less than (10)); +ERROR 42000: VALUES value must be of same type as partition function near '), +partition p1 values less than (10))' at line 3 +create table t1 (a bigint) +partition by list (a) +(partition p0 values in (0xFFFFFFFFFFFFFFFF), +partition p1 values in (10)); +ERROR 42000: VALUES value must be of same type as partition function near '), +partition p1 values in (10))' at line 3 +create table t1 (a bigint unsigned) +partition by range (a) +(partition p0 values less than (100), +partition p1 values less than MAXVALUE); +insert into t1 values (1); +drop table t1; +create table t1 (a bigint unsigned) +partition by hash (a); insert into t1 values (0xFFFFFFFFFFFFFFFD); insert into t1 values (0xFFFFFFFFFFFFFFFE); select * from t1 where (a + 1) < 10; @@ -852,7 +871,7 @@ DROP TABLE t1; create table t1 (a bigint unsigned) partition by list (a) (partition p0 values in (0-1)); -ERROR HY000: Partition function is unsigned, cannot have negative constants +ERROR HY000: Partition constant is out of partition function domain create table t1 (a bigint unsigned) partition by range (a) (partition p0 values less than (10)); diff --git a/mysql-test/r/partition_error.result b/mysql-test/r/partition_error.result index cc51b909c51..1295eba16ae 100644 --- a/mysql-test/r/partition_error.result +++ b/mysql-test/r/partition_error.result @@ -557,4 +557,4 @@ drop table t1; create table t1 (a bigint unsigned) partition by range (a) (partition p0 values less than (-1)); -ERROR HY000: Partition function is unsigned, cannot have negative constants +ERROR HY000: Partition constant is out of partition function domain |