peasee opened a new issue, #12915: URL: https://github.com/apache/datafusion/issues/12915
### Describe the bug `CAST(.. AS INTEGER)` is not supported in MySQL, as `INTEGER` is not a valid cast type. ### To Reproduce Create an execution plan using the MySQL Dialect that induces or includes a cast to an integer. Observe the generated SQL failing to run on a MySQL connection source, due to the `CAST(.. AS INTEGER)`. ### Expected behavior The execution plan should generate SQL with types compatible for MySQL, when using the MySQL Dialect. In this case, `CAST(.. AS SIGNED)`. ### Additional context _No response_ -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
