| <div class="codehilite"><pre><span></span><code><span class="c1">-- %</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="o">%</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">8</span><span class="p">;</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span><span class="p">(</span><span class="mi">2</span><span class="w"> </span><span class="o">%</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">8</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">2</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="k">MOD</span><span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">8</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span><span class="k">mod</span><span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">8</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">2</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| |
| <span class="c1">-- *</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="mi">2</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> |
| <span class="o">|</span><span class="p">(</span><span class="mi">2</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="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">6</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="c1">-- +</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="p">(</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="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="c1">-- -</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="mi">2</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="p">(</span><span class="mi">2</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="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="c1">-- /</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="mi">3</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="p">(</span><span class="mi">3</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="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">5</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="mi">2</span><span class="n">L</span><span class="w"> </span><span class="o">/</span><span class="w"> </span><span class="mi">2</span><span class="n">L</span><span class="p">;</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="p">(</span><span class="mi">2</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="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="c1">-- abs</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="k">abs</span><span class="p">(</span><span class="o">-</span><span class="mi">1</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="k">abs</span><span class="p">(</span><span class="o">-</span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="k">abs</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="o">-</span><span class="s1">'1-1'</span><span class="w"> </span><span class="k">YEAR</span><span class="w"> </span><span class="k">TO</span><span class="w"> </span><span class="k">MONTH</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">----------------------------------+</span> |
| <span class="o">|</span><span class="k">abs</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'-1-1'</span><span class="w"> </span><span class="k">YEAR</span><span class="w"> </span><span class="k">TO</span><span class="w"> </span><span class="k">MONTH</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'1-1'</span><span class="w"> </span><span class="n">YE</span><span class="p">...</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------------+</span> |
| |
| <span class="c1">-- acos</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">acos</span><span class="p">(</span><span class="mi">1</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="n">ACOS</span><span class="p">(</span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">acos</span><span class="p">(</span><span class="mi">2</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="n">ACOS</span><span class="p">(</span><span class="mi">2</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="n">NaN</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="c1">-- acosh</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">acosh</span><span class="p">(</span><span class="mi">1</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="n">ACOSH</span><span class="p">(</span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">acosh</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="n">ACOSH</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="n">NaN</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| |
| <span class="c1">-- asin</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">asin</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="n">ASIN</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">asin</span><span class="p">(</span><span class="mi">2</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="n">ASIN</span><span class="p">(</span><span class="mi">2</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="n">NaN</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="c1">-- asinh</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">asinh</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="n">ASINH</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| |
| <span class="c1">-- atan</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">atan</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="n">ATAN</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="c1">-- atan2</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">atan2</span><span class="p">(</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span><span class="n">ATAN2</span><span class="p">(</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| |
| <span class="c1">-- atanh</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">atanh</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="n">ATANH</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">atanh</span><span class="p">(</span><span class="mi">2</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="n">ATANH</span><span class="p">(</span><span class="mi">2</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="n">NaN</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| |
| <span class="c1">-- bin</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">bin</span><span class="p">(</span><span class="mi">13</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="n">bin</span><span class="p">(</span><span class="mi">13</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1101</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">bin</span><span class="p">(</span><span class="o">-</span><span class="mi">13</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="n">bin</span><span class="p">(</span><span class="o">-</span><span class="mi">13</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------+</span> |
| <span class="o">|</span><span class="mi">11111111111111111</span><span class="p">...</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">bin</span><span class="p">(</span><span class="mi">13</span><span class="p">.</span><span class="mi">3</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span><span class="n">bin</span><span class="p">(</span><span class="mi">13</span><span class="p">.</span><span class="mi">3</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1101</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| |
| <span class="c1">-- bround</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">bround</span><span class="p">(</span><span class="mi">2</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------------+</span> |
| <span class="o">|</span><span class="n">bround</span><span class="p">(</span><span class="mi">2</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">bround</span><span class="p">(</span><span class="mi">25</span><span class="p">,</span><span class="w"> </span><span class="o">-</span><span class="mi">1</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------------+</span> |
| <span class="o">|</span><span class="n">bround</span><span class="p">(</span><span class="mi">25</span><span class="p">,</span><span class="w"> </span><span class="o">-</span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">20</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------+</span> |
| |
| <span class="c1">-- cbrt</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">cbrt</span><span class="p">(</span><span class="mi">27</span><span class="p">.</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| <span class="o">|</span><span class="n">CBRT</span><span class="p">(</span><span class="mi">27</span><span class="p">.</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| |
| <span class="c1">-- ceil</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">ceil</span><span class="p">(</span><span class="o">-</span><span class="mi">0</span><span class="p">.</span><span class="mi">1</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| <span class="o">|</span><span class="n">CEIL</span><span class="p">(</span><span class="o">-</span><span class="mi">0</span><span class="p">.</span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">ceil</span><span class="p">(</span><span class="mi">5</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="n">CEIL</span><span class="p">(</span><span class="mi">5</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">5</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">ceil</span><span class="p">(</span><span class="mi">3</span><span class="p">.</span><span class="mi">1411</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">---------------+</span> |
| <span class="o">|</span><span class="n">ceil</span><span class="p">(</span><span class="mi">3</span><span class="p">.</span><span class="mi">1411</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="p">.</span><span class="mi">142</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">ceil</span><span class="p">(</span><span class="mi">3</span><span class="p">.</span><span class="mi">1411</span><span class="p">,</span><span class="w"> </span><span class="o">-</span><span class="mi">3</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| <span class="o">|</span><span class="n">ceil</span><span class="p">(</span><span class="mi">3</span><span class="p">.</span><span class="mi">1411</span><span class="p">,</span><span class="w"> </span><span class="o">-</span><span class="mi">3</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1000</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| |
| <span class="c1">-- ceiling</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">ceiling</span><span class="p">(</span><span class="o">-</span><span class="mi">0</span><span class="p">.</span><span class="mi">1</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| <span class="o">|</span><span class="n">ceiling</span><span class="p">(</span><span class="o">-</span><span class="mi">0</span><span class="p">.</span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">ceiling</span><span class="p">(</span><span class="mi">5</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| <span class="o">|</span><span class="n">ceiling</span><span class="p">(</span><span class="mi">5</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">5</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">ceiling</span><span class="p">(</span><span class="mi">3</span><span class="p">.</span><span class="mi">1411</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="n">ceiling</span><span class="p">(</span><span class="mi">3</span><span class="p">.</span><span class="mi">1411</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="p">.</span><span class="mi">142</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">ceiling</span><span class="p">(</span><span class="mi">3</span><span class="p">.</span><span class="mi">1411</span><span class="p">,</span><span class="w"> </span><span class="o">-</span><span class="mi">3</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------------------+</span> |
| <span class="o">|</span><span class="n">ceiling</span><span class="p">(</span><span class="mi">3</span><span class="p">.</span><span class="mi">1411</span><span class="p">,</span><span class="w"> </span><span class="o">-</span><span class="mi">3</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1000</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------+</span> |
| |
| <span class="c1">-- conv</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">conv</span><span class="p">(</span><span class="s1">'100'</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">10</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| <span class="o">|</span><span class="n">conv</span><span class="p">(</span><span class="mi">100</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">10</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">4</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">conv</span><span class="p">(</span><span class="o">-</span><span class="mi">10</span><span class="p">,</span><span class="w"> </span><span class="mi">16</span><span class="p">,</span><span class="w"> </span><span class="o">-</span><span class="mi">10</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="n">conv</span><span class="p">(</span><span class="o">-</span><span class="mi">10</span><span class="p">,</span><span class="w"> </span><span class="mi">16</span><span class="p">,</span><span class="w"> </span><span class="o">-</span><span class="mi">10</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="o">-</span><span class="mi">16</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| |
| <span class="c1">-- cos</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">cos</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| <span class="o">|</span><span class="n">COS</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| |
| <span class="c1">-- cosh</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">cosh</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="n">COSH</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="c1">-- cot</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">cot</span><span class="p">(</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">COT</span><span class="p">(</span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="mi">0</span><span class="p">.</span><span class="mi">6420926159343306</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| |
| <span class="c1">-- csc</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">csc</span><span class="p">(</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">CSC</span><span class="p">(</span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="mi">1</span><span class="p">.</span><span class="mi">1883951057781212</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| |
| <span class="c1">-- degrees</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">degrees</span><span class="p">(</span><span class="mi">3</span><span class="p">.</span><span class="mi">141592653589793</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------------------------+</span> |
| <span class="o">|</span><span class="n">DEGREES</span><span class="p">(</span><span class="mi">3</span><span class="p">.</span><span class="mi">141592653589793</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">180</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------+</span> |
| |
| <span class="c1">-- div</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="mi">3</span><span class="w"> </span><span class="n">div</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="p">(</span><span class="mi">3</span><span class="w"> </span><span class="n">div</span><span class="w"> </span><span class="mi">2</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'1-1'</span><span class="w"> </span><span class="k">YEAR</span><span class="w"> </span><span class="k">TO</span><span class="w"> </span><span class="k">MONTH</span><span class="w"> </span><span class="n">div</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'-1'</span><span class="w"> </span><span class="k">MONTH</span><span class="p">;</span> |
| <span class="o">+</span><span class="c1">------------------------------------------------------+</span> |
| <span class="o">|</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'1-1'</span><span class="w"> </span><span class="k">YEAR</span><span class="w"> </span><span class="k">TO</span><span class="w"> </span><span class="k">MONTH</span><span class="w"> </span><span class="n">div</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'-1'</span><span class="w"> </span><span class="k">MONTH</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------------------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="o">-</span><span class="mi">13</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------------------------------------------+</span> |
| |
| <span class="c1">-- e</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">e</span><span class="p">();</span> |
| <span class="o">+</span><span class="c1">-----------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="n">E</span><span class="p">()</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------+</span> |
| <span class="o">|</span><span class="mi">2</span><span class="p">.</span><span class="mi">718281828459045</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------+</span> |
| |
| <span class="c1">-- exp</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">exp</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| <span class="o">|</span><span class="n">EXP</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| |
| <span class="c1">-- expm1</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">expm1</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="n">EXPM1</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| |
| <span class="c1">-- factorial</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">factorial</span><span class="p">(</span><span class="mi">5</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| <span class="o">|</span><span class="n">factorial</span><span class="p">(</span><span class="mi">5</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">120</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| |
| <span class="c1">-- floor</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">floor</span><span class="p">(</span><span class="o">-</span><span class="mi">0</span><span class="p">.</span><span class="mi">1</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span><span class="n">FLOOR</span><span class="p">(</span><span class="o">-</span><span class="mi">0</span><span class="p">.</span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="o">-</span><span class="mi">1</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">floor</span><span class="p">(</span><span class="mi">5</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="n">FLOOR</span><span class="p">(</span><span class="mi">5</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">5</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">floor</span><span class="p">(</span><span class="mi">3</span><span class="p">.</span><span class="mi">1411</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| <span class="o">|</span><span class="n">floor</span><span class="p">(</span><span class="mi">3</span><span class="p">.</span><span class="mi">1411</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="p">.</span><span class="mi">141</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">floor</span><span class="p">(</span><span class="mi">3</span><span class="p">.</span><span class="mi">1411</span><span class="p">,</span><span class="w"> </span><span class="o">-</span><span class="mi">3</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-----------------+</span> |
| <span class="o">|</span><span class="n">floor</span><span class="p">(</span><span class="mi">3</span><span class="p">.</span><span class="mi">1411</span><span class="p">,</span><span class="w"> </span><span class="o">-</span><span class="mi">3</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------+</span> |
| |
| <span class="c1">-- greatest</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">greatest</span><span class="p">(</span><span class="mi">10</span><span class="p">,</span><span class="w"> </span><span class="mi">9</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------------------------+</span> |
| <span class="o">|</span><span class="n">greatest</span><span class="p">(</span><span class="mi">10</span><span class="p">,</span><span class="w"> </span><span class="mi">9</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">10</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------------+</span> |
| |
| <span class="c1">-- hex</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">hex</span><span class="p">(</span><span class="mi">17</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="n">hex</span><span class="p">(</span><span class="mi">17</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">11</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">hex</span><span class="p">(</span><span class="s1">'Spark SQL'</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="n">hex</span><span class="p">(</span><span class="n">Spark</span><span class="w"> </span><span class="k">SQL</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="mi">537061726</span><span class="n">B2053514C</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| |
| <span class="c1">-- hypot</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">hypot</span><span class="p">(</span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span><span class="n">HYPOT</span><span class="p">(</span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">5</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| |
| <span class="c1">-- least</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">least</span><span class="p">(</span><span class="mi">10</span><span class="p">,</span><span class="w"> </span><span class="mi">9</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">---------------------+</span> |
| <span class="o">|</span><span class="n">least</span><span class="p">(</span><span class="mi">10</span><span class="p">,</span><span class="w"> </span><span class="mi">9</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------------+</span> |
| |
| <span class="c1">-- ln</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">ln</span><span class="p">(</span><span class="mi">1</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-----+</span> |
| <span class="o">|</span><span class="n">ln</span><span class="p">(</span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----+</span> |
| |
| <span class="c1">-- log</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">log</span><span class="p">(</span><span class="mi">10</span><span class="p">,</span><span class="w"> </span><span class="mi">100</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| <span class="o">|</span><span class="n">LOG</span><span class="p">(</span><span class="mi">10</span><span class="p">,</span><span class="w"> </span><span class="mi">100</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| |
| <span class="c1">-- log10</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">log10</span><span class="p">(</span><span class="mi">10</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span><span class="n">LOG10</span><span class="p">(</span><span class="mi">10</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| |
| <span class="c1">-- log1p</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">log1p</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="n">LOG1P</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| |
| <span class="c1">-- log2</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">log2</span><span class="p">(</span><span class="mi">2</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="n">LOG2</span><span class="p">(</span><span class="mi">2</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="c1">-- mod</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="o">%</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">8</span><span class="p">;</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span><span class="p">(</span><span class="mi">2</span><span class="w"> </span><span class="o">%</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">8</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">2</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="k">MOD</span><span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">8</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span><span class="k">mod</span><span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">8</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">2</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| |
| <span class="c1">-- negative</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">negative</span><span class="p">(</span><span class="mi">1</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span><span class="n">negative</span><span class="p">(</span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="o">-</span><span class="mi">1</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| |
| <span class="c1">-- pi</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">pi</span><span class="p">();</span> |
| <span class="o">+</span><span class="c1">-----------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="n">PI</span><span class="p">()</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------+</span> |
| <span class="o">|</span><span class="mi">3</span><span class="p">.</span><span class="mi">141592653589793</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------+</span> |
| |
| <span class="c1">-- pmod</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">pmod</span><span class="p">(</span><span class="mi">10</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span><span class="n">pmod</span><span class="p">(</span><span class="mi">10</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">pmod</span><span class="p">(</span><span class="o">-</span><span class="mi">10</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| <span class="o">|</span><span class="n">pmod</span><span class="p">(</span><span class="o">-</span><span class="mi">10</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------+</span> |
| |
| <span class="c1">-- positive</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">positive</span><span class="p">(</span><span class="mi">1</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-----+</span> |
| <span class="o">|</span><span class="p">(</span><span class="o">+</span><span class="w"> </span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----+</span> |
| |
| <span class="c1">-- pow</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">pow</span><span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span><span class="n">pow</span><span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">8</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------+</span> |
| |
| <span class="c1">-- power</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">power</span><span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span><span class="n">POWER</span><span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">8</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------+</span> |
| |
| <span class="c1">-- radians</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">radians</span><span class="p">(</span><span class="mi">180</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-----------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="n">RADIANS</span><span class="p">(</span><span class="mi">180</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------+</span> |
| <span class="o">|</span><span class="mi">3</span><span class="p">.</span><span class="mi">141592653589793</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------+</span> |
| |
| <span class="c1">-- rand</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">rand</span><span class="p">();</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="n">rand</span><span class="p">()</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="mi">0</span><span class="p">.</span><span class="mi">5605872036554872</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">rand</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="n">rand</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="mi">0</span><span class="p">.</span><span class="mi">7604953758285915</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">rand</span><span class="p">(</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">rand</span><span class="p">(</span><span class="k">NULL</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="mi">0</span><span class="p">.</span><span class="mi">7604953758285915</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| |
| <span class="c1">-- randn</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">randn</span><span class="p">();</span> |
| <span class="o">+</span><span class="c1">-------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="n">randn</span><span class="p">()</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------+</span> |
| <span class="o">|</span><span class="mi">0</span><span class="p">.</span><span class="mi">03375615076825031</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">randn</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="n">randn</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="mi">1</span><span class="p">.</span><span class="mi">6034991609278433</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">randn</span><span class="p">(</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">randn</span><span class="p">(</span><span class="k">NULL</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="mi">1</span><span class="p">.</span><span class="mi">6034991609278433</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| |
| <span class="c1">-- random</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">random</span><span class="p">();</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="n">rand</span><span class="p">()</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="mi">0</span><span class="p">.</span><span class="mi">4295019039654454</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">random</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="n">rand</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="mi">0</span><span class="p">.</span><span class="mi">7604953758285915</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">random</span><span class="p">(</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">rand</span><span class="p">(</span><span class="k">NULL</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="mi">0</span><span class="p">.</span><span class="mi">7604953758285915</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| |
| <span class="c1">-- rint</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">rint</span><span class="p">(</span><span class="mi">12</span><span class="p">.</span><span class="mi">3456</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| <span class="o">|</span><span class="n">rint</span><span class="p">(</span><span class="mi">12</span><span class="p">.</span><span class="mi">3456</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">12</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| |
| <span class="c1">-- round</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">round</span><span class="p">(</span><span class="mi">2</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| <span class="o">|</span><span class="n">round</span><span class="p">(</span><span class="mi">2</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| |
| <span class="c1">-- sec</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">sec</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| <span class="o">|</span><span class="n">SEC</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| |
| <span class="c1">-- sign</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">sign</span><span class="p">(</span><span class="mi">40</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="n">sign</span><span class="p">(</span><span class="mi">40</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">sign</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="o">-</span><span class="s1">'100'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------------------------+</span> |
| <span class="o">|</span><span class="n">sign</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'-100'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="o">-</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------+</span> |
| |
| <span class="c1">-- signum</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">signum</span><span class="p">(</span><span class="mi">40</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| <span class="o">|</span><span class="n">SIGNUM</span><span class="p">(</span><span class="mi">40</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">signum</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="o">-</span><span class="s1">'100'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">----------------------------+</span> |
| <span class="o">|</span><span class="n">SIGNUM</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'-100'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="o">-</span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------+</span> |
| |
| <span class="c1">-- sin</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">sin</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| <span class="o">|</span><span class="n">SIN</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| |
| <span class="c1">-- sinh</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">sinh</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="n">SINH</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="c1">-- sqrt</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">sqrt</span><span class="p">(</span><span class="mi">4</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="n">SQRT</span><span class="p">(</span><span class="mi">4</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="c1">-- tan</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">tan</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| <span class="o">|</span><span class="n">TAN</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| |
| <span class="c1">-- tanh</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">tanh</span><span class="p">(</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="n">TANH</span><span class="p">(</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------+</span> |
| |
| <span class="c1">-- try_add</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_add</span><span class="p">(</span><span class="mi">1</span><span class="p">,</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="n">try_add</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_add</span><span class="p">(</span><span class="mi">2147483647</span><span class="p">,</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="n">try_add</span><span class="p">(</span><span class="mi">2147483647</span><span class="p">,</span><span class="w"> </span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="k">NULL</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_add</span><span class="p">(</span><span class="nb">date</span><span class="s1">'2021-01-01'</span><span class="p">,</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="n">try_add</span><span class="p">(</span><span class="nb">DATE</span><span class="w"> </span><span class="s1">'2021-01-01'</span><span class="p">,</span><span class="w"> </span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">2021</span><span class="o">-</span><span class="mi">01</span><span class="o">-</span><span class="mi">02</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_add</span><span class="p">(</span><span class="nb">date</span><span class="s1">'2021-01-01'</span><span class="p">,</span><span class="w"> </span><span class="nb">interval</span><span class="w"> </span><span class="mi">1</span><span class="w"> </span><span class="k">year</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">---------------------------------------------+</span> |
| <span class="o">|</span><span class="n">try_add</span><span class="p">(</span><span class="nb">DATE</span><span class="w"> </span><span class="s1">'2021-01-01'</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'1'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">2022</span><span class="o">-</span><span class="mi">01</span><span class="o">-</span><span class="mi">01</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------------------------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_add</span><span class="p">(</span><span class="k">timestamp</span><span class="s1">'2021-01-01 00:00:00'</span><span class="p">,</span><span class="w"> </span><span class="nb">interval</span><span class="w"> </span><span class="mi">1</span><span class="w"> </span><span class="k">day</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">----------------------------------------------------------+</span> |
| <span class="o">|</span><span class="n">try_add</span><span class="p">(</span><span class="k">TIMESTAMP</span><span class="w"> </span><span class="s1">'2021-01-01 00:00:00'</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'1'</span><span class="w"> </span><span class="k">DAY</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">2021</span><span class="o">-</span><span class="mi">01</span><span class="o">-</span><span class="mi">02</span><span class="w"> </span><span class="mi">00</span><span class="p">:</span><span class="mi">00</span><span class="p">:</span><span class="mi">00</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------------------------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_add</span><span class="p">(</span><span class="nb">interval</span><span class="w"> </span><span class="mi">1</span><span class="w"> </span><span class="k">year</span><span class="p">,</span><span class="w"> </span><span class="nb">interval</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="k">year</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">---------------------------------------------+</span> |
| <span class="o">|</span><span class="n">try_add</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'1'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'2'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'3'</span><span class="w"> </span><span class="k">YEAR</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------------------------------------+</span> |
| |
| <span class="c1">-- try_divide</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_divide</span><span class="p">(</span><span class="mi">3</span><span class="p">,</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="n">try_divide</span><span class="p">(</span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">5</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_divide</span><span class="p">(</span><span class="mi">2</span><span class="n">L</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="n">L</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| <span class="o">|</span><span class="n">try_divide</span><span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_divide</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| <span class="o">|</span><span class="n">try_divide</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="k">NULL</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_divide</span><span class="p">(</span><span class="nb">interval</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="k">month</span><span class="p">,</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="n">try_divide</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'2'</span><span class="w"> </span><span class="k">MONTH</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'0-1'</span><span class="w"> </span><span class="n">YE</span><span class="p">...</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_divide</span><span class="p">(</span><span class="nb">interval</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="k">month</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">---------------------------------+</span> |
| <span class="o">|</span><span class="n">try_divide</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'2'</span><span class="w"> </span><span class="k">MONTH</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="k">NULL</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------------------------+</span> |
| |
| <span class="c1">-- try_mod</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_mod</span><span class="p">(</span><span class="mi">3</span><span class="p">,</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="n">try_mod</span><span class="p">(</span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_mod</span><span class="p">(</span><span class="mi">2</span><span class="n">L</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="n">L</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| <span class="o">|</span><span class="n">try_mod</span><span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_mod</span><span class="p">(</span><span class="mi">3</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-----------------+</span> |
| <span class="o">|</span><span class="n">try_mod</span><span class="p">(</span><span class="mi">3</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">.</span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="p">.</span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_mod</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| <span class="o">|</span><span class="n">try_mod</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="k">NULL</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------+</span> |
| |
| <span class="c1">-- try_multiply</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_multiply</span><span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="n">try_multiply</span><span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">6</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_multiply</span><span class="p">(</span><span class="o">-</span><span class="mi">2147483648</span><span class="p">,</span><span class="w"> </span><span class="mi">10</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| <span class="o">|</span><span class="n">try_multiply</span><span class="p">(</span><span class="o">-</span><span class="mi">2147483648</span><span class="p">,</span><span class="w"> </span><span class="mi">10</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="k">NULL</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_multiply</span><span class="p">(</span><span class="nb">interval</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="k">year</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">----------------------------------+</span> |
| <span class="o">|</span><span class="n">try_multiply</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'2'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'6-0'</span><span class="w"> </span><span class="n">YE</span><span class="p">...</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------------+</span> |
| |
| <span class="c1">-- try_subtract</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_subtract</span><span class="p">(</span><span class="mi">2</span><span class="p">,</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="n">try_subtract</span><span class="p">(</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_subtract</span><span class="p">(</span><span class="o">-</span><span class="mi">2147483648</span><span class="p">,</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="n">try_subtract</span><span class="p">(</span><span class="o">-</span><span class="mi">2147483648</span><span class="p">,</span><span class="w"> </span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="k">NULL</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_subtract</span><span class="p">(</span><span class="nb">date</span><span class="s1">'2021-01-02'</span><span class="p">,</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="n">try_subtract</span><span class="p">(</span><span class="nb">DATE</span><span class="w"> </span><span class="s1">'2021-01-02'</span><span class="p">,</span><span class="w"> </span><span class="mi">1</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">2021</span><span class="o">-</span><span class="mi">01</span><span class="o">-</span><span class="mi">01</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_subtract</span><span class="p">(</span><span class="nb">date</span><span class="s1">'2021-01-01'</span><span class="p">,</span><span class="w"> </span><span class="nb">interval</span><span class="w"> </span><span class="mi">1</span><span class="w"> </span><span class="k">year</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------------+</span> |
| <span class="o">|</span><span class="n">try_subtract</span><span class="p">(</span><span class="nb">DATE</span><span class="w"> </span><span class="s1">'2021-01-01'</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'1'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">2020</span><span class="o">-</span><span class="mi">01</span><span class="o">-</span><span class="mi">01</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_subtract</span><span class="p">(</span><span class="k">timestamp</span><span class="s1">'2021-01-02 00:00:00'</span><span class="p">,</span><span class="w"> </span><span class="nb">interval</span><span class="w"> </span><span class="mi">1</span><span class="w"> </span><span class="k">day</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">---------------------------------------------------------------+</span> |
| <span class="o">|</span><span class="n">try_subtract</span><span class="p">(</span><span class="k">TIMESTAMP</span><span class="w"> </span><span class="s1">'2021-01-02 00:00:00'</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'1'</span><span class="w"> </span><span class="k">DAY</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------------------------------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">2021</span><span class="o">-</span><span class="mi">01</span><span class="o">-</span><span class="mi">01</span><span class="w"> </span><span class="mi">00</span><span class="p">:</span><span class="mi">00</span><span class="p">:</span><span class="mi">00</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">---------------------------------------------------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">try_subtract</span><span class="p">(</span><span class="nb">interval</span><span class="w"> </span><span class="mi">2</span><span class="w"> </span><span class="k">year</span><span class="p">,</span><span class="w"> </span><span class="nb">interval</span><span class="w"> </span><span class="mi">1</span><span class="w"> </span><span class="k">year</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------------+</span> |
| <span class="o">|</span><span class="n">try_subtract</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'2'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'1'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'1'</span><span class="w"> </span><span class="k">YEAR</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------------+</span> |
| |
| <span class="c1">-- unhex</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">decode</span><span class="p">(</span><span class="n">unhex</span><span class="p">(</span><span class="s1">'537061726B2053514C'</span><span class="p">),</span><span class="w"> </span><span class="s1">'UTF-8'</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">----------------------------------------+</span> |
| <span class="o">|</span><span class="n">decode</span><span class="p">(</span><span class="n">unhex</span><span class="p">(</span><span class="mi">537061726</span><span class="n">B2053514C</span><span class="p">),</span><span class="w"> </span><span class="n">UTF</span><span class="o">-</span><span class="mi">8</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="n">Spark</span><span class="w"> </span><span class="k">SQL</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">----------------------------------------+</span> |
| |
| <span class="c1">-- uniform</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">uniform</span><span class="p">(</span><span class="mi">10</span><span class="p">,</span><span class="w"> </span><span class="mi">20</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">)</span><span class="w"> </span><span class="o">></span><span class="w"> </span><span class="mi">0</span><span class="w"> </span><span class="k">AS</span><span class="w"> </span><span class="k">result</span><span class="p">;</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| <span class="o">|</span><span class="k">result</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="o">|</span> |
| <span class="o">+</span><span class="c1">------+</span> |
| |
| <span class="c1">-- width_bucket</span> |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">width_bucket</span><span class="p">(</span><span class="mi">5</span><span class="p">.</span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">10</span><span class="p">.</span><span class="mi">6</span><span class="p">,</span><span class="w"> </span><span class="mi">5</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------------------------------+</span> |
| <span class="o">|</span><span class="n">width_bucket</span><span class="p">(</span><span class="mi">5</span><span class="p">.</span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">10</span><span class="p">.</span><span class="mi">6</span><span class="p">,</span><span class="w"> </span><span class="mi">5</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">width_bucket</span><span class="p">(</span><span class="o">-</span><span class="mi">2</span><span class="p">.</span><span class="mi">1</span><span class="p">,</span><span class="w"> </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="mi">3</span><span class="p">.</span><span class="mi">4</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-------------------------------+</span> |
| <span class="o">|</span><span class="n">width_bucket</span><span class="p">(</span><span class="o">-</span><span class="mi">2</span><span class="p">.</span><span class="mi">1</span><span class="p">,</span><span class="w"> </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="mi">3</span><span class="p">.</span><span class="mi">4</span><span class="p">,</span><span class="w"> </span><span class="mi">3</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">0</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">width_bucket</span><span class="p">(</span><span class="mi">8</span><span class="p">.</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span class="mi">5</span><span class="p">.</span><span class="mi">7</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">------------------------------+</span> |
| <span class="o">|</span><span class="n">width_bucket</span><span class="p">(</span><span class="mi">8</span><span class="p">.</span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span><span class="p">,</span><span class="w"> </span><span class="mi">5</span><span class="p">.</span><span class="mi">7</span><span class="p">,</span><span class="w"> </span><span class="mi">4</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">5</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">------------------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">width_bucket</span><span class="p">(</span><span class="o">-</span><span class="mi">0</span><span class="p">.</span><span class="mi">9</span><span class="p">,</span><span class="w"> </span><span class="mi">5</span><span class="p">.</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">5</span><span class="p">,</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="n">width_bucket</span><span class="p">(</span><span class="o">-</span><span class="mi">0</span><span class="p">.</span><span class="mi">9</span><span class="p">,</span><span class="w"> </span><span class="mi">5</span><span class="p">.</span><span class="mi">2</span><span class="p">,</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">5</span><span class="p">,</span><span class="w"> </span><span class="mi">2</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-------------------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">width_bucket</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'0'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'0'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'10'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">,</span><span class="w"> </span><span class="mi">10</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------------------------------------+</span> |
| <span class="o">|</span><span class="n">width_bucket</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'0'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'0'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'10'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">,</span><span class="w"> </span><span class="mi">10</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------------------------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">width_bucket</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'1'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'0'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'10'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">,</span><span class="w"> </span><span class="mi">10</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------------------------------------+</span> |
| <span class="o">|</span><span class="n">width_bucket</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'1'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'0'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'10'</span><span class="w"> </span><span class="k">YEAR</span><span class="p">,</span><span class="w"> </span><span class="mi">10</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">--------------------------------------------------------------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">width_bucket</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'0'</span><span class="w"> </span><span class="k">DAY</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'0'</span><span class="w"> </span><span class="k">DAY</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'10'</span><span class="w"> </span><span class="k">DAY</span><span class="p">,</span><span class="w"> </span><span class="mi">10</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-----------------------------------------------------------------------+</span> |
| <span class="o">|</span><span class="n">width_bucket</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'0'</span><span class="w"> </span><span class="k">DAY</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'0'</span><span class="w"> </span><span class="k">DAY</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'10'</span><span class="w"> </span><span class="k">DAY</span><span class="p">,</span><span class="w"> </span><span class="mi">10</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------------------------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">1</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------------------------------------------------+</span> |
| |
| <span class="k">SELECT</span><span class="w"> </span><span class="n">width_bucket</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'1'</span><span class="w"> </span><span class="k">DAY</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'0'</span><span class="w"> </span><span class="k">DAY</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'10'</span><span class="w"> </span><span class="k">DAY</span><span class="p">,</span><span class="w"> </span><span class="mi">10</span><span class="p">);</span> |
| <span class="o">+</span><span class="c1">-----------------------------------------------------------------------+</span> |
| <span class="o">|</span><span class="n">width_bucket</span><span class="p">(</span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'1'</span><span class="w"> </span><span class="k">DAY</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'0'</span><span class="w"> </span><span class="k">DAY</span><span class="p">,</span><span class="w"> </span><span class="nb">INTERVAL</span><span class="w"> </span><span class="s1">'10'</span><span class="w"> </span><span class="k">DAY</span><span class="p">,</span><span class="w"> </span><span class="mi">10</span><span class="p">)</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------------------------------------------------+</span> |
| <span class="o">|</span><span class="w"> </span><span class="mi">2</span><span class="o">|</span> |
| <span class="o">+</span><span class="c1">-----------------------------------------------------------------------+</span> |
| </code></pre></div> |
