Bug #34397 Triggers tab automatically adds new header info after field update
Submitted: 7 Feb 2008 22:32 Modified: 8 Apr 2008 14:29
Reporter: Rob M Email Updates:
Status: Closed Impact on me:
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.13 OSS Beta OS:Microsoft Windows (SP2)
Assigned to: Sergei Tkachenko
Tags: area, DELIMITER, header, rewrite, text, UPDATE
Triage: D3 (Medium)

[7 Feb 2008 22:32] Rob M
Upon updating the text area a re-evaluation of all text between the starting and closing DELIMITER statement is triggered causing the addition of the default USE context content to be added within the starting and closing DELIMITER statements.  Occurs on every update after approximately 2-5 seconds of idle.

Example of added text on each update:
-- dbname.tblname Trigger SQL DDL Statements" 
USE dbname//

How to repeat:
Open a table and chose the "Triggers" tab.

Select the line just below "DELIMITER //", and add one new line or really do anything in the area between the first and last DELIMITER statements.

Wait 2-5 seconds.

Suggested fix:
No workaround that I was able to find, even after deleting the text and quickly changing tabs still adds the text just below the first DELIMIT statement.
[8 Feb 2008 4:12] Valerii Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 5.0.13, and inform about the results.
[12 Feb 2008 22:32] Rob M
Unfortunately, trying this on the new version does not work and is still and issue.
[13 Feb 2008 22:41] Miguel Solorzano
Thank you for the bug report.
[19 Feb 2008 18:04] Johannes Taxacher
the DELIMITER statement only gets duplicated for me when i enter some characters (not when only adding newlines or spaces)
[1 Apr 2008 18:50] Johannes Taxacher
this is fixed now (tested SVN Rev 2917)
[8 Apr 2008 14:29] MC Brown
A note has been added to the 5.0.17 changelog: 

Editing the text of the Trigger portion of an existing schemata would introduce additional text into the Trigger definition.