Details
-
Bug
-
Resolution: Fixed
-
Major
-
Cheshire-Cat
-
Untriaged
-
1
-
Yes
Description
Load travel-sample, drop all indexes created by default.
create index def_type on `travel-sample`(type);
create index def_city on `travel-sample`(city);
select h.city, h.name, a.airportname from `travel-sample` a join `travel-sample` h on a.city = h.city where h.type = "hotel" and a.type = "airport";
this query uses intersect scan of the two indexes under nested-loop join. Return no result.
select h.city, h.name, a.airportname from `travel-sample` a join `travel-sample` h USE HASH(build) on a.city = h.city where h.type = "hotel" and a.type = "airport";
this query forces hash join and returns 2212 result documents.
Attachments
Issue Links
For Gerrit Dashboard: MB-44258 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
145674,2 | MB-44258 join with intersect scan returns no rows, regression from MB 42825 | mad-hatter | query | Status: MERGED | +2 | +1 |
145819,4 | MB-44258 join with intersect scan returns no rows, regression from MB 42825 | master | query | Status: MERGED | +2 | +1 |