Bug #50836 Weird behavior of SQL editors
Submitted: 2 Feb 2010 14:17 Modified: 20 Apr 2010 9:52
Reporter: Mike Lischke Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version: OS:Windows (7)
Assigned to: Assigned Account CPU Architecture:Any

[2 Feb 2010 14:17] Mike Lischke
Description:
SQL Editors in the modelling section behave strangely depending on user input. Sometimes even valid SQL is simply removed.

How to repeat:
Create new model, create new routine. Open this routine, it comes up with some default text. Add something valid like:

-- --------------------------------------------------------------------------------
-- Routine DDL
-- --------------------------------------------------------------------------------
DELIMITER //

CREATE PROCEDURE `mydb`.`routine1` ()
BEGIN
  select 1;
END//

Now set the caret at the end of the text (next line after final //). Type something wrong and wait until error checking kicks in. The good SQL is overwritten with the wrong text.

Suggested fix:
n/a
[20 Apr 2010 9:52] Sergei Tkachenko
Fixed along with the bug #52587.