Bug #54222 "Omit Schema Qualifier in Object Names" option doesn't apply to triggers.
Submitted: 4 Jun 2010 2:55 Modified: 14 Jun 2010 10:47
Reporter: Yen-Wei Liu Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.22 OS:Windows (XP SP3)
Assigned to: Alexander Musienko CPU Architecture:Any

[4 Jun 2010 2:55] Yen-Wei Liu
"Omit Schema Qualifier in Object Names" options in "Forward Engineer" doesn't work completely with Triggers.

How to repeat:
As in "Forward Engineer", the generated SQL would prepend schema name (database name) before objects like tables. views, etc. When checking "Omit Schema Qualifier in Object Names", this schema name would disappear . But in Trigger DDL, there are at least two "USE <Database Name> $$" statements still around
[4 Jun 2010 2:58] Yen-Wei Liu
Sorry for my wording. As I said "doesn't work completely" , I meant "works partially".
[11 Jun 2010 16:07] Johannes Taxacher
fix confirmed in repository
[14 Jun 2010 10:47] Tony Bedford
An entry has been added to the 5.2.23 changelog:

The forward engineering option Omit Schema Qualifier in Object Names was not correctly applied to some statements in Trigger code. In these cases the schema name remained in place.