diff options
| author | mikael@c-0409e253.1238-1-64736c10.cust.bredbandsbolaget.se <> | 2006-06-14 09:12:07 -0400 |
|---|---|---|
| committer | mikael@c-0409e253.1238-1-64736c10.cust.bredbandsbolaget.se <> | 2006-06-14 09:12:07 -0400 |
| commit | e91454f89e3b8c501d2d88bc782fc3f3d5324134 (patch) | |
| tree | 827438a688b1352593deb848a80ecd9f5c6f17b5 /mysql-test/t/partition_range.test | |
| parent | 02c25f8055ea3829d9c92a00dd9f4e21b74702cd (diff) | |
| parent | 2dd609909215491b7b83b338b2e9a6a3553238d7 (diff) | |
| download | mariadb-git-e91454f89e3b8c501d2d88bc782fc3f3d5324134.tar.gz | |
Merge c-0409e253.1238-1-64736c10.cust.bredbandsbolaget.se:/home/pappa/clean-mysql-5.1
into c-0409e253.1238-1-64736c10.cust.bredbandsbolaget.se:/home/pappa/bug16002
Diffstat (limited to 'mysql-test/t/partition_range.test')
| -rw-r--r-- | mysql-test/t/partition_range.test | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/t/partition_range.test b/mysql-test/t/partition_range.test index 42ce4e0d879..5c1c17dc511 100644 --- a/mysql-test/t/partition_range.test +++ b/mysql-test/t/partition_range.test @@ -389,6 +389,30 @@ SELECT COUNT(*) FROM t1 WHERE c3 < '2000-12-31'; DROP TABLE t1; # +# BUG 16002: Unsigned partition functions not handled correctly +# +--error ER_RANGE_NOT_INCREASING_ERROR +create table t1 (a bigint unsigned) +partition by range (a) +(partition p0 values less than (10), + partition p1 values less than (0)); + +create table t1 (a bigint unsigned) +partition by range (a) +(partition p0 values less than (0), + partition p1 values less than (10)); +show create table t1; +drop table t1; + +create table t1 (a bigint unsigned) +partition by range (a) +(partition p0 values less than (2), + partition p1 values less than (10)); +show create table t1; +--error ER_NO_PARTITION_FOR_GIVEN_VALUE +insert into t1 values (0xFFFFFFFFFFFFFFFF); + +# # BUG 18962 Errors in DROP PARTITION # create table t1 (a int) |