MySQL Bugs: #34397: Triggers tab automatically adds new header info after field update

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:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.0.13 OSS Beta	OS:	Windows (SP2)
Assigned to:	Sergei Tkachenko	CPU Architecture:	Any
Tags:	area, DELIMITER, header, rewrite, text, UPDATE

Description:
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.

Thank you for a problem report. Please, try to repeat with a newer version, 5.0.13, and inform about the results.

Unfortunately, trying this on the new version does not work and is still and issue.

Thank you for the bug report.

the DELIMITER statement only gets duplicated for me when i enter some characters (not when only adding newlines or spaces)

this is fixed now (tested SVN Rev 2917)

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.