[
https://issues.apache.org/jira/browse/ASTERIXDB-3155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ian Maxon reassigned ASTERIXDB-3155:
------------------------------------
Assignee: Ritik Raj
> Cannot escape backticks in SQL++
> --------------------------------
>
> Key: ASTERIXDB-3155
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3155
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: SQL - Translator SQL++
> Affects Versions: 0.9.8
> Reporter: Murtadha Makki Al Hubail
> Assignee: Ritik Raj
> Priority: Major
> Fix For: 0.9.9
>
>
> To reproduce:
> {noformat}
> create type t as {id:int};
> create dataset ds(t) primary key id;
> upsert into ds {"id":1, "first `name":"xyz"};
> {noformat}
> Now try to select the field "first `name". All of the following return errors:
> {noformat}
> SELECT * FROM ds WHERE `first `name`="XYZ";
> SELECT * FROM ds WHERE `first \`name`="XYZ";
> SELECT * FROM ds WHERE `first ``name`="XYZ";
> {noformat}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
