From cef06fdb61e203aa7b1b29705b08e00480dcc046 Mon Sep 17 00:00:00 2001
From: "mikael@c-4909e253.1238-1-64736c10.cust.bredbandsbolaget.se" <>
Date: Mon, 17 Apr 2006 22:51:34 -0400
Subject: BUG#16002: Make partition functions that are unsigned work properly

---
 mysql-test/r/partition_range.result | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'mysql-test/r/partition_range.result')

diff --git a/mysql-test/r/partition_range.result b/mysql-test/r/partition_range.result
index fc9350f5902..4d071c0edc1 100644
--- a/mysql-test/r/partition_range.result
+++ b/mysql-test/r/partition_range.result
@@ -363,3 +363,15 @@ SELECT COUNT(*) FROM t1 WHERE c3 < '2000-12-31';
 COUNT(*)
 10
 DROP TABLE t1;
+create table t1 (a bigint unsigned)
+partition by range (a)
+(partition p0 values less than (0),
+partition p1 values less than (10));
+ERROR HY000: VALUES LESS THAN value must be strictly increasing for each partition
+create table t1 (a bigint unsigned)
+partition by range (a)
+(partition p0 values less than (2),
+partition p1 values less than (10));
+insert into t1 values (0xFFFFFFFFFFFFFFFF);
+ERROR HY000: Table has no partition for value 18446744073709551615
+drop table t1;
-- 
cgit v1.2.1


From bda7c1fd1372a4d164ed68bc59ced5add2a076d9 Mon Sep 17 00:00:00 2001
From: "mikael@c-0409e253.1238-1-64736c10.cust.bredbandsbolaget.se" <>
Date: Tue, 6 Jun 2006 11:54:21 -0400
Subject: BUG#16002: More review fixes

---
 mysql-test/r/partition_range.result | 17 ++++++++++++++++-
 1 file changed, 16 insertions(+), 1 deletion(-)

(limited to 'mysql-test/r/partition_range.result')

diff --git a/mysql-test/r/partition_range.result b/mysql-test/r/partition_range.result
index 4d071c0edc1..4a3ed6b6164 100644
--- a/mysql-test/r/partition_range.result
+++ b/mysql-test/r/partition_range.result
@@ -365,13 +365,28 @@ COUNT(*)
 DROP TABLE t1;
 create table t1 (a bigint unsigned)
 partition by range (a)
+(partition p0 values less than (10),
+partition p1 values less than (0));
+ERROR HY000: VALUES LESS THAN value must be strictly increasing for each partition
+create table t1 (a bigint unsigned)
+partition by range (a)
 (partition p0 values less than (0),
 partition p1 values less than (10));
-ERROR HY000: VALUES LESS THAN value must be strictly increasing for each partition
+show create table t1;
+Table	Create Table
+t1	CREATE TABLE `t1` (
+  `a` bigint(20) unsigned DEFAULT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (0) ENGINE = MyISAM, PARTITION p1 VALUES LESS THAN (10) ENGINE = MyISAM)
+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;
+Table	Create Table
+t1	CREATE TABLE `t1` (
+  `a` bigint(20) unsigned DEFAULT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (2) ENGINE = MyISAM, PARTITION p1 VALUES LESS THAN (10) ENGINE = MyISAM)
 insert into t1 values (0xFFFFFFFFFFFFFFFF);
 ERROR HY000: Table has no partition for value 18446744073709551615
 drop table t1;
-- 
cgit v1.2.1


From 3e0cfd1ba1cc4f6c1bbddb6dd874611c5c92255c Mon Sep 17 00:00:00 2001
From: "mikael@c-0409e253.1238-1-64736c10.cust.bredbandsbolaget.se" <>
Date: Wed, 14 Jun 2006 22:37:20 -0400
Subject: merge fixes

---
 mysql-test/r/partition_range.result | 1 +
 1 file changed, 1 insertion(+)

(limited to 'mysql-test/r/partition_range.result')

diff --git a/mysql-test/r/partition_range.result b/mysql-test/r/partition_range.result
index ff17abe0ffb..152f91f0887 100644
--- a/mysql-test/r/partition_range.result
+++ b/mysql-test/r/partition_range.result
@@ -389,6 +389,7 @@ t1	CREATE TABLE `t1` (
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (2) ENGINE = MyISAM, PARTITION p1 VALUES LESS THAN (10) ENGINE = MyISAM)
 insert into t1 values (0xFFFFFFFFFFFFFFFF);
 ERROR HY000: Table has no partition for value 18446744073709551615
+drop table t1;
 create table t1 (a int)
 partition by range (MOD(a,3))
 subpartition by hash(a)
-- 
cgit v1.2.1