Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Index selection hangs with IN clause

Description

Index selection with IN clause hangs in a particular case:

https://forums.couchbase.com/t/issue-with-in-operator/2078/11

version is 4.1.0-5005
// this query hangs where type is indexed
select * from bucketName where type='address' and (id in [29]);

// this works fine
select * from bucketName where type='address' and (someField=true and id in [29]);

Components

Affects versions

Fix versions

Labels

Environment

None

Link to Log File, atop/blg, CBCollectInfo, Core dump

None

Release Notes Description

None

Activity

Show:

Gerald Sangudi January 12, 2016 at 6:21 PM

Not reproducible in Watson.

Fixed
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Is this a Regression?

Unknown

Triage

Untriaged

Priority

Instabug

Open Instabug

PagerDuty

Sentry

Zendesk Support

Created January 11, 2016 at 6:02 PM
Updated April 30, 2016 at 7:38 PM
Resolved January 12, 2016 at 6:21 PM
Instabug