Hisoka-X opened a new issue, #9538: URL: https://github.com/apache/seatunnel/issues/9538
### Search before asking - [x] I had searched in the [feature](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22Feature%22) and found no similar feature requirement. ### Description Currently, in the SQL parsing stage, Cast will return the type after processing. However, there is no check on the cast from data type. For example, when converting Timestamp to SMALLINT, we need to report an error in the parsing stage, https://github.com/apache/seatunnel/blob/a19720ccf67b2e3ef66a217e841dba12ccadb28e/seatunnel-transforms-v2/src/main/java/org/apache/seatunnel/transform/sql/zeta/ZetaSQLType.java#L331 not in the data processing stage. For specific rules, please refer to processing stage code https://github.com/apache/seatunnel/blob/a19720ccf67b2e3ef66a217e841dba12ccadb28e/seatunnel-transforms-v2/src/main/java/org/apache/seatunnel/transform/sql/zeta/functions/SystemFunction.java#L93 ### Usage Scenario _No response_ ### Related issues _No response_ ### Are you willing to submit a PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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]
