[Feature][Transform-v2] Enhance SQL Transform Unit Test Coverage
Search before asking
- [x] I had searched in the feature 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:
- Each function is tested independently with clear input/output validation.
- Nested function usage is fully covered (e.g., function A calling B, chained SQL transforms, mixed expressions, etc.).
- Edge cases, invalid inputs, and boundary conditions are included.
- 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
could you please confirm if this issue requires a single PR that includes both the unit tests for all related content and the fixes for function bugs? For example, fixes for minor issues like typos or the addition of checks for edge cases.
I am willing to submit a PR to try fixing the bugs and add the unit tests