MySQL Bugs: #13445: Partitions: crash if key method

Bug #13445	Partitions: crash if key method
Submitted:	23 Sep 2005 17:43	Modified:	20 Jan 2006 10:09
Reporter:	Peter Gulutzan	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Partitions	Severity:	S3 (Non-critical)
Version:	5.1.2-alpha-debug	OS:	Linux (SUSE 9.2)
Assigned to:	Mikael Ronström	CPU Architecture:	Any

Description:
If I use the KEY method of partitioning, and I
have a multi-column key, and I have a few rows
in the table, then SELECT causes a crash.

How to repeat:
mysql> create table tw (s1 int, s2 int, primary key (s1,s2)) engine=innodb partition by key (s2,s1) partitions 4;
Query OK, 0 rows affected (0.02 sec)

mysql> insert into tw values (0,0),(1,1),(2,2),(3,3),(4,4),(5,5),(6,6);
Query OK, 7 rows affected (0.01 sec)
Records: 7  Duplicates: 0  Warnings: 0

mysql> select * from tw where s1 = 4;
ERROR 2013 (HY000): Lost connection to MySQL server during query

Small lapse in get_partition_set

Patch pushed and will appear in 5.1.6

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 bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Documented bugfix in 5.1.6 changelog. Closed.