sarahyurick opened a new issue, #5426:
URL: https://github.com/apache/arrow-datafusion/issues/5426
@ayushdg pointed out that when doing
`Column::from_qualified_name("table_pq.a")`, it uses SQLParser's `Tokenizer` to
generate:
```
[
Word(
Word { value: "table_pq", quote_style: None, keyword: NoKeyword }),
Period,
Word(Word { value: "a", quote_style: None, keyword: NoKeyword }
)
]
```
as expected, which can then return a `Column { relation: "table_pq", name:
"a" }`. However, if the column name starts with a number, like
`Column::from_qualified_name("table_pq.1b")`, we get:
```
[
Word(
Word { value: "table_pq", quote_style: None, keyword: NoKeyword }),
Number(".1", false),
Word(Word { value: "b", quote_style: None, keyword: NoKeyword }
)
]
```
and we're not able to return the expected result (it ends up having to
return a `Column { relation: None, name: "table_pq.1b" }` instead of a `Column
{ relation: "table_pq", name: "1b" }`).
I was wondering if it would be better to fix this on the SQLParser side, or
if it would make more sense to add extra logic for `from_qualified_name` on the
DataFusion side instead?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
