[CX] query with expression.* in where clause not expressible in current CBAS
Description
Components
Affects versions
Fix versions
Environment
"build.number": "193"
Release Notes Description
None
relates to
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 AMEdited
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
Reporter
Prerna Manaktala
Prerna ManaktalaSprint
None
Priority
Major
Instabug
Open Instabug
PagerDuty
PagerDuty Incident
PagerDuty Incident
Sentry
Linked Issues
Linked Issues
Zendesk Support
Linked Tickets
Linked Tickets
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
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. "