wojustme commented on a change in pull request #2692:
URL: https://github.com/apache/calcite/pull/2692#discussion_r786442606
##########
File path:
core/src/main/java/org/apache/calcite/sql/fun/SqlLibraryOperators.java
##########
@@ -706,4 +707,17 @@ private SqlLibraryOperators() {
@LibraryOperator(libraries = { POSTGRESQL })
public static final SqlOperator INFIX_CAST =
new SqlCastOperator();
+
+ /** Null-safe "<=>" equal operator used by MySQL, for example
+ * {@code 1<=>NULL}. */
+ @LibraryOperator(libraries = { MYSQL })
+ public static final SqlOperator NULL_SAFE_EQUAL =
Review comment:
@NobiGo
When using SqlStdOperatorTable#IS_NOT_DISTINCT_FROM, '`X` <=> 3' will return
'`X` IS NOT DISTINCT FROM 3'.
I think it destroys the user's original input.
By the way, I didn't know why we need the test of `(a, b) <=> (x, y)` .
Please point me, Thanks.
--
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]
