Bug #49180 | Possible to define unusable partitions using RANGE COLUMNS() | ||
---|---|---|---|
Submitted: | 28 Nov 2009 20:41 | Modified: | 11 Dec 2009 16:51 |
Reporter: | Jon Stephens | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Partitions | Severity: | S3 (Non-critical) |
Version: | 5.5.0 | OS: | Linux (opensuse 11.1/x86_64) |
Assigned to: | Mikael Ronström | CPU Architecture: | Any |
Tags: | maxvalue, partition by range columns |
[28 Nov 2009 20:41]
Jon Stephens
[29 Nov 2009 3:28]
MySQL Verification Team
Thank you for the bug report. Verified as described.
[29 Nov 2009 19:41]
Jon Stephens
Looks to me like the appropriate error message should be Error: 1481 SQLSTATE: HY000 (ER_PARTITION_MAXVALUE_ERROR) Message: MAXVALUE can only be used in last partition definition
[1 Dec 2009 17:31]
Timothy Smith
Possibly related to Bug#48162
[2 Dec 2009 7:10]
Mikael Ronström
The correct behaviour should be to compare field by field as now and when finding that both values contain MAXVALUE one should report equality immediately independent of the rest of fields since there is no values that can be present in the interval between those. The fix is very simple in compare_column_values return 0 instead of continue when both values are MAXVALUE.
[2 Dec 2009 7:15]
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/92384 2910 Mikael Ronstrom 2009-12-02 BUG#49180, fixed MAXVALUE problem
[11 Dec 2009 6:01]
Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20091211055901-yp18b3c7xuhl87rf) (version source revid:alik@sun.com-20091211055401-43rjwq7gjed6ds83) (merge vers: 6.0.14-alpha) (pib:13)
[11 Dec 2009 6:03]
Bugs System
Pushed into 5.5.0-beta (revid:alik@sun.com-20091211055436-aagpwm5ac26waw4b) (version source revid:alik@sun.com-20091211055436-aagpwm5ac26waw4b) (merge vers: 5.5.0-beta) (pib:13)
[11 Dec 2009 6:04]
Bugs System
Pushed into 5.6.0-beta (revid:alik@sun.com-20091211055628-ltr7fero363uev7r) (version source revid:alik@sun.com-20091211055453-717czhtezc74u8db) (merge vers: 5.6.0-beta) (pib:13)
[11 Dec 2009 16:51]
Jon Stephens
This bug didn't appear in any release, so no changelog entry is required. (Thanks for the quick fix, though!) Closed without further action.