You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Aman Sinha (JIRA)" <ji...@apache.org> on 2015/03/28 01:22:54 UTC
[jira] [Updated] (DRILL-1940) Define and document rules for SQL
identifiers
[ https://issues.apache.org/jira/browse/DRILL-1940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Aman Sinha updated DRILL-1940:
------------------------------
Fix Version/s: (was: 0.9.0)
1.0.0
> Define and document rules for SQL identifiers
> ----------------------------------------------
>
> Key: DRILL-1940
> URL: https://issues.apache.org/jira/browse/DRILL-1940
> Project: Apache Drill
> Issue Type: Bug
> Components: SQL Parser
> Affects Versions: 0.8.0
> Reporter: Victoria Markman
> Assignee: Aman Sinha
> Fix For: 1.0.0
>
>
> To start with:
> * Max length is 1024 (what are the units ? Bytes or characters ? )
> * Length is configurable: planner.identifier_max_length
> * What characters are allowed ?
> * Can names be UTF-8 characters ?
> * Fact: can't start with digits, anything else not allowed ?
> * Can't be reserved words
> * Case insensitive, but case preserving (with examples)
> * Quoted identifiers are not supported
> * What are the rules for dealing with ambiugius names ?
> * select *, a1 from `t1.json`;
> * select a1 as a1, a1 from t1;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)