Details
-
Bug
-
Resolution: Fixed
-
Critical
-
5.5.5, 6.5.0
-
None
-
Untriaged
-
Yes
Description
Repro:
INSERT INTO default VALUES ("k01",{"date": "2019-08-09T05:25:40.78-07:00","type": "test"}); |
create index ix1 ON default (date DESC) WHERE type = "test"; |
SELECT COUNT(1) FROM default WHERE date IS NOT MISSING AND type = "test"; |
Above query returns 0 (wrong results), Below query returns 1 (right results)
Both uses right plan and uses index aggregation.
SELECT COUNT(1) FROM default WHERE date IS NOT NULL AND type = "test"; |