MySQL Bugs: #15253: Partitions: no error for unlisted zeros

Bug #15253	Partitions: no error for unlisted zeros
Submitted:	25 Nov 2005 21:30	Modified:	13 Mar 2006 10:33
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 10.0)
Assigned to:	Mikael Ronström	CPU Architecture:	Any

Description:
I define a table with a single LIST partition: "values in (5)".
Then I insert 0.
I expect an error. I don't get one.
This happens only if there is a single LIST partition.
This happens only for the value 0.
(For certain other values I get a crash, but I think that's a different bug.)

Possibly there is a relation to bug#13443 "Partitions: no error for unlisted values".

How to repeat:
mysql> create table tpm (s1 int) partition by list (s1) (partition p1 values in (5));
Query OK, 0 rows affected (0.00 sec)

mysql> insert into tpm values (0);
Query OK, 1 row affected (0.00 sec)

Tested under FC4 using a recent 5.1 pull

This bug is already fixed, it works in the latest 5.1 tree

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 as fixed in 5.1.8 changelog; bug closed.