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)