[
https://issues.apache.org/jira/browse/DRILL-309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13830811#comment-13830811
]
Julian Hyde commented on DRILL-309:
-----------------------------------
This is intentional behavior (and consistent with Oracle). If you want an
identifier to stay the same case, or if you wish to include punctuation such as
spaces, enclose the identifier in double-quotes. If you do not quote the
identifier, the parser converts it to upper-case.
For example,
select 1 as fooBar, 2 as "bazBuzz" from t
returns columns "FOOBAR", "bazBuzz".
> Optiq uppercases column names
> -----------------------------
>
> Key: DRILL-309
> URL: https://issues.apache.org/jira/browse/DRILL-309
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Mehant Baid
> Assignee: Mehant Baid
>
> Optiq uppercases column names. In a few places in Drill we've had to modify
> the comparison checks between the project expression and the actual field
> name to be case insensitive.
> Seems like Optiq is introducing project expressions with upper case column
> names. Need further investigation.
--
This message was sent by Atlassian JIRA
(v6.1#6144)
