Skip to:

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

[BP MB-56039 to 7.1.5] - OR clause doesn't push variable spans

Description

CREATE INDEX ix1 ON default(ticker, ts_start, ts_end);

ts_end range is not pushed indexer. This can heavily impact because Fetch involved. 

 

Issue

Resolution

A query plan was changed between Server releases. This meant the filter did not update the index when an OR clause pushed variable spans.

The OR clause has been modified to correct this issue.

Components

Affects versions

Fix versions

Labels

Environment

None

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

None

Release Notes Description

None

Activity

Show:

Pierre Regazzoni May 19, 2023 at 12:28 AM

Verified on 7.1.5-3804

CB robot May 17, 2023 at 1:42 AM

Build couchbase-server-7.1.5-3804 contains query commit d885900 with commit message:
Modify OR-clause handling

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, 2023 at 7:13 PM
Updated September 19, 2023 at 11:09 AM
Resolved May 17, 2023 at 3:26 AM
Instabug