[Enhancement] support NULL-safe equal(<=>) in mysql

[dataroaring]

Search before asking

• [X] I had searched in the issues and found no similar issues.

Description

NULL-safe equal. This operator performs an equality comparison like the = operator, but returns 1 rather than NULL if both operands are NULL, and 0 rather than NULL if one operand is NULL.

The <=> operator is equivalent to the standard SQL IS NOT DISTINCT FROM operator. https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html#operator_equal-to

Solution

• [ ] follow implementation of = by following a query like select * from table where a = 1
• [ ] add <=> implementation like =

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

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

[tobehardest]

I will do it.

[TangSiyang2001]

I will do it.

Hi, how's it going?

[tobehardest]

I will do it.

Hi, how's it going?

Sorry, I'm preparing for the exam recently and haven't started yet.

[Lournc]

Is this issue finished now?