MySQL Bugs: #60577: bad syntax error

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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

This is a duplicate of Bug #59962.