Bug #28005 Partitions: can't use -9223372036854775808
Submitted: 21 Apr 2007 22:02 Modified: 15 May 2007 6:02
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:5.1.18-beta-debug OS:Linux (SUSE 10 64-bit)
Assigned to: Alexey Botchkov CPU Architecture:Any

[21 Apr 2007 22:02] Peter Gulutzan
Description:
I try to create a list partition on a bigint column.
The minimum bigint value is -9223372036854775808.
But the minimum allowed for a partition is -9223372036854775807.

How to repeat:
mysql> create table t1 (s1 bigint) partition by list (s1)
    ->  (partition p1 values in (-9223372036854775807));
Query OK, 0 rows affected (0.01 sec)

mysql> create table t2 (s1 bigint) partition by list (s1)
    ->  (partition p1 values in (-9223372036854775808));
ERROR 1064 (42000): VALUES value must be of same type as partition function near '))' at line 2
[21 Apr 2007 23:17] MySQL Verification Team
Thank you for the bug report. Verified as described on FC 6 32-bit
[6 May 2007 19:40] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/26188

ChangeSet@1.2513, 2007-05-06 23:40:16+05:00, holyfoot@mysql.com +3 -0
  Bug #28005 Partitions: can't use -9223372036854775808
  the Item_neg changes INT_RESULT with DECIMAL_RESULT when
  it gets this border value, what is not necessary.
[7 May 2007 7:16] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/26190

ChangeSet@1.2514, 2007-05-07 11:15:59+05:00, holyfoot@mysql.com +2 -0
  bug #28005 (Partitions can't use -922337...)
  one more test added
[13 May 2007 6:16] Bugs System
Pushed into 5.1.19-beta
[15 May 2007 6:02] Jon Stephens
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented bugfix in 5.1.19 changelog.