Bug #51411 Forward engeener to database & omit schema qualifier
Submitted: 23 Feb 2010 6:09 Modified: 26 Mar 2010 11:49
Reporter: x Hubi Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.16 OS:Linux (ubuntu karmic)
Assigned to: Alfredo Kojima CPU Architecture:Any

[23 Feb 2010 6:09] x Hubi 
Description:
When I set Omit Schema Qualifier in Object Names it works fine for objects but insert data still contains the schema names.

So the generated script is not importable to another schema, it still wants to insert to the original schema

How to repeat:
Create a table and put some data into it with modeller. Than try to generate sql script with forward engeener and check Schema Qualifier in Object Names.

than try to run the script from console:
mysql -uXXX -pXXX XXXX<script.sql

Suggested fix:
Schema qualifier should be omitted in inserts too.
[23 Feb 2010 9:39] Andrea Bergamasco 
Noticed the same bug on Windows XP SP3, if possible i'd increase the severity of this bug.
[23 Feb 2010 9:41] Andrea Bergamasco 
Looks like this is a duplicate of bug #46837
[24 Feb 2010 2:44] Alfredo Kojima 
This has been fixed.
[24 Mar 2010 10:23] Johannes Taxacher 
fix confirmed in repository
[26 Mar 2010 11:49] Tony Bedford 
Added to changelog entry for bug#46837.