Bug #13506 Table with specific name is unavailable
Submitted: 26 Sep 2005 22:20 Modified: 26 Sep 2005 22:29
Reporter: Piotr Kubala Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.14 OS:Windows (MS Windows 2000)
Assigned to: Assigned Account CPU Architecture:Any

[26 Sep 2005 22:20] Piotr Kubala 
Description:
I upgraded MySQL server from 4.1.12a to 4.1.14
My application using table 'pr' in database 'skez' stopped with error

#1017 - Can't find file: '.\skez\pr.frm' (errno: 13)

There is no way to use table with that name. I could delete this table but any attempt to create table with that name (any columns) ends with the same error. The same with table named 'p'. Database name has no meanning.

How to repeat:
 CREATE TABLE `pr` (
`id` INT NOT NULL
)

Suggested fix:
Use another name

 CREATE TABLE `prs` (
`id` INT NOT NULL
)
[26 Sep 2005 22:29] MySQL Verification Team 
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

Same reason of bug:

http://bugs.mysql.com/bug.php?id=12325