drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jinfeng Ni (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3510) Add ANSI_QUOTES option so that Drill's SQL Parser will recognize ANSI_SQL identifiers
Date Fri, 17 Jul 2015 18:32:04 GMT
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)

Mime
View raw message