[Feature][SDK] Transform SQL supports "IS [NOT] DISTINCT" parsing - Githubissues

apache / inlong

Apache InLong - a one-stop, full-scenario integration framework for massive data

https://inlong.apache.org/

Apache License 2.0

1.37k stars 534 forks source link

[Feature][SDK] Transform SQL supports "IS [NOT] DISTINCT" parsing #11259

Open Zkplo opened 8 hours ago

Zkplo commented 8 hours ago

Description

parent issue #10796
Postgresql Official Description: https://www.postgresql.org/docs/current/functions-comparison.html

datatype IS DISTINCT FROM datatype: Not equal, treating null as a comparable value.

Use case

1 IS DISTINCT FROM NULL → t (rather than NULL)
NULL IS DISTINCT FROM NULL → f (rather than NULL)

Are you willing to submit PR?

[X] Yes, I am willing to submit a PR!

Code of Conduct

[X] I agree to follow this project's Code of Conduct