Bug #51061 Syntax coloring omits "OLD" in triggers
Submitted: 10 Feb 2010 14:36 Modified: 11 May 2010 13:56
Reporter: Martin Pirringer Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.15 OS:Any
Assigned to: Mike Lischke CPU Architecture:Any
Tags: old, Syntax Coloring, trigger

[10 Feb 2010 14:36] Martin Pirringer 
Description:
In triggers "NEW" as in "new.myfield" Is colored but "OLD" like in "old.myfield" is not Both "OLD" and "NEW" are trigger aliases and therefore should be treated equally when it comes to syntax coloring

How to repeat:
IN WB create a Trigger (for example Before update) and use both "old" and "new" aliases like 

@dif = new.myfield - old.myfield

Suggested fix:
Also color "old"
[10 Feb 2010 14:51] Valeriy Kravchuk 
Thank you for the problem report. Verified just as described on Windows XP.
[10 Feb 2010 14:52] MySQL Verification Team 
Thank you for the bug report.
[7 May 2010 10:20] Mike Lischke 
Fixed in repository.
[10 May 2010 21:57] Johannes Taxacher 
fix confirmed in repository
[11 May 2010 13:56] Tony Bedford 
An entry has been added to the 5.2.21 changelog:

In trigger code, triggers using the alias 'new' were correctly colored by the syntax highlighter, but triggers using the alias 'old' were not colored.