corgy-w opened a new issue, #10137: URL: https://github.com/apache/seatunnel/issues/10137
### 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 We need to optimize and improve the unit tests for the SQL Transform module in Transform-v2. Currently, the test coverage is insufficient and does not fully validate the behavior of each SQL transform function, especially when functions are nested within one another. The goal is to add comprehensive UT coverage for all SQL transform functions, ensuring that: 1. Each function is tested independently with clear input/output validation. 2. Nested function usage is fully covered (e.g., function A calling B, chained SQL transforms, mixed expressions, etc.). 3. Edge cases, invalid inputs, and boundary conditions are included. 4. The test structure is standardized and easy to extend in the future. This enhancement will significantly improve reliability and maintainability when new SQL transform features are added. ### 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]
