Skip to content
This repository was archived by the owner on Jan 28, 2021. It is now read-only.
This repository was archived by the owner on Jan 28, 2021. It is now read-only.

No data for NOT expressions with non existing value and index #323

Closed
@kuba--

Description

@kuba--
CREATE INDEX email_idx ON commits USING pilosalib (commit_author_email);
SELECT count(*) FROM commits WHERE  NOT (commit_author_email='non existing trash');

Get 0 rows. It doesn't work for both drivers (pilosa and pilosalib).

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions