[
https://issues.apache.org/jira/browse/ARROW-10329?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Morgan Cassels updated ARROW-10329:
-----------------------------------
Description:
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.
was:
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.
> 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)
