Bug #74563 Wrong error on multiple table deletions
Submitted: 25 Oct 2014 14:07 Modified: 27 Oct 2014 8:12
Reporter: Douglas Boffey Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:5.6.21 OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[25 Oct 2014 14:07] Douglas Boffey
Assuming that, for example, the tables foo, bar and baz don’t exist, the instruction

DROP TABLE foo, bar, baz;

generates the error (assuming the current database is mydb)

ERROR 1051 (42S02): Unknown table 'mydb.foo,mydb.bar,mydb.baz'

This should surely say something like

Unknown tables 'mydb.foo', 'mydb.bar' and 'mydb.baz'

How to repeat:
Type in a DROP TABLE instruction with multiple tables which don’t exist.

Suggested fix:
Change the error report when multiple tables cannot be dropped.
[27 Oct 2014 8:12] MySQL Verification Team
Hello Douglas Boffey,

Thank you for the report and test case.