Bug #82821 Remove the unused and non-standard "WITH CUBE" syntax clause
Submitted: 31 Aug 2016 12:05 Modified: 16 Nov 2016 19:47
Reporter: Roy Lyseng Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Parser Severity:S3 (Non-critical)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[31 Aug 2016 12:05] Roy Lyseng
Description:
The parser accepts the syntax element WITH CUBE within a GROUP BY clause. However, this syntax is neither implemented in any version of MySQL, nor part of the SQL standard, so we should really consider deleting it from the grammar. 

How to repeat:
SELECT g, COUNT(*) FROM t GROUP BY g WITH CUBE;

The standard-compliant way to specify a CUBE is:

SELECT g, COUNT(*) FROM t GROUP BY CUBE(g);

Suggested fix:
Remove the syntax.
[16 Nov 2016 19:47] Paul DuBois
Posted by developer:
 
Noted in 8.0.1 changelog.

The unimplemented and nonstandard WITH CUBE clause for GROUP BY is no
longer supported.