Loading...

XML

Word

Printable

CREATE INDEX ix11 ON default (ALL ARRAY v.fname FOR v IN Names END) WHERE `type`="doc" AND `owner`="xyz";

EXPLAIN SELECT RAW meta().id FROM default WHERE type="doc" AND owner="xyz" AND ANY v IN Names SATISFIES (v.fname='John' AND v.lname ='Doe') END;

As there is no lname in the index it should not covering. The implict covering of ANY predicate must handle any part that is not covered.

causes

MB-35568 30% drop in TP for array queries

relates to

MB-35732 back out fixes in index covering determination

For Gerrit Dashboard: MB-35392
#	Subject	Branch	Project	Status	CR	V
112882,2	MB-35392 Make sure ANY clause is properly covered by array index	master	query	Status: MERGED	+2	+1
112883,2	MB-35392 Make sure ANY clause is properly covered by array index	alice	query	Status: MERGED	+2	+1
112884,2	MB-35392 Make sure ANY clause is properly covered by array index	vulcan	query	Status: MERGED	+2	+1
113978,3	MB-35732 Backout previous fixes in index covering determination	vulcan	query	Status: MERGED	+2	+1

There are no open Gerrit changes

Hide There are 4 closed Gerrit changes

MB-35392 Make sure ANY clause is properly covered by array index: Gerrit Review:

MB-35392 Make sure ANY clause is properly covered by array index: Gerrit Review:

MB-35392 Make sure ANY clause is properly covered by array index: Gerrit Review:

MB-35732 Backout previous fixes in index covering determination: Gerrit Review:

Query is wrongly covering will result in wrong results