Julian Hyde created CALCITE-3764:
------------------------------------
Summary: AggregateCaseToFilterRule handles NULL values correctly
Key: CALCITE-3764
URL: https://issues.apache.org/jira/browse/CALCITE-3764
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
{{AggregateCaseToFilterRule}} handles NULL values correctly. It converts
{code:sql}
SELECT COUNT(CASE WHEN b THEN NULL ELSE 1 END) FROM t
{code}
to
{code:sql}
SELECT COUNT(*) FILTER (WHERE b IS FALSE) FROM t
{code}
which fails to count rows where {{b}} is UNKNOWN, so it should convert to
{code:sql}
SELECT COUNT(*) FILTER (WHERE b IS NOT TRUE) FROM t
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
