Murtadha Makki Al Hubail created ASTERIXDB-3155:
---------------------------------------------------
Summary: 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
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)
