Bug #9846 Inappropriate error displayed while dropping table from 'INFORMATION_SCHEMA'
Submitted: 12 Apr 2005 14:15 Modified: 14 Sep 2005 18:24
Reporter: Disha Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.3 Beta OS:Microsoft Windows (Windows 2000 Server)
Assigned to: Sergei Glukhov CPU Architecture:Any

[12 Apr 2005 14:15] Disha
Description:
When we use database 'Information_Schema', it is a read only database.If we try to drop the table 'Schemata' from 'Information_Schema' database, it gives a wrong error message stating 'ERROR 1051 (42S02):Unknown table 'schemata'.

How to repeat:
1) Use information_Schema database ie execute the following SQL statement:
     use information_schema//

2) Use 'Drop table' statement ie execute the following SQL statement:
    drop table schemata// 

Observed: It gives the following error message
'ERROR 1051 (42S02): Unknown table 'schemata''

Expected Result: It should show an appropriate error message.

Actual Result: IT shows an error message 'ERROR 1051 (42S02): Unknown table 'schemata''.
[25 Aug 2005 11:06] Mark Cross
I got this error when I was try to drop a database and there were mixed tables, some ISAM and some InnoBD. (Needless to say I didn't create the database...)
[13 Sep 2005 11:07] Sergei Glukhov
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/internals/29725
[14 Sep 2005 8:32] Sergei Glukhov
Fixed in 5.0.13
[14 Sep 2005 18:24] Paul Dubois
Noted in 5.0.13 changelog.