zhilinli123 commented on PR #5014:
URL: https://github.com/apache/seatunnel/pull/5014#issuecomment-1714853843
I don't know what test cases are missing, personal advice,I think more type
tests can be added to make sure it passes，For example, string,int,double,
```
SELECT
column_name,
CASE
WHEN column_name IN (value_1, value_2, ...) THEN result_1
...
ELSE test_in_int,
CASE
WHEN column_name IN ('value_1','value_2', ...) THEN result_1
...
ELSE test_in_string
CASE
WHEN (column_name IN ('value_1','value_2', ...) or
column_name!='value3') THEN result_1
...
ELSE test_in_or_string,
CASE
WHEN column_name IN (value_1, value_2 ) THEN value_2
ELSE test_in_return
END AS output_column
FROM table_name;
```
--
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]
