[jira] [Created] (DRILL-1940) Define and document rules for SQL identifiers

["Victoria Markman (JIRA)" <ji...@apache.org>]

Victoria Markman created DRILL-1940:
---------------------------------------

             Summary: 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


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)