Bug #60577 bad syntax error
Submitted: 22 Mar 2011 6:21 Modified: 22 Mar 2011 8:31
Reporter: Andy Pumpkin Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.33 OS:Windows (win xp sp3)
Assigned to: CPU Architecture:Any
Tags: with

[22 Mar 2011 6:21] Andy Pumpkin
Description:
SELECT year, country, product, SUM(profit)
FROM sales
GROUP BY year, country, product WITH ROLLUP;

It's a good statement.But in the SQL Editor of Workbench, it's marked "syntax error". I think the bug is that the "with" keyword is not parsed perfectly.

How to repeat:
If you edit a statement which has "with rollup" clause in the SQL Editor of Workbench, you will see the "syntax error".

Suggested fix:
Checking how to parse "with rollup" clause
[22 Mar 2011 8:31] Valeriy Kravchuk
This is a duplicate of Bug #59962.