Loading...

XML

Word

Printable

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";

is cloned by

MB-35803 COUNT on Index FullScan gives wrong results

No reviews matched the request. Check your Options in the drop-down menu of this sections header.

There are no open Gerrit changes

Hide There is 1 closed Gerrit change

[BP 6.0.3] COUNT on Index FullScan gives wrong results