Wrong results when filter has conditional query parameters

Description

Components

Affects versions

Fix versions

Labels

Environment

None

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

None

Release Notes Description

None

Activity

Pierre Regazzoni October 28, 2022 at 5:58 PM

Verified on 7.0.5-7626

CB robot October 27, 2022 at 6:07 AM

Build couchbase-server-7.0.5-7626 contains query commit 6e036b6 with commit message:
Handle OR predicate better

Sitaram Vemulapalli September 23, 2022 at 9:18 PM
Edited

Work around:  AND length(d.c1) > 0

 

 

 

Sitaram Vemulapalli September 23, 2022 at 2:49 AM

It works on master which marks spans not exact  no index aggregates.

(Build couchbase-server-7.1.1-3083 contains query commit 9626e62 with commit message:
 Push available filters to index scan to reduce fetch size) Fixes in 7.1

Those can't be back ported but need to find root cause and fix if one needs fix. 

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

Details

Assignee

Reporter

Issue Impact

external

Story Points

Priority

Instabug

Open Instabug

PagerDuty

Sentry

Zendesk Support

Created September 23, 2022 at 2:47 AM
Updated 8 hours ago
Resolved October 27, 2022 at 4:06 PM
Instabug