drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victoria Markman (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1940) Define and document rules for SQL identifiers
Date Tue, 06 Jan 2015 21:49:34 GMT
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

View raw message