MySQL Bugs: #46837: Omit Schema Qualifiers does not omit schema name in all places

Bug #46837	Omit Schema Qualifiers does not omit schema name in all places
Submitted:	20 Aug 2009 17:37	Modified:	25 Mar 2010 17:27
Reporter:	Sean Parr	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.1, 5.2.2	OS:	Any (XP Pro SP2, Mac OS X)
Assigned to:		CPU Architecture:	Any
Tags:	drop table, omit schema qualifiers, Use

Description:
When using the forward engineering option to generate a SQL CREATE script, the omit schema qualifiers options doesn't remove the schema name from DROP TABLE statements.  The schema name is also left in table comments and there's also a CREATE SCHEMA and USE statements with the schema name now added to the created script.

How to repeat:
1)  Create an EER Diagram.
2)  Create several basic tables with columns and indexes in the EER Diagram.
3)  File -> Export -> Forward Engineer SQL CREATE Script...
4)  Check the "Generate DROP Statements Before Each CREATE Statement" checkbox and the "Omit Schemata Qualifier in Object Names" checkbox.  Create a file to export to in the Output File field and click Next.
5)  On the next screen, make sure at least the table section is checked to
be exported and click Next.
6)  On the Review Generated Script screen, you can see the DROP statements with the schema name and the CREATE SCHEMA and USE statements and the comments with the schema name.

Many thanks for writing a bug report.

Verified as described by using 5.1.17

Bug #47328 was marked as a duplicate of this one.

This bug persists in 5.2.16 beta on Windows XP SP3

Also applies for INSERT statements.

Add some default inserts for table in the model, then when exporting select "Omit Schema Qualifier in Object Names" and check "Generate INSERT Statements for Tables". 

The exported inserts have INSERT INTO `SchemaQualifier`.`TableName` ...

On 5.2.16 Revision 5249, Windows Vista SP2

The issues have been fixed in repository

An entry has been added to the 5.2.17 changelog:

When using the option Omit Schemata Qualifier in Object Names in the Forward Engineer dialog, the schema name still appeared in DROP, CREATE SCHEMA, INSERT and USE statements. The schema name also appeared in the table comments.