Bug #95 DROP TABLE returns wrong error when the database does not exist
Submitted: 24 Feb 2003 13:44 Modified: 3 Mar 2003 5:58
Reporter: Guilhem Bichot Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.11 OS:Any (all)
Assigned to: CPU Architecture:Any

[24 Feb 2003 13:44] Guilhem Bichot
Description:
mysql> show databases;
+----------+
| Database |
+----------+
| mysql    |
| test     |
+----------+
2 rows in set (0.00 sec)

mysql> drop table zozo.a;
ERROR 1051: Unknown table 'a'

It would be better to say "unknown database 'zozo'".

How to repeat:
mysql> show databases;
+----------+
| Database |
+----------+
| mysql    |
| test     |
+----------+
2 rows in set (0.00 sec)

mysql> drop table zozo.a;
ERROR 1051: Unknown table 'a'
[3 Mar 2003 5:58] Michael Widenius
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

This is not a bug.
(The correct behaviour is to in the future change this to return 'unknown table 'database.table_name')