Bug #21339 explain partitions leads to server crash
Submitted: 29 Jul 2006 8:35 Modified: 2 Sep 2006 5:01
Reporter: Yuan WANG Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Partitions Severity:S2 (Serious)
Version:5.1.11/5.1BK OS:Linux (linux)
Assigned to: Mikael Ronström CPU Architecture:Any

[29 Jul 2006 8:35] Yuan WANG
'explain partitions' a query on a table partitioned by a column of Date sometimes cause server to crash.

How to repeat:
create table part_date1(a date)
    engine = innodb
    partition by range (year(a)) (
    partition p0 values less than (2006),
    partition p1 values less than (2007));
explain partitions select * from part_date1 where a between '2006-01-01' and '2007-06-01';
Then the server will crash.
[29 Jul 2006 13:23] Miguel Solorzano
Back trace on Suse 10 32-bit

Attachment: bt-21339.txt (text/plain), 7.88 KiB.

[29 Jul 2006 13:24] Miguel Solorzano
Thank you for the bug report. I was able to repeat (back trace attached).
[5 Aug 2006 20:26] Mikael Ronström
There was a general missing check for last partition in the
endpoint check for the right range.
[8 Aug 2006 13:25] Mikael Ronström
Reviewed by evgen
[15 Aug 2006 15:30] Sergey Petrunya
I have reviewed this bug as second reviewer, ok to push.
[31 Aug 2006 20:41] Mikael Ronström
fixed in 5.1-kt team tree
[1 Sep 2006 7:56] Mikael Ronström
Patch will appear in 5.1.12
[2 Sep 2006 5:01] 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


Documented bugfix in 5.1.12 changelog.