MySQL Bugs: #72677: REPEAT ... UNTIL ... END REPEAT command does not highlite correctly in editor

Bug #72677	REPEAT ... UNTIL ... END REPEAT command does not highlite correctly in editor
Submitted:	19 May 2014 4:57	Modified:	23 May 2018 19:41
Reporter:	MIGUEL DAVID GOMEZ	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S4 (Feature request)
Version:	6.1.6	OS:	Windows (Microsoft Enterprise Edition build 9200, 64-bit)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
When you are into the editor for stored procedures or triggers, if you use the REPEAT ... UNTIL ... END REPEAT; command, the REPEAT keyword are not highlited, and that will not be a big deal but the contract/expand fuction of the editor does not work fine. You can not contract/expand a REPEAT ... UNTIL code section and also affect others block codes thst no contract/expand correctly.

How to repeat:
Place code for the REPEAT ... UNTIL ... END REPEAT; command that have some sentences inside.
In order you can appreciate the effect you will try to include also IF ... THEN ... ELSE block codes and/or WHILE sentences nested in conjunction with the REPEAT sentence.

Suggested fix:
Add the highlite and contract/expand functionality for the REPEAT ... UNTIL ... END REPEAT command.

Hello MIGUEL,

Thank you for the feature request!

Thanks,
Umesh

How to repeat:

Try this code in SQL Editor

delimiter //

CREATE PROCEDURE dorepeat(p1 INT)
 BEGIN
   SET @x = 0;
   REPEAT
     SET @x = @x + 1;
   UNTIL @x > p1 END REPEAT;
 END
 //

delimiter ;

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.12 release, and here's the changelog entry:

Keywords in stored procedures and triggers were not highlighted
consistently within the SQL editor and code blocks with keywords did not
expand or collapse as expected.

Thank you for the bug report.