Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
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.
Build couchbase-server-7.0.0-4446 contains query commit 09578d9 with commit message:
MB-44258join with intersect scan returns no rows, regression from MB 42825