Skip to:

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

[BP to 7.0.4,7.1.1] - adhoc query index selection issue with LIKE as index condition and query parameters

Description

 

 

 

Above adhoc query does n't choose the index. 

Following works.

 

EXPLAIN SELECT 1 FROM default WHERE c1 = 10 AND type LIKE "airport%";

 

 DNF transformation might not happened LIKE before index selection.

Components

Affects versions

Fix versions

Labels

Environment

None

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

None

Release Notes Description

None

Activity

Show:

CB robot October 7, 2022 at 8:56 AM

Build couchbase-server-7.2.0-5000 contains query commit b2ed5c7 with commit message:
Compare with original index condition for index eligibility

Ajay Pal Bhullar May 20, 2022 at 7:10 AM

verified in 7.1.1-3063

Ajay Pal Bhullar May 20, 2022 at 2:56 AM

verified in 7.0.4-7275, also regression is running cleanly.

CB robot May 16, 2022 at 8:14 PM

Build couchbase-server-7.0.4-7274 contains query commit 93e3bc9 with commit message:
Compare with original index condition for index eligibility

CB robot May 16, 2022 at 7:48 PM

Build couchbase-server-7.1.1-3063 contains query commit b2ed5c7 with commit message:
Compare with original index condition for index eligibility

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

Details

Assignee

Reporter

Is this a Regression?

Yes

Triage

Untriaged

Story Points

Priority

Instabug

Open Instabug

PagerDuty

Sentry

Zendesk Support

Created May 16, 2022 at 5:00 PM
Updated October 7, 2022 at 8:56 AM
Resolved May 16, 2022 at 10:01 PM
Instabug