Repository navigation
MySQL unparser emits SMALLINT and unsigned cast types, which MySQL rejects #26887
Description
Describe the bug
Follow-up to #26882. arrow_dtype_to_ast_dtype hard-codes the cast types for Int16 and the unsigned integers, so MySqlDialect cannot override them:
| Arrow type | Unparsed as |
|---|---|
Int16 |
SMALLINT |
UInt8 |
TINYINT UNSIGNED |
UInt16 |
SMALLINT UNSIGNED |
UInt32 |
INTEGER UNSIGNED |
UInt64 |
BIGINT UNSIGNED |
MySQL's CAST accepts none of these (see the permitted types), so the generated SQL fails with ERROR 1064.
To Reproduce
No response
Expected behavior
No response
Additional context
No response
Willingness to contribute
I plan to contribute a fix for this bug independently
Activity
Mysql unparser cast targets (apache#26888)