Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.6.1, Cheshire-Cat
-
Docker for Windows 10 20H2
Image: couchbase/server:7.0.0-beta
All services enabled
Plasma indexes
Loaded beer-sample and travel-sample buckets and created an empty default bucket
-
Untriaged
-
CBCollectInfo is attached
-
1
-
Yes
Description
Queries involving joins may hang unexpectedly and never return results. This query in particular, generated by the Linq2Couchbase integration tests, seems to work often:
SELECT `Extent2`.`airportname` as `airportName`, `Extent1`.`airline` as `airline`
|
FROM `travel-sample` as `Extent1`
|
INNER JOIN `travel-sample` as `Extent2` ON (`Extent1`.`destinationairport` = `Extent2`.`faa`)
|
WHERE ((`Extent1`.`type` = 'route') AND (`Extent2`.`type` = 'airport'))
|
LIMIT 1
|
I have replicated repeatedly from the .NET SDK, using cURL, and in the Query Workbench. The HTTP request appears to get hung and never return a value and, in the case of cURL, never timeout. However, sometimes (rarely) valid results are returned.
Attachments
Issue Links
- causes
-
MB-44258 join with double intersect scan returns no rows
- Closed