Description
CREATE INDEX test ON default(field1) WHERE field2 = "value";
And then I do a query for field1:
EXPLAIN SELECT field1 FROM default WHERE field1 IS NOT MISSING AND field2 = "value";
The query is not covered in the execution plan. However it does not show up as covered and I need to additionally add field2 into the index statement:
CREATE INDEX test ON default(field1,field2) WHERE field2 = "value";