jayzhan211 closed issue #15686: Allow parsing byte literals as FixedSizeBinary
URL: https://github.com/apache/datafusion/issues/15686
--
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 comm
leoyvens commented on issue #15686:
URL: https://github.com/apache/datafusion/issues/15686#issuecomment-2805353246
Ok I hear you, I'll try to do this without touching the parser and its
configs.
A concern with an LHS coercion is efficient pushdown. `col = x'lit'` can
make use of stat
alamb commented on issue #15686:
URL: https://github.com/apache/datafusion/issues/15686#issuecomment-2802965975
Here is a sql reproducer of what happens today
```sql
> create table t as values (arrow_cast(x'deadbeef', 'FixedSizeBinary(4)'));
0 row(s) fetched.
Elapsed 0.006 sec
leoyvens commented on issue #15686:
URL: https://github.com/apache/datafusion/issues/15686#issuecomment-2799013192
@alamb thank you for looking at this. Avoiding a config flag would be nice.
But I'm skeptical of the proposed coercion.
If we coerce `binary` to `fixed(N)` when encounter
alamb commented on issue #15686:
URL: https://github.com/apache/datafusion/issues/15686#issuecomment-2798808874
> Coercing the LHS to Binary is less performant. Unconditionally parsing
literals as FixedSizeBytes would be a breaking change.
What about coercing the RHS to FixedSizeBinar
leoyvens opened a new issue, #15686:
URL: https://github.com/apache/datafusion/issues/15686
### Is your feature request related to a problem or challenge?
Say you have a column `byte_column` of type `FixedSizeBinary`. Doing `where
byte_column = x'deadbeef'` will fail, because the lite
