[
https://issues.apache.org/jira/browse/CALCITE-1710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde resolved CALCITE-1710.
----------------------------------
Resolution: Not A Problem
Calcite already does everything you think that it should. Closing.
And by the way, according to the link you posted, SQL Server is no "looser"
than Calcite. Everything they support, we support.
> GroupBy columns support arithmetic expression
> ---------------------------------------------
>
> Key: CALCITE-1710
> URL: https://issues.apache.org/jira/browse/CALCITE-1710
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: lincoln.lee
> Assignee: Julian Hyde
> Priority: Minor
>
> Currently only original column reference(s) and column(s) with UDF valid in
> group by clause but arithmetic expression(s) not allowed, while most RDBMS
> support
> like thus:
> {code}
> SELECT
> ColumnA + ColumnB
> FROM T
> GROUP BY ColumnA + ColumnB;
>
> SELECT
> ColumnA + ColumnB + constant
> FROM T
> GROUP BY ColumnA, ColumnB;
> SELECT
> ColumnA % 3
> FROM T
> GROUP BY ColumnA %3;
> {code}
> we can treat these arithmetic operators as builtin UDFs and support these
> kind of query, it'll be a useful feature.
> What do you think?
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
