[jira] [Created] (DRILL-1867) Case sensitivity of query identifiers is inconstistent

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

Victoria Markman created DRILL-1867:
---------------------------------------

             Summary: Case sensitivity of query identifiers is inconstistent
                 Key: DRILL-1867
                 URL: https://issues.apache.org/jira/browse/DRILL-1867
             Project: Apache Drill
          Issue Type: Bug
          Components: SQL Parser
    Affects Versions: 0.7.0
            Reporter: Victoria Markman


git.commit.id.abbrev=c65928f
In this  query it looks like identifies are case insensitive.

0: jdbc:drill:schema=dfs> select Eventdate from `test.json` where eventdate is not null;
+------------+
| Eventdate  |
+------------+
| 2014-01-01 |
| 2014-01-01 |
| 2014-02-01 |
+------------+
3 rows selected (0.107 seconds)

However, in subquery, they suddenly change the behavior and become case sensitive.

0: jdbc:drill:schema=dfs> select EVENTDATE from ( select Eventdate from `test.json` where eventdate is not null );
Query failed: Query failed: Failure validating SQL. org.eigenbase.util.EigenbaseContextException: From line 1, column 8 to line 1, column 16: Column 'EVENTDATE' not found in any table
Error: exception while executing query: Failure while executing query. (state=,code=0)


This happens not only when querying unstructured data, but Drill tables as well:

0: jdbc:drill:schema=dfs> select Customerid from test where customerid = 100;
+------------+
| Customerid |
+------------+
| 100        |
+------------+



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)