| 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: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.3 Beta | OS: | Windows (Windows 2000 Server) |
| Assigned to: | Sergei Glukhov | CPU Architecture: | Any |
[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.
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''.