[CX] query with expression.* in where clause not expressible in current CBAS

Description

n1ql query:
SELECT tasks_points FROM default_shadow WHERE tasks_points.* LIKE '_1%';

When I executed above query with analytics I get:
"msg": "Syntax error: In line 1 >>SELECT tasks_points FROM default_shadow WHERE tasks_points.* LIKE '_1%';<< Encountered '' \"\" at column 60. "

Components

Affects versions

Fix versions

Environment

"build.number": "193"

Release Notes Description

None

Activity

Show:

Till Westmann September 11, 2019 at 12:53 AM

Bulk closing issues resolved for 6.0.0.

Dmitry Lychagin September 26, 2018 at 5:55 PM

We'll use documentation issue to track progress: https://couchbasecloud.atlassian.net/browse/DOC-4183

Till Westmann July 17, 2018 at 11:02 PM

variable.* is not an expression. It's syntactic sugar that only works in the SELECT clause. It should be documented in the SELECT clause.

Till Westmann April 12, 2018 at 1:01 AM
Edited

We should clarify the supported behavior in common documentation and/or a test case.

Dmitry Lychagin February 21, 2018 at 11:25 PM

The following query fails in N1QL:

SELECT children FROM tutorial WHERE children.* LIKE '%Bill%';

with error message: "syntax error - at *"

SELECT variable.* feature is handled by https://couchbasecloud.atlassian.net/browse/MB-17594

Should we close this issue?

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

Details

Assignee

Dmitry Lychagin(Deactivated)

Reporter

Sprint

Priority

Instabug

Open Instabug

PagerDuty

Sentry

Zendesk Support

Created September 28, 2016 at 6:08 AM
Updated October 24, 2022 at 4:40 PM
Resolved September 26, 2018 at 5:55 PM
Instabug