Bug #14527 Partitions: table unreadable if partition name = c-cedilla
Submitted: 31 Oct 2005 21:42 Modified: 2 Mar 2006 10:15
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: Alexander Barkov CPU Architecture:Any

[31 Oct 2005 21:42] Peter Gulutzan
Description:
I can create and use a table with a partition named ç
(c cedilla). But after I shut down and restart the server,
I can't use the table.

How to repeat:
mysql> set names utf8;
Query OK, 0 rows affected (0.00 sec)

mysql> create table c (s1 int) partition by list (s1) (partition c values in (1),partition Ç values in (3));
Query OK, 0 rows affected (0.08 sec)

/* At this point I quit the client, used mysqladmin shutdown to stop the server,
   started the server again, and started the client again. Then I continued ... */

mysql> select * from c;
ERROR 1454 (HY000): LIST PARTITIONING requires definition of VALUES IN for each partition
[31 Oct 2005 21:50] Jorge del Conde
I was able to reproduce this using a fresh clone of 5.1 under FC4
[2 Mar 2006 8:30] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/3370
[2 Mar 2006 9:51] Alexander Barkov
Pushed into 5.1.8
[2 Mar 2006 10:15] 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
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Documented fix in 5.1.8 changelog; closed.