Bug #15494 CREATE TABLE ... PARTITON crashes server on nonsensical "less than" clause
Submitted: 5 Dec 2005 15:58 Modified: 20 Mar 2006 22:30
Reporter: Kolbe Kegel Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: Partitions Severity:S3 (Non-critical)
Version:5.1.3 OS:Linux (Linux)
Assigned to: Assigned Account CPU Architecture:Any

[5 Dec 2005 15:58] Kolbe Kegel
The MySQL Sever crashes when CREATE TABLE statement containing a particular "less than" clause is executed.

How to repeat:
create table t1 (id int auto_increment primary key, v varchar(12)) partition by range(ascii(v)) (partition p1 values less than (ascii(v)), partition p2 values less than maxvalue);

Suggested fix:
Issue an error when this statement is executed.
[20 Mar 2006 22:30] Mikael Ronström
This bug will be taken care of by fixing BUG #18198