You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Daniel Barclay (Drill) (JIRA)" <ji...@apache.org> on 2015/08/26 01:58:45 UTC
[jira] [Commented] (DRILL-3510) Add ANSI_QUOTES option so that
Drill's SQL Parser will recognize ANSI_SQL identifiers
[ https://issues.apache.org/jira/browse/DRILL-3510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14712208#comment-14712208 ]
Daniel Barclay (Drill) commented on DRILL-3510:
-----------------------------------------------
Will the standard-identifier-quotes mode be controllable via a regular session option that shows up in the options table?
(If so, the JDBC driver can read the value by querying that table, and should be able do basic caching, reusing a cached value between queries (when, say, a BI tool might make multiple calls to generate delimited identifiers), and invaliding the cache when the next SQL statement is executed (because it could be one that changes the option value).)
> 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
> Fix For: 1.3.0
>
> Attachments: DRILL-3510.patch
>
>
> 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)