-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.22.0
-
Component/s: None
-
Labels:
AggregateCaseToFilterRule handles NULL values incorrectly. It converts
SELECT COUNT(CASE WHEN b THEN NULL ELSE 1 END) FROM t
to
SELECT COUNT(*) FILTER (WHERE b IS FALSE) FROM t
which fails to count rows where b is UNKNOWN, so it should convert to
SELECT COUNT(*) FILTER (WHERE b IS NOT TRUE) FROM t
- links to