drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-1064) Unexpected results when selecting for arbitrary alphanumeric column
Date Wed, 25 Jun 2014 16:14:24 GMT

     [ https://issues.apache.org/jira/browse/DRILL-1064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau resolved DRILL-1064.
-----------------------------------

    Resolution: Invalid

Backtick quoting should work.  Please reopen if it does not.

> Unexpected results when selecting for arbitrary alphanumeric column
> -------------------------------------------------------------------
>
>                 Key: DRILL-1064
>                 URL: https://issues.apache.org/jira/browse/DRILL-1064
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: SQL Parser
>            Reporter: Norris Lee
>
> When selecting for an alphanumeric column that starts with numbers, the starting numbers
end up as values and the remainder become the column name.
> {code}
> 0: jdbc:drill:zk=localhost:5181> select 1231q235 from `hive43.default`.`bit_table`;
> +------------+
> |    q235    |
> +------------+
> | 1231       |
> | 1231       |
> +------------+
> 2 rows selected (0.356 seconds)
> {code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message