[ 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)