seatunnel icon indicating copy to clipboard operation
seatunnel copied to clipboard

[Feature][Transform-v2] Enhance SQL Transform Unit Test Coverage

Open corgy-w opened this issue 4 weeks ago • 2 comments

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:

  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

corgy-w avatar Dec 01 '25 13:12 corgy-w

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.

Image

yzeng1618 avatar Dec 02 '25 07:12 yzeng1618

I am willing to submit a PR to try fixing the bugs and add the unit tests

yzeng1618 avatar Dec 02 '25 07:12 yzeng1618