[
https://issues.apache.org/jira/browse/CALCITE-6306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
hongyu guo updated CALCITE-6306:
Summary: FILTER clauses for aggregate functions are not supported in MySQL,
MariaDB and
[
https://issues.apache.org/jira/browse/CALCITE-6306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
hongyu guo updated CALCITE-6306:
Description:
{code:sql}
mysql> select sum(x) filter (where x = 1) from t;
ERROR 1064 (42000):
[
https://issues.apache.org/jira/browse/CALCITE-6306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
hongyu guo updated CALCITE-6306:
Description:
{code:sql}
mysql> select sum(x) filter (where x = 1) from t;
ERROR 1064 (42000):
[
https://issues.apache.org/jira/browse/CALCITE-6306?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-6306:
Labels: pull-request-available (was: )
> FILTER clauses for aggregate functions are not