Bug #2956 cant creat partial indexes on varchar columns
Submitted: 25 Feb 2004 5:07 Modified: 25 Feb 2004 14:23
Reporter: Andris Kardos Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0a OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[25 Feb 2004 5:07] Andris Kardos
When creating partial indexes - ON name(20) - a missing 'proc' table reported in the mysql database. The setup does not include that table for Windows.

How to repeat:
create a partial index on a colunm
[25 Feb 2004 10:13] Dean Ellis
This is a duplicate of bug 2302 (and to a lesser extent 367).  The table was not included in the initial release but should be present in 5.0.0a.  Make sure that you are not using system tables from the initial release of 5.0.0 for Windows.
[25 Feb 2004 14:23] Sergei Golubchik
A workaround is to put a space between index name and a paren:

   name (20)

this way a parser will clearly see that this cannot be a call of a stored procedure and won't try to do a name lookup in a 'proc' table.