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:
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

[25 Nov 2005 21:30] Peter Gulutzan
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)
[26 Nov 2005 10:46] Jorge del Conde
Tested under FC4 using a recent 5.1 pull
[11 Mar 2006 13:06] Mikael Ronström
This bug is already fixed, it works in the latest 5.1 tree
[13 Mar 2006 10:33] 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 bugfix, yourself. More information 
about accessing the source trees is available at

Additional info:

Documented as fixed in 5.1.8 changelog; bug closed.