Bug #53151 automaticaly added delimiter in triggerwindow after changing MYSQL Schema
Submitted: 26 Apr 2010 8:22 Modified: 21 May 2010 14:16
Reporter: Michael Schramm Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.19 beta OS:Windows (Windows7, XP)
Assigned to: Alexander Musienko CPU Architecture:Any
Tags: change schema, DELIMITER, trigger

[26 Apr 2010 8:22] Michael Schramm 
Description:
After changing the MYSQL Schema
and reopen a table with trigger
there where new DELIMITER entries added into the SQL code

How to repeat:
create a table and add a trigger

Open section "Physical Schema"
-> doubleclick on MYSQL Schema
--> change the MYSQL Schema (i.e. database1 -> database 2 )
---> click on the grey flash in the right corner of the schema input field
----> close and reopen the table with the trigger
-----> open the trigger window.

Any time you do this again there where following lines added into 
the trigger SQL:

DELIMITER $$

DELIMITER ;
;
$$
[26 Apr 2010 9:28] Valeriy Kravchuk 
Thank you for the bug report. Verified just as described on Windows XP.
[20 May 2010 16:55] Johannes Taxacher 
fix confirmed in repository
[21 May 2010 14:16] Tony Bedford 
An entry has been added to the 5.2.22 changelog:

Delimiters were erroneously added to trigger code if the currently selected schema was changed