BUG#16002: More review fixes

mysql-test/r/partition_range.result:
  Changed test cases
mysql-test/t/partition_range.test:
  Changed test cases
sql/partition_info.cc:
  Changes to resue signed integer code for unsigned integer partition functions
  Basic idea is to store value - 0x8000000000000000 in list_array and range_int_array
  and also perform this subtraction before applying get_partition_id_range and so
  forth.
sql/sql_partition.cc:
  Changes to resue signed integer code for unsigned integer partition functions
  Basic idea is to store value - 0x8000000000000000 in list_array and range_int_array
  and also perform this subtraction before applying get_partition_id_range and so
  forth.

1 files changed, 9 insertions, 1 deletions

diff --git a/mysql-test/t/partition_range.test b/mysql-test/t/partition_range.test
index 239c6cc8144..ebe249eb072 100644
--- a/mysql-test/t/partition_range.test
+++ b/mysql-test/t/partition_range.test
@@ -394,14 +394,22 @@ DROP TABLE t1;
 --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);
-
 drop table t1;
+