Bug #55891 Syntax Highlighter marks PARTITION Statement as error
Submitted: 10 Aug 2010 18:16 Modified: 11 Aug 2010 16:18
Reporter: Johannes Taxacher Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S4 (Feature request)
Version:5.2.26 OS:Any
Assigned to: CPU Architecture:Any

[10 Aug 2010 18:16] Johannes Taxacher
Description:
this report is for the syntax-highlighting error in Bug #55867.

when trying out an example in the MySQL Server 5.5 documentation
(http://dev.mysql.com/doc/refman/5.5/en/partitioning-columns-range.html) 
some partitioning syntax (new in server 5.5) is highlighted as err.

How to repeat:
copy/enter following statement into the sql query editor:

CREATE TABLE rcx (
        a INT,
        b INT,
        c CHAR(3),
        d INT
    )
    PARTITION BY RANGE COLUMNS(a,d,c) (
        PARTITION p0 VALUES LESS THAN (5,10,'ggg'),
        PARTITION p1 VALUES LESS THAN (10,20,'mmmm'),
        PARTITION p2 VALUES LESS THAN (15,30,'sss'),
        PARTITION p3 VALUES LESS THAN (MAXVALUE,MAXVALUE,MAXVALUE)
    );

the "COLUMNS" keyword will be highlighted as err
[11 Aug 2010 15:25] Johannes Taxacher
fix confirmed in repository
[11 Aug 2010 16:18] Tony Bedford
An entry has been added to the 5.2.27 changelog:

In the SQL Editor, executing statements designed for MySQL Server version 5.5 generated syntax highlighting errors.