hongyu guo created CALCITE-6306:
-----------------------------------
Summary: FILTER clauses for aggregate functions are not supported
in MySQL, MariaDB and Starrocks
Key: CALCITE-6306
URL: https://issues.apache.org/jira/browse/CALCITE-6306
Project: Calcite
Issue Type: Bug
Reporter: hongyu guo
{code:sql}
mysql> select sum(x) filter (where x = 1) from t;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'(where x = 1) from t' at line 1 {code}
See details in https://modern-sql.com/feature/filter
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
