You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by xi...@apache.org on 2022/02/10 01:15:27 UTC
[calcite] branch site updated: [CALCITE-4980] Babel parser support MySQL NULL-safe equal operator '<=>'
This is an automated email from the ASF dual-hosted git repository.
xiong pushed a commit to branch site
in repository https://gitbox.apache.org/repos/asf/calcite.git
The following commit(s) were added to refs/heads/site by this push:
new aa9dfc7 [CALCITE-4980] Babel parser support MySQL NULL-safe equal operator '<=>'
aa9dfc7 is described below
commit aa9dfc7dbc64c784040cf20ed168016ae3b9c2c5
Author: NobiGo <no...@gmail.com>
AuthorDate: Thu Feb 10 08:52:25 2022 +0800
[CALCITE-4980] Babel parser support MySQL NULL-safe equal operator '<=>'
---
site/_docs/reference.md | 7 +++++--
1 file changed, 5 insertions(+), 2 deletions(-)
diff --git a/site/_docs/reference.md b/site/_docs/reference.md
index 6a2a5d1..6ac180b 100644
--- a/site/_docs/reference.md
+++ b/site/_docs/reference.md
@@ -1203,13 +1203,13 @@ The operator precedence and associativity, highest to lowest.
| * / % || | left
| + - | left
| BETWEEN, IN, LIKE, SIMILAR, OVERLAPS, CONTAINS etc. | -
-| < > = <= >= <> != | left
+| < > = <= >= <> != <=> | left
| IS NULL, IS FALSE, IS NOT TRUE etc. | -
| NOT | right
| AND | left
| OR | left
-Note that `::` is dialect-specific, but is shown in this table for
+Note that `::`,`<=>` is dialect-specific, but is shown in this table for
completeness.
### Comparison operators
@@ -1223,6 +1223,7 @@ completeness.
| value1 >= value2 | Greater than or equal
| value1 < value2 | Less than
| value1 <= value2 | Less than or equal
+| value1 <=> value2 | Whether two values are equal, treating null values as the same
| value IS NULL | Whether *value* is null
| value IS NOT NULL | Whether *value* is not null
| value1 IS DISTINCT FROM value2 | Whether two values are not equal, treating null values as the same
@@ -1251,6 +1252,7 @@ comp:
| >=
| <
| <=
+ | <=>
{% endhighlight %}
### Logical operators
@@ -2513,6 +2515,7 @@ semantics.
| C | Operator syntax | Description
|:- |:-----------------------------------------------|:-----------
| p | expr :: type | Casts *expr* to *type*
+| m | expr1 <=> expr2 | Whether two values are equal, treating null values as the same, and it's similar to `IS NOT DISTINCT FROM`
| b | ARRAY_CONCAT(array [, array ]*) | Concatenates one or more arrays. If any input argument is `NULL` the function returns `NULL`
| b | ARRAY_LENGTH(array) | Synonym for `CARDINALITY`
| b | ARRAY_REVERSE(array) | Reverses elements of *array*