Jinfeng Ni created DRILL-3510:
---------------------------------
Summary: Add ANSI_QUOTES option so that Drill's SQL Parser will
recognize ANSI_SQL identifiers
Key: DRILL-3510
URL: https://issues.apache.org/jira/browse/DRILL-3510
Project: Apache Drill
Issue Type: Improvement
Components: SQL Parser
Reporter: Jinfeng Ni
Assignee: Aman Sinha
Currently Drill's SQL parser uses backtick as identifier quotes, the same as
what MySQL does. However, this is different from ANSI SQL specification, where
double quote is used as identifier quotes.
MySQL has an option "ANSI_QUOTES", which could be switched on/off by user.
Drill should follow the same way, so that Drill users do not have to rewrite
their existing queries, if their queries use double quotes.
{code}
SET sql_mode='ANSI_QUOTES';
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
