bk commit into 5.1 tree (holyfoot:1.2514) BUG#28005

[holyfoot]

Below is the list of changes that have just been committed into a local
5.1 repository of hf. When hf does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2007-05-07 11:15:59+05:00, holyfoot@stripped +2 -0
  bug #28005 (Partitions can't use -922337...)
  one more test added

  mysql-test/r/bigint.result@stripped, 2007-05-07 11:15:57+05:00, holyfoot@stripped +10 -0
    test result

  mysql-test/t/bigint.test@stripped, 2007-05-07 11:15:57+05:00, holyfoot@stripped +5 -0
    testcase

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	holyfoot
# Host:	hfmain.(none)
# Root:	/home/hf/work/28005/my51-28005

--- 1.36/mysql-test/r/bigint.result	2007-05-07 11:16:04 +05:00
+++ 1.37/mysql-test/r/bigint.result	2007-05-07 11:16:04 +05:00
@@ -352,3 +352,13 @@ select c1 mod 50 as result from t1;
 result
 6
 drop table t1;
+select -9223372036854775808 bi;
+Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr
+def					bi	8	20	20	N	32897	0	63
+bi
+-9223372036854775808
+select -9223372036854775809 bi;
+Catalog	Database	Table	Table_alias	Column	Column_alias	Type	Length	Max length	Is_null	Flags	Decimals	Charsetnr
+def					bi	246	20	20	N	129	0	63
+bi
+-9223372036854775809

--- 1.29/mysql-test/t/bigint.test	2007-05-07 11:16:04 +05:00
+++ 1.30/mysql-test/t/bigint.test	2007-05-07 11:16:04 +05:00
@@ -288,3 +288,8 @@ insert into t1 values (10000002383263201
 select c1 mod 50 as result from t1;
 drop table t1;
 
+# Bug #28005 Partitions: can't use -9223372036854775808 
+--enable_metadata
+select -9223372036854775808 bi;
+select -9223372036854775809 bi;
+--disable_metadata