[jira] [Commented] (ARROW-10329) [Rust][Datafusion] Datafusion queries involving a column name that begins with a number produces unexpected results

["Andrew Lamb (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ARROW-10329?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17332302#comment-17332302 ] 

Andrew Lamb commented on ARROW-10329:
-------------------------------------

Migrated to github: https://github.com/apache/arrow-datafusion/issues/108

> [Rust][Datafusion] Datafusion queries involving a column name that begins with a number produces unexpected results
> -------------------------------------------------------------------------------------------------------------------
>
>                 Key: ARROW-10329
>                 URL: https://issues.apache.org/jira/browse/ARROW-10329
>             Project: Apache Arrow
>          Issue Type: Bug
>          Components: Rust - DataFusion
>            Reporter: Morgan Cassels
>            Priority: Major
>
> This bug can be worked around by wrapping column names in quotes.
> Example:
> {{let query = "SELECT 16_20mph, 21_25mph FROM foo;"}}
> {{let logical_plan = ctx.create_logical_plan(query)?;}}
> {{logical_plan.schema().fields() now has fields: [_20mph, _25mph]}}
> The resulting table produced by this query looks like:
> ||{{_20mph}}||{{_25mph}}||
> |16|21|
> |16|21|
> Every row is identical, where the column value is equal to the initial number that appears in the column name.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)