Bug #69560 The generated SQL script to drop table and schema uses lowercase

• Submitted: 24 Jun 2013 17:22
• Modified: 11 Jul 2013 0:22
• Reporter: Franck Dernoncourt
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.47
• OS: Windows
• CPU Architecture: Any
• Tags: case

[24 Jun 2013 17:22] Franck Dernoncourt

Description:
When right clicking on a table or a schema and selecting drop table/schema, the generated SQL script uses lower case, e.g. "drop table `phpmyadmin`.`pma_bookmark`;". It should be "DROP TABLE `phpmyadmin`.`pma_bookmark`;" to be consistent with the SQL generated when altering a table, which uses uppercase, as well as with the ANSI standard http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt. Demo: http://youtu.be/Sk84zkFZjMg

How to repeat:
Right clicking on a table or a schema and select drop table/schema.

Suggested fix:
Use uppercase.

[24 Jun 2013 17:25] Franck Dernoncourt

Sorry I forgot to finish writing the title, and there doesn't seem any way for me to edit my original bug report.

[24 Jun 2013 18:22] Franck Dernoncourt

Change tittle

[25 Jun 2013 1:37] MySQL Verification Team

Thank you for the bug report.

[11 Jul 2013 0:22] Philip Olson

Fixed as of MySQL Workbench 6.0.3 (BETA 2), and here's the changelog entry:

The "SELECT DROP table/schema" context menu action would generate SQL in
lowercase. SQL keywords are now written in uppercase.

Thank you for the bug report.