[
https://issues.apache.org/jira/browse/CALCITE-5412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Leonid Chistov updated CALCITE-5412:
------------------------------------
Description:
CUBE clause seems to be not supported in MYSQL5 in any form
([https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html]), but there
is no check for that in Calcite.
Thus, SQL statement with CUBE clause may be erroneously generated by JDBC
adapter for MySQL 5 dialect, causing syntax error issue later on.
was:CUBE clause seems to be not supported in MYSQL5.x in any form
([https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html]), but we
don’t check it.
> JDBC adapter incorrectly generates CUBE for MySQL 5
> ---------------------------------------------------
>
> Key: CALCITE-5412
> URL: https://issues.apache.org/jira/browse/CALCITE-5412
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.32.0
> Reporter: Leonid Chistov
> Priority: Trivial
>
> CUBE clause seems to be not supported in MYSQL5 in any form
> ([https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html]), but
> there is no check for that in Calcite.
> Thus, SQL statement with CUBE clause may be erroneously generated by JDBC
> adapter for MySQL 5 dialect, causing syntax error issue later on.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
