Bug #62314 Workbench flags GROUP BY modifier WITH ROLLUP as bad.

• Submitted: 1 Sep 2011 2:00
• Modified: 1 Sep 2011 6:41
• Reporter: James Bromberger
• Status: Duplicate
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.2.34 CE (7780)
• OS: Windows (7 Home Premium, 64 bit)
• CPU Architecture: Any

[1 Sep 2011 2:00] James Bromberger

Description:
When trying to use the WITH ROLLUP modifier on a group by, it fails to execute. 

Reference: http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html
Sample query: SELECT year, SUM(profit) FROM sales GROUP BY year WITH ROLLUP;
The word "with" gets red underline.

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

This is against MySQL 5.5.12.

How to repeat:
Try examples from http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html

[1 Sep 2011 6:41] Valeriy Kravchuk

This is a duplicate of Bug #57178.