Bug #38436 "Synchronize to database" fail for triggers
Submitted: 29 Jul 2008 19:43 Modified: 12 Aug 2008 13:36
Reporter: Vincent Courcelle Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.0.23 OS:Any
Assigned to: Vladimir Kolesnikov CPU Architecture:Any
Tags: synchronize, triggers

[29 Jul 2008 19:43] Vincent Courcelle
Description:
It's not possible to "Synchronize" to a database when the model contains some triggers:

Error 1046: No database selected
CREATE TRIGGER Table_INSERT AFTER INSERT ON Table FOR EACH ROW BEGIN
     ...
END;

There is no error with tables (they are successfully created)

How to repeat:
Create a new model and insert triggers in it.
[3 Aug 2008 6:55] Valeriy Kravchuk
Thank you for a bug report. Verified just as described on Windows XP SP2.
[8 Aug 2008 18:53] Johannes Taxacher
the problem is fixed. fix will be included in 5.0.24
[12 Aug 2008 13:36] Tony Bedford
An entry was added to the 5.0.24 changelog:

It was not possible to synchronize a model to an external database, if the model contained triggers.
[2 Sep 2009 8:55] Colm Ward
This bug still exists with MySQL Workbench 5.1.17 on Mac OS X 10.5.7
[4 Sep 2009 8:29] Huw Thomas
I'm running 5.1.17 rev 4302 on Windows (Vista) and am getting No Database Selected error when syncing triggers.