Bug #63756 ROLLUP COMMAND FAILS IN WORKBENCH QUERY EXECUTION

• Submitted: 15 Dec 2011 5:40
• Modified: 15 Dec 2011 8:38
• Reporter: Fausto Chepil
• Status: Duplicate
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.2.35CE REV7915
• OS: Windows (W7 PRO 64bit)
• CPU Architecture: Any
• Tags: with rollup

[15 Dec 2011 5:40] Fausto Chepil

Description:
ERROR 1064 RETURNED WHEN A QUERY IS EXECUTED THAT INCLUDES THE "GROUP BY" AND "WITH ROLLUP" COMMANDS.  IF SAME QUERY IS EXECUTED IN COMMAND LINE INTERFACE NO ERROR IS RETURNED AND THE QUERY IS EXECUTED SUCCESSFULLY.

How to repeat:
use the "ROLLUP" command with a query in the MySQL workbench.

Suggested fix:
Add the ROLLUP function to the web workbench.

[15 Dec 2011 8:38] Valeriy Kravchuk

This is a duplicate of Bug #57178.