This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 845db03018 Publish built docs triggered by
2aff98e002ce6d48008b8bbe2b38ee644a6d5c20
845db03018 is described below
commit 845db03018678ca46d821cb619b58ee225b5de6d
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Jan 21 16:54:25 2025 +0000
Publish built docs triggered by 2aff98e002ce6d48008b8bbe2b38ee644a6d5c20
---
_sources/user-guide/sql/operators.md.txt | 43 ++++++++++++++
objects.inv | Bin 1736 -> 1751 bytes
searchindex.js | 2 +-
user-guide/sql/operators.html | 94 +++++++++++++++++++++++--------
4 files changed, 114 insertions(+), 25 deletions(-)
diff --git a/_sources/user-guide/sql/operators.md.txt
b/_sources/user-guide/sql/operators.md.txt
index b0263ebe98..51f1a26d0b 100644
--- a/_sources/user-guide/sql/operators.md.txt
+++ b/_sources/user-guide/sql/operators.md.txt
@@ -110,6 +110,7 @@ Modulo (remainder)
- [<= (less than or equal to)](#op_le)
- [> (greater than)](#op_gt)
- [>= (greater than or equal to)](#op_ge)
+- [<=> (three-way comparison, alias for IS NOT DISTINCT FROM)](#op_spaceship)
- [IS DISTINCT FROM](#is-distinct-from)
- [IS NOT DISTINCT FROM](#is-not-distinct-from)
- [~ (regex match)](#op_re_match)
@@ -207,6 +208,48 @@ Greater Than or Equal To
+----------------------+
```
+(op_spaceship)=
+
+### `<=>`
+
+Three-way comparison operator. A NULL-safe operator that returns true if both
operands are equal or both are NULL, false otherwise.
+
+```sql
+> SELECT NULL <=> NULL;
++--------------------------------+
+| NULL IS NOT DISTINCT FROM NULL |
++--------------------------------+
+| true |
++--------------------------------+
+```
+
+```sql
+> SELECT 1 <=> NULL;
++------------------------------------+
+| Int64(1) IS NOT DISTINCT FROM NULL |
++------------------------------------+
+| false |
++------------------------------------+
+```
+
+```sql
+> SELECT 1 <=> 2;
++----------------------------------------+
+| Int64(1) IS NOT DISTINCT FROM Int64(2) |
++----------------------------------------+
+| false |
++----------------------------------------+
+```
+
+```sql
+> SELECT 1 <=> 1;
++----------------------------------------+
+| Int64(1) IS NOT DISTINCT FROM Int64(1) |
++----------------------------------------+
+| true |
++----------------------------------------+
+```
+
### `IS DISTINCT FROM`
Guarantees the result of a comparison is `true` or `false` and not an empty set
diff --git a/objects.inv b/objects.inv
index 05c722ae9d..23c067b1d7 100644
Binary files a/objects.inv and b/objects.inv differ
diff --git a/searchindex.js b/searchindex.js
index 2e3ad5d849..a85f3764bb 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"!=": [[48, "op-neq"]], "!~": [[48,
"op-re-not-match"]], "!~*": [[48, "op-re-not-match-i"]], "!~~": [[48, "id18"]],
"!~~*": [[48, "id19"]], "#": [[48, "op-bit-xor"]], "%": [[48, "op-modulo"]],
"&": [[48, "op-bit-and"]], "(relation, name) tuples in logical fields and
logical columns are unique": [[9,
"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]], "*":
[[48, "op-multiply"]], "+": [[48, "op-plus"]], "-": [[48, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"!=": [[48, "op-neq"]], "!~": [[48,
"op-re-not-match"]], "!~*": [[48, "op-re-not-match-i"]], "!~~": [[48, "id19"]],
"!~~*": [[48, "id20"]], "#": [[48, "op-bit-xor"]], "%": [[48, "op-modulo"]],
"&": [[48, "op-bit-and"]], "(relation, name) tuples in logical fields and
logical columns are unique": [[9,
"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]], "*":
[[48, "op-multiply"]], "+": [[48, "op-plus"]], "-": [[48, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
diff --git a/user-guide/sql/operators.html b/user-guide/sql/operators.html
index 7ec88b3c55..c32f80c03f 100644
--- a/user-guide/sql/operators.html
+++ b/user-guide/sql/operators.html
@@ -614,6 +614,15 @@
</code>
</a>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#op-spaceship">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ <=>
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#is-distinct-from">
<code class="docutils literal notranslate">
@@ -684,7 +693,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id16">
+ <a class="reference internal nav-link" href="#id17">
<code class="docutils literal notranslate">
<span class="pre">
~~
@@ -693,7 +702,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id17">
+ <a class="reference internal nav-link" href="#id18">
<code class="docutils literal notranslate">
<span class="pre">
~~*
@@ -702,7 +711,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id18">
+ <a class="reference internal nav-link" href="#id19">
<code class="docutils literal notranslate">
<span class="pre">
!~~
@@ -711,7 +720,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id19">
+ <a class="reference internal nav-link" href="#id20">
<code class="docutils literal notranslate">
<span class="pre">
!~~*
@@ -959,6 +968,7 @@
<li><p><a class="reference internal" href="#op-le"><= (less than or equal
to)</a></p></li>
<li><p><a class="reference internal" href="#op-gt">> (greater
than)</a></p></li>
<li><p><a class="reference internal" href="#op-ge">>= (greater than or
equal to)</a></p></li>
+<li><p><a class="reference internal" href="#op-spaceship"><=> (three-way
comparison, alias for IS NOT DISTINCT FROM)</a></p></li>
<li><p><a class="reference internal" href="#is-distinct-from">IS DISTINCT
FROM</a></p></li>
<li><p><a class="reference internal" href="#is-not-distinct-from">IS NOT
DISTINCT FROM</a></p></li>
<li><p><a class="reference internal" href="#op-re-match">~ (regex
match)</a></p></li>
@@ -1038,6 +1048,42 @@
</pre></div>
</div>
</section>
+<section id="op-spaceship">
+<span id="id12"></span><h3><code class="docutils literal notranslate"><span
class="pre"><=></span></code><a class="headerlink" href="#op-spaceship"
title="Link to this heading">¶</a></h3>
+<p>Three-way comparison operator. A NULL-safe operator that returns true if
both operands are equal or both are NULL, false otherwise.</p>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="k">NULL</span><span class="w"> </span><span
class="o"><=></span><span class="w"> </span><span
class="k">NULL</span><span class="p">;</span>
+<span class="o">+</span><span
class="c1">--------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="k">NULL</span><span class="w"> </span><span class="k">IS</span><span
class="w"> </span><span class="k">NOT</span><span class="w"> </span><span
class="k">DISTINCT</span><span class="w"> </span><span
class="k">FROM</span><span class="w"> </span><span class="k">NULL</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">--------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="k">true</span><span class="w"> </span><span
class="o">|</span>
+<span class="o">+</span><span
class="c1">--------------------------------+</span>
+</pre></div>
+</div>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="mi">1</span><span class="w"> </span><span
class="o"><=></span><span class="w"> </span><span
class="k">NULL</span><span class="p">;</span>
+<span class="o">+</span><span
class="c1">------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span
class="p">)</span><span class="w"> </span><span class="k">IS</span><span
class="w"> </span><span class="k">NOT</span><span class="w"> </span><span
class="k">DISTINCT</span><span class="w"> </span><span
class="k">FROM</span><span class="w"> </span><span class="k">NULL</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="k">false</span><span class="w">
</span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">------------------------------------+</span>
+</pre></div>
+</div>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="mi">1</span><span class="w"> </span><span
class="o"><=></span><span class="w"> </span><span
class="mi">2</span><span class="p">;</span>
+<span class="o">+</span><span
class="c1">----------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span
class="p">)</span><span class="w"> </span><span class="k">IS</span><span
class="w"> </span><span class="k">NOT</span><span class="w"> </span><span
class="k">DISTINCT</span><span class="w"> </span><span
class="k">FROM</span><span class="w"> </span><span class="n">Int64</span><span
class="p">(</span><span class="mi">2</span><span class="p">)</span><span
class=" [...]
+<span class="o">+</span><span
class="c1">----------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="k">false</span><span class="w">
</span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">----------------------------------------+</span>
+</pre></div>
+</div>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="mi">1</span><span class="w"> </span><span
class="o"><=></span><span class="w"> </span><span
class="mi">1</span><span class="p">;</span>
+<span class="o">+</span><span
class="c1">----------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span
class="p">)</span><span class="w"> </span><span class="k">IS</span><span
class="w"> </span><span class="k">NOT</span><span class="w"> </span><span
class="k">DISTINCT</span><span class="w"> </span><span
class="k">FROM</span><span class="w"> </span><span class="n">Int64</span><span
class="p">(</span><span class="mi">1</span><span class="p">)</span><span
class=" [...]
+<span class="o">+</span><span
class="c1">----------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="k">true</span><span class="w">
</span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">----------------------------------------+</span>
+</pre></div>
+</div>
+</section>
<section id="is-distinct-from">
<h3><code class="docutils literal notranslate"><span class="pre">IS</span>
<span class="pre">DISTINCT</span> <span class="pre">FROM</span></code><a
class="headerlink" href="#is-distinct-from" title="Link to this
heading">¶</a></h3>
<p>Guarantees the result of a comparison is <code class="docutils literal
notranslate"><span class="pre">true</span></code> or <code class="docutils
literal notranslate"><span class="pre">false</span></code> and not an empty
set</p>
@@ -1063,7 +1109,7 @@
</div>
</section>
<section id="op-re-match">
-<span id="id12"></span><h3><code class="docutils literal notranslate"><span
class="pre">~</span></code><a class="headerlink" href="#op-re-match"
title="Link to this heading">¶</a></h3>
+<span id="id13"></span><h3><code class="docutils literal notranslate"><span
class="pre">~</span></code><a class="headerlink" href="#op-re-match"
title="Link to this heading">¶</a></h3>
<p>Regex Match</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="s1">'datafusion'</span><span class="w"> </span><span
class="o">~</span><span class="w"> </span><span
class="s1">'^datafusion(-cli)*'</span><span class="p">;</span>
<span class="o">+</span><span
class="c1">-------------------------------------------------+</span>
@@ -1075,7 +1121,7 @@
</div>
</section>
<section id="op-re-match-i">
-<span id="id13"></span><h3><code class="docutils literal notranslate"><span
class="pre">~*</span></code><a class="headerlink" href="#op-re-match-i"
title="Link to this heading">¶</a></h3>
+<span id="id14"></span><h3><code class="docutils literal notranslate"><span
class="pre">~*</span></code><a class="headerlink" href="#op-re-match-i"
title="Link to this heading">¶</a></h3>
<p>Regex Case-Insensitive Match</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="s1">'datafusion'</span><span class="w"> </span><span
class="o">~*</span><span class="w"> </span><span
class="s1">'^DATAFUSION(-cli)*'</span><span class="p">;</span>
<span class="o">+</span><span
class="c1">--------------------------------------------------+</span>
@@ -1087,7 +1133,7 @@
</div>
</section>
<section id="op-re-not-match">
-<span id="id14"></span><h3><code class="docutils literal notranslate"><span
class="pre">!~</span></code><a class="headerlink" href="#op-re-not-match"
title="Link to this heading">¶</a></h3>
+<span id="id15"></span><h3><code class="docutils literal notranslate"><span
class="pre">!~</span></code><a class="headerlink" href="#op-re-not-match"
title="Link to this heading">¶</a></h3>
<p>Not Regex Match</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="s1">'datafusion'</span><span class="w"> </span><span
class="o">!~</span><span class="w"> </span><span
class="s1">'^DATAFUSION(-cli)*'</span><span class="p">;</span>
<span class="o">+</span><span
class="c1">--------------------------------------------------+</span>
@@ -1099,7 +1145,7 @@
</div>
</section>
<section id="op-re-not-match-i">
-<span id="id15"></span><h3><code class="docutils literal notranslate"><span
class="pre">!~*</span></code><a class="headerlink" href="#op-re-not-match-i"
title="Link to this heading">¶</a></h3>
+<span id="id16"></span><h3><code class="docutils literal notranslate"><span
class="pre">!~*</span></code><a class="headerlink" href="#op-re-not-match-i"
title="Link to this heading">¶</a></h3>
<p>Not Regex Case-Insensitive Match</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="s1">'datafusion'</span><span class="w"> </span><span
class="o">!~*</span><span class="w"> </span><span
class="s1">'^DATAFUSION(-cli)+'</span><span class="p">;</span>
<span class="o">+</span><span
class="c1">---------------------------------------------------+</span>
@@ -1110,8 +1156,8 @@
</pre></div>
</div>
</section>
-<section id="id16">
-<h3><code class="docutils literal notranslate"><span
class="pre">~~</span></code><a class="headerlink" href="#id16" title="Link to
this heading">¶</a></h3>
+<section id="id17">
+<h3><code class="docutils literal notranslate"><span
class="pre">~~</span></code><a class="headerlink" href="#id17" title="Link to
this heading">¶</a></h3>
<p>Like Match</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span><span
class="w"> </span><span class="s1">'datafusion'</span><span class="w">
</span><span class="o">~~</span><span class="w"> </span><span
class="s1">'dat_f%n'</span><span class="p">;</span>
<span class="o">+</span><span
class="c1">---------------------------------------+</span>
@@ -1122,8 +1168,8 @@
</pre></div>
</div>
</section>
-<section id="id17">
-<h3><code class="docutils literal notranslate"><span
class="pre">~~*</span></code><a class="headerlink" href="#id17" title="Link to
this heading">¶</a></h3>
+<section id="id18">
+<h3><code class="docutils literal notranslate"><span
class="pre">~~*</span></code><a class="headerlink" href="#id18" title="Link to
this heading">¶</a></h3>
<p>Case-Insensitive Like Match</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span><span
class="w"> </span><span class="s1">'datafusion'</span><span class="w">
</span><span class="o">~~*</span><span class="w"> </span><span
class="s1">'Dat_F%n'</span><span class="p">;</span>
<span class="o">+</span><span
class="c1">----------------------------------------+</span>
@@ -1134,8 +1180,8 @@
</pre></div>
</div>
</section>
-<section id="id18">
-<h3><code class="docutils literal notranslate"><span
class="pre">!~~</span></code><a class="headerlink" href="#id18" title="Link to
this heading">¶</a></h3>
+<section id="id19">
+<h3><code class="docutils literal notranslate"><span
class="pre">!~~</span></code><a class="headerlink" href="#id19" title="Link to
this heading">¶</a></h3>
<p>Not Like Match</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span><span
class="w"> </span><span class="s1">'datafusion'</span><span class="w">
</span><span class="o">!~~</span><span class="w"> </span><span
class="s1">'Dat_F%n'</span><span class="p">;</span>
<span class="o">+</span><span
class="c1">----------------------------------------+</span>
@@ -1146,8 +1192,8 @@
</pre></div>
</div>
</section>
-<section id="id19">
-<h3><code class="docutils literal notranslate"><span
class="pre">!~~*</span></code><a class="headerlink" href="#id19" title="Link to
this heading">¶</a></h3>
+<section id="id20">
+<h3><code class="docutils literal notranslate"><span
class="pre">!~~*</span></code><a class="headerlink" href="#id20" title="Link to
this heading">¶</a></h3>
<p>Not Case-Insensitive Like Match</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span><span
class="w"> </span><span class="s1">'datafusion'</span><span class="w">
</span><span class="o">!~~*</span><span class="w"> </span><span
class="s1">'Dat%F_n'</span><span class="p">;</span>
<span class="o">+</span><span
class="c1">-----------------------------------------+</span>
@@ -1200,7 +1246,7 @@
<li><p><a class="reference internal" href="#op-shift-l"><< (bitwise
shift left)</a></p></li>
</ul>
<section id="op-bit-and">
-<span id="id20"></span><h3><code class="docutils literal notranslate"><span
class="pre">&</span></code><a class="headerlink" href="#op-bit-and"
title="Link to this heading">¶</a></h3>
+<span id="id21"></span><h3><code class="docutils literal notranslate"><span
class="pre">&</span></code><a class="headerlink" href="#op-bit-and"
title="Link to this heading">¶</a></h3>
<p>Bitwise And</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="mi">5</span><span class="w"> </span><span class="o">&</span><span
class="w"> </span><span class="mi">3</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------+</span>
@@ -1212,7 +1258,7 @@
</div>
</section>
<section id="op-bit-or">
-<span id="id21"></span><h3><code class="docutils literal notranslate"><span
class="pre">|</span></code><a class="headerlink" href="#op-bit-or" title="Link
to this heading">¶</a></h3>
+<span id="id22"></span><h3><code class="docutils literal notranslate"><span
class="pre">|</span></code><a class="headerlink" href="#op-bit-or" title="Link
to this heading">¶</a></h3>
<p>Bitwise Or</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="mi">5</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">3</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------+</span>
@@ -1224,7 +1270,7 @@
</div>
</section>
<section id="op-bit-xor">
-<span id="id22"></span><h3><code class="docutils literal notranslate"><span
class="pre">#</span></code><a class="headerlink" href="#op-bit-xor" title="Link
to this heading">¶</a></h3>
+<span id="id23"></span><h3><code class="docutils literal notranslate"><span
class="pre">#</span></code><a class="headerlink" href="#op-bit-xor" title="Link
to this heading">¶</a></h3>
<p>Bitwise Xor (interchangeable with <code class="docutils literal
notranslate"><span class="pre">^</span></code>)</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="mi">5</span><span class="w"> </span><span class="o">#</span><span
class="w"> </span><span class="mi">3</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------+</span>
@@ -1236,7 +1282,7 @@
</div>
</section>
<section id="op-shift-r">
-<span id="id23"></span><h3><code class="docutils literal notranslate"><span
class="pre">>></span></code><a class="headerlink" href="#op-shift-r"
title="Link to this heading">¶</a></h3>
+<span id="id24"></span><h3><code class="docutils literal notranslate"><span
class="pre">>></span></code><a class="headerlink" href="#op-shift-r"
title="Link to this heading">¶</a></h3>
<p>Bitwise Shift Right</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="mi">5</span><span class="w"> </span><span class="o">>></span><span
class="w"> </span><span class="mi">3</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------+</span>
@@ -1248,7 +1294,7 @@
</div>
</section>
<section id="op-shift-l">
-<span id="id24"></span><h3><code class="docutils literal notranslate"><span
class="pre"><<</span></code><a class="headerlink" href="#op-shift-l"
title="Link to this heading">¶</a></h3>
+<span id="id25"></span><h3><code class="docutils literal notranslate"><span
class="pre"><<</span></code><a class="headerlink" href="#op-shift-l"
title="Link to this heading">¶</a></h3>
<p>Bitwise Shift Left</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="mi">5</span><span class="w"> </span><span class="o"><<</span><span
class="w"> </span><span class="mi">3</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------+</span>
@@ -1268,7 +1314,7 @@
<li><p><a class="reference internal" href="#op-arr-contained-by"><@
(array is contained by)</a></p></li>
</ul>
<section id="op-str-cat">
-<span id="id25"></span><h3><code class="docutils literal notranslate"><span
class="pre">||</span></code><a class="headerlink" href="#op-str-cat"
title="Link to this heading">¶</a></h3>
+<span id="id26"></span><h3><code class="docutils literal notranslate"><span
class="pre">||</span></code><a class="headerlink" href="#op-str-cat"
title="Link to this heading">¶</a></h3>
<p>String Concatenation</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="s1">'Hello, '</span><span class="w"> </span><span
class="o">||</span><span class="w"> </span><span
class="s1">'DataFusion!'</span><span class="p">;</span>
<span class="o">+</span><span
class="c1">----------------------------------------+</span>
@@ -1280,7 +1326,7 @@
</div>
</section>
<section id="op-arr-contains">
-<span id="id26"></span><h3><code class="docutils literal notranslate"><span
class="pre">@></span></code><a class="headerlink"
href="#op-arr-contains" title="Link to this heading">¶</a></h3>
+<span id="id27"></span><h3><code class="docutils literal notranslate"><span
class="pre">@></span></code><a class="headerlink"
href="#op-arr-contains" title="Link to this heading">¶</a></h3>
<p>Array Contains</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">make_array</span><span class="p">(</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">)</span><span
class="w"> </span><span class="o">@></span><span class="w"> </span><span
class="n">make_array</ [...]
<span class="o">+</span><span
class="c1">-------------------------------------------------------------------------+</span>
@@ -1292,7 +1338,7 @@
</div>
</section>
<section id="op-arr-contained-by">
-<span id="id27"></span><h3><code class="docutils literal notranslate"><span
class="pre"><@</span></code><a class="headerlink"
href="#op-arr-contained-by" title="Link to this heading">¶</a></h3>
+<span id="id28"></span><h3><code class="docutils literal notranslate"><span
class="pre"><@</span></code><a class="headerlink"
href="#op-arr-contained-by" title="Link to this heading">¶</a></h3>
<p>Array Is Contained By</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">make_array</span><span class="p">(</span><span
class="mi">1</span><span class="p">,</span><span class="mi">3</span><span
class="p">)</span><span class="w"> </span><span class="o"><@</span><span
class="w"> </span><span class="n">make_array</span><span
class="p">(</span><span class="mi">1</ [...]
<span class="o">+</span><span
class="c1">-------------------------------------------------------------------------+</span>
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@datafusion.apache.org
For additional commands, e-mail: commits-h...@datafusion.apache.org
