Skip to:

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

[BP to 7.2.1 MB-56088] - Advised statement gives syntax error

Description

Try following combinations

 

 

 

 Starts with _ALL

 

Issue

Resolution

An ADVISE statement with multiple levels of UNNEST caused a syntax error in the CREATE INDEX statement from the Index Advisor.

ADVISE has been improved when there are queries with multiple levels of UNNEST.

Components

Affects versions

Fix versions

Labels

Environment

None

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

None

Release Notes Description

None

Attachments

1

Activity

Show:

Pierre Regazzoni July 17, 2023 at 1:58 PM
Edited

Verified on 7.2.1-5857 see

CB robot July 13, 2023 at 12:27 AM

Build couchbase-server-7.2.1-5857 contains query-ee commit da334c9 with commit message:
Improve ADVISE for queries with multiple levels of UNNEST

CB robot July 13, 2023 at 12:27 AM

Build couchbase-server-7.2.1-5857 contains query commit 89b0d6f with commit message:
Improve ADVISE for queries with multiple levels of UNNEST

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

Details

Assignee

Reporter

Is this a Regression?

Unknown

Triage

Untriaged

Issue Impact

external

Story Points

Priority

Instabug

Open Instabug

PagerDuty

Sentry

Zendesk Support

Created July 12, 2023 at 10:07 PM
Updated March 21, 2025 at 2:50 AM
Resolved July 13, 2023 at 2:14 AM
Instabug