You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "TJ Banghart (Jira)" <ji...@apache.org> on 2022/09/06 23:31:00 UTC

[jira] [Created] (CALCITE-5270) Firebolt dialect should return false for `supportsAggregateFunctionFilter`

TJ Banghart created CALCITE-5270:
------------------------------------

             Summary: Firebolt dialect should return false for `supportsAggregateFunctionFilter`
                 Key: CALCITE-5270
                 URL: https://issues.apache.org/jira/browse/CALCITE-5270
             Project: Calcite
          Issue Type: Bug
    Affects Versions: 1.31.0
            Reporter: TJ Banghart
            Assignee: TJ Banghart


Fierbolt does not support filter clauses in aggregate functions. e.g. `COUNT(*) FILTER (WHERE a = 2)`  throws 

```
Invalid operation error: SQL query not valid.
SQL query:
==========
SELECT COUNT(*) FILTER (WHERE a = 2)
                                             ^=== ERROR HERE!
==========
```
The [dialect implementation|https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/sql/dialect/FireboltSqlDialect.java] should override the `supportsAggregateFunctionFilter` method it currently inherits from the  base `SqlDialect` class ([link|https://github.com/apache/calcite/blob/b9c2099ea92a575084b55a206efc5dd341c0df62/core/src/main/java/org/apache/calcite/sql/SqlDialect.java#L758])
https://docs.firebolt.io/sql-reference/functions-reference/



--
This message was sent by Atlassian Jira
(v8.20.10#820010)