Details
-
Bug
-
Resolution: Fixed
-
Critical
-
5.0.0
-
Untriaged
-
Yes
Description
CREATE INDEX ix20 ON default(k0,k1); |
EXPLAIN SELECT d1.k0,d1.k1,d2.k3 FROM default d1 JOIN default d2 ON KEYS d1.k1 WHERE d1.k0 =1 ; |
In above query d1 can be covered and d2 is not covered due to lookup join.
When we add d2.k3 in projection or predicate it makes d1 uncovered even though index ix20 has all the info
This looks like regression of MB-22112