Bug #22233 Different syntax highlighting in query and edit mode.
Submitted: 11 Sep 2006 12:47 Modified: 15 Jan 2007 13:09
Reporter: Andreas Påhlsson (Basic Quality Contributor) Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.4rc OS:Linux (Linux)
Assigned to: Alfredo Kojima CPU Architecture:Any
Tags: Source Editors

[11 Sep 2006 12:47] Andreas Påhlsson
Description:
The syntax highlighting engine treats the SQL in query mode diffrent from edit mode. Some of the keywords are not highlighted in edit that is highlighted in query mode and vice versa.

Keyword examples:
BEGIN - Highlighted in query mode
INSERT INTO - Like BEGIN.
UPDATE ... SET - Like BEGIN.
SET - Like BEGIN.
DELIMITER - Not highlighted at all, but does in the Windows version.
ID - Highlights if part of a column name (eg table.id) in edit mode.
INDEX - Like ID.
DEFINER - Does not highlight as part of CREATE ... PROCEDURE

How to repeat:
Open a database with stored procedures.
Select the Script/Edit All Stored Procedures/Functions menu,
Copy the data and paste in a new query tab.
Compare
[5 Oct 2006 8:38] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 1.2.4rc, and inform about the results.
[5 Oct 2006 9:17] Andreas Påhlsson
The difference still exists in 1.2.4rc.
[10 Oct 2006 1:21] MySQL Verification Team
Thank you for the bug report.
[15 Jan 2007 13:09] Alfredo Kojima
This involves large changes, so although I'll try to match the syntax highlighting
coloring in both editors, replacing the editors will not be done because
of the current feature freeze. That may change in the future, but for the time 
being I'll mark this report as Won't fix.