You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by jh...@apache.org on 2016/10/12 01:13:02 UTC
svn commit: r1764369 [4/26] - in /calcite/site: apidocs/
apidocs/org/apache/calcite/adapter/enumerable/
apidocs/org/apache/calcite/interpreter/
apidocs/org/apache/calcite/rel/class-use/
apidocs/org/apache/calcite/runtime/ apidocs/org/apache/calcite/run...
Modified: calcite/site/apidocs/org/apache/calcite/runtime/SqlFunctions.html
URL: http://svn.apache.org/viewvc/calcite/site/apidocs/org/apache/calcite/runtime/SqlFunctions.html?rev=1764369&r1=1764368&r2=1764369&view=diff
==============================================================================
--- calcite/site/apidocs/org/apache/calcite/runtime/SqlFunctions.html (original)
+++ calcite/site/apidocs/org/apache/calcite/runtime/SqlFunctions.html Wed Oct 12 01:12:53 2016
@@ -18,7 +18,7 @@
catch(err) {
}
//-->
-var methods = {"i0":9,"i1":9,"i2":9,"i3":9,"i4":9,"i5":9,"i6":9,"i7":9,"i8":9,"i9":9,"i10":9,"i11":9,"i12":9,"i13":9,"i14":9,"i15":9,"i16":9,"i17":9,"i18":9,"i19":9,"i20":9,"i21":9,"i22":9,"i23":9,"i24":9,"i25":9,"i26":9,"i27":9,"i28":9,"i29":9,"i30":9,"i31":9,"i32":9,"i33":9,"i34":9,"i35":9,"i36":9,"i37":9,"i38":9,"i39":9,"i40":9,"i41":9,"i42":9,"i43":9,"i44":9,"i45":9,"i46":9,"i47":9,"i48":9,"i49":9,"i50":9,"i51":9,"i52":9,"i53":9,"i54":9,"i55":9,"i56":9,"i57":9,"i58":9,"i59":9,"i60":9,"i61":9,"i62":9,"i63":9,"i64":9,"i65":9,"i66":9,"i67":9,"i68":9,"i69":9,"i70":9,"i71":9,"i72":9,"i73":9,"i74":9,"i75":9,"i76":9,"i77":9,"i78":9,"i79":9,"i80":9,"i81":9,"i82":9,"i83":9,"i84":9,"i85":9,"i86":9,"i87":9,"i88":9,"i89":9,"i90":9,"i91":9,"i92":9,"i93":9,"i94":9,"i95":9,"i96":9,"i97":9,"i98":9,"i99":9,"i100":9,"i101":9,"i102":9,"i103":9,"i104":9,"i105":9,"i106":9,"i107":9,"i108":9,"i109":9,"i110":9,"i111":9,"i112":9,"i113":9,"i114":9,"i115":9,"i116":9,"i117":9,"i118":9,"i119":9,"i120":9,"i1
21":9,"i122":9,"i123":9,"i124":9,"i125":9,"i126":9,"i127":9,"i128":9,"i129":9,"i130":9,"i131":9,"i132":9,"i133":9,"i134":9,"i135":9,"i136":9,"i137":9,"i138":9,"i139":9,"i140":9,"i141":9,"i142":9,"i143":9,"i144":9,"i145":9,"i146":9,"i147":9,"i148":9,"i149":9,"i150":9,"i151":9,"i152":9,"i153":9,"i154":9,"i155":9,"i156":9,"i157":9,"i158":9,"i159":9,"i160":9,"i161":9,"i162":9,"i163":9,"i164":9,"i165":9,"i166":9,"i167":9,"i168":9,"i169":9,"i170":9,"i171":9,"i172":9,"i173":9,"i174":9,"i175":9,"i176":9,"i177":9,"i178":9,"i179":9,"i180":9,"i181":9,"i182":9,"i183":9,"i184":9,"i185":9,"i186":9,"i187":9,"i188":9,"i189":9,"i190":9,"i191":9,"i192":9,"i193":9,"i194":9,"i195":9,"i196":9,"i197":9,"i198":9,"i199":9,"i200":9,"i201":9,"i202":9,"i203":9,"i204":9,"i205":9,"i206":9,"i207":9,"i208":9,"i209":9,"i210":9,"i211":9,"i212":9,"i213":9,"i214":9,"i215":9,"i216":9,"i217":9,"i218":9};
+var methods = {"i0":9,"i1":9,"i2":9,"i3":9,"i4":9,"i5":9,"i6":9,"i7":9,"i8":9,"i9":9,"i10":9,"i11":9,"i12":9,"i13":9,"i14":9,"i15":9,"i16":9,"i17":9,"i18":9,"i19":9,"i20":9,"i21":9,"i22":9,"i23":9,"i24":9,"i25":9,"i26":9,"i27":9,"i28":9,"i29":9,"i30":9,"i31":9,"i32":9,"i33":9,"i34":9,"i35":9,"i36":9,"i37":9,"i38":9,"i39":9,"i40":9,"i41":9,"i42":9,"i43":9,"i44":9,"i45":9,"i46":9,"i47":9,"i48":9,"i49":9,"i50":9,"i51":9,"i52":9,"i53":9,"i54":9,"i55":9,"i56":9,"i57":9,"i58":9,"i59":9,"i60":9,"i61":9,"i62":9,"i63":9,"i64":9,"i65":9,"i66":9,"i67":9,"i68":9,"i69":9,"i70":9,"i71":9,"i72":9,"i73":9,"i74":9,"i75":9,"i76":9,"i77":9,"i78":9,"i79":9,"i80":9,"i81":9,"i82":9,"i83":9,"i84":9,"i85":9,"i86":9,"i87":9,"i88":9,"i89":9,"i90":9,"i91":9,"i92":9,"i93":9,"i94":9,"i95":9,"i96":9,"i97":9,"i98":9,"i99":9,"i100":9,"i101":9,"i102":9,"i103":9,"i104":9,"i105":9,"i106":9,"i107":9,"i108":9,"i109":9,"i110":9,"i111":9,"i112":9,"i113":9,"i114":9,"i115":9,"i116":9,"i117":9,"i118":9,"i119":9,"i120":9,"i1
21":9,"i122":9,"i123":9,"i124":9,"i125":9,"i126":9,"i127":9,"i128":9,"i129":9,"i130":9,"i131":9,"i132":9,"i133":9,"i134":9,"i135":9,"i136":9,"i137":9,"i138":9,"i139":9,"i140":9,"i141":9,"i142":9,"i143":9,"i144":9,"i145":9,"i146":9,"i147":9,"i148":9,"i149":9,"i150":9,"i151":9,"i152":9,"i153":9,"i154":9,"i155":9,"i156":9,"i157":9,"i158":9,"i159":9,"i160":9,"i161":9,"i162":9,"i163":9,"i164":9,"i165":9,"i166":9,"i167":9,"i168":9,"i169":9,"i170":9,"i171":9,"i172":9,"i173":9,"i174":9,"i175":9,"i176":9,"i177":9,"i178":9,"i179":9,"i180":9,"i181":9,"i182":9,"i183":9,"i184":9,"i185":9,"i186":9,"i187":9,"i188":9,"i189":9,"i190":9,"i191":9,"i192":9,"i193":9,"i194":9,"i195":9,"i196":9,"i197":9,"i198":9,"i199":9,"i200":9,"i201":9,"i202":9,"i203":9,"i204":9,"i205":9,"i206":9,"i207":9,"i208":9,"i209":9,"i210":9,"i211":9,"i212":9,"i213":9,"i214":9,"i215":9,"i216":9,"i217":9,"i218":9,"i219":9,"i220":9,"i221":9};
var tabs = {65535:["t0","All Methods"],1:["t1","Static Methods"],8:["t4","Concrete Methods"]};
var altColor = "altColor";
var rowColor = "rowColor";
@@ -229,124 +229,131 @@ extends <a href="http://docs.oracle.com/
</td>
</tr>
<tr id="i11" class="rowColor">
+<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a></code></td>
+<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#arrayItemOptional-java.util.List-int-">arrayItemOptional</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</a> list,
+ int item)</code>
+<div class="block">As <a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#arrayItem-java.util.List-int-"><code>arrayItem(java.util.List, int)</code></a> method, but allows array to be nullable.</div>
+</td>
+</tr>
+<tr id="i12" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#arrayToList-java.sql.Array-">arrayToList</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/sql/Array.html?is-external=true" title="class or interface in java.sql">Array</a> a)</code>
<div class="block">Converts a JDBC array to a list.</div>
</td>
</tr>
-<tr id="i12" class="altColor">
+<tr id="i13" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ceil-java.math.BigDecimal-">ceil</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0)</code> </td>
</tr>
-<tr id="i13" class="rowColor">
+<tr id="i14" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ceil-java.math.BigDecimal-java.math.BigDecimal-">ceil</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code> </td>
</tr>
-<tr id="i14" class="altColor">
+<tr id="i15" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ceil-java.math.BigDecimal-int-">ceil</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0,
int b1)</code> </td>
</tr>
-<tr id="i15" class="rowColor">
+<tr id="i16" class="altColor">
<td class="colFirst"><code>static byte</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ceil-byte-byte-">ceil</a></span>(byte b0,
byte b1)</code>
<div class="block">SQL <code>CEIL</code> operator applied to byte values.</div>
</td>
</tr>
-<tr id="i16" class="altColor">
+<tr id="i17" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ceil-double-">ceil</a></span>(double b0)</code> </td>
</tr>
-<tr id="i17" class="rowColor">
+<tr id="i18" class="altColor">
<td class="colFirst"><code>static float</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ceil-float-">ceil</a></span>(float b0)</code> </td>
</tr>
-<tr id="i18" class="altColor">
+<tr id="i19" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ceil-int-java.math.BigDecimal-">ceil</a></span>(int b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code> </td>
</tr>
-<tr id="i19" class="rowColor">
+<tr id="i20" class="altColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ceil-int-int-">ceil</a></span>(int b0,
int b1)</code>
<div class="block">SQL <code>CEIL</code> operator applied to int values.</div>
</td>
</tr>
-<tr id="i20" class="altColor">
+<tr id="i21" class="rowColor">
<td class="colFirst"><code>static long</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ceil-long-long-">ceil</a></span>(long b0,
long b1)</code>
<div class="block">SQL <code>CEIL</code> operator applied to long values.</div>
</td>
</tr>
-<tr id="i21" class="rowColor">
+<tr id="i22" class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ceil-short-short-">ceil</a></span>(short b0,
short b1)</code>
<div class="block">SQL <code>CEIL</code> operator applied to short values.</div>
</td>
</tr>
-<tr id="i22" class="altColor">
+<tr id="i23" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#charLength-java.lang.String-">charLength</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> s)</code>
<div class="block">SQL CHARACTER_LENGTH(string) function.</div>
</td>
</tr>
-<tr id="i23" class="rowColor">
+<tr id="i24" class="altColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#compare-boolean-boolean-">compare</a></span>(boolean x,
boolean y)</code>
<div class="block">Boolean comparison.</div>
</td>
</tr>
-<tr id="i24" class="altColor">
+<tr id="i25" class="rowColor">
<td class="colFirst"><code>static org.apache.calcite.avatica.util.ByteString</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#concat-org.apache.calcite.avatica.util.ByteString-org.apache.calcite.avatica.util.ByteString-">concat</a></span>(org.apache.calcite.avatica.util.ByteString s0,
org.apache.calcite.avatica.util.ByteString s1)</code>
<div class="block">SQL <code>binary || binary</code> operator.</div>
</td>
</tr>
-<tr id="i25" class="rowColor">
+<tr id="i26" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#concat-java.lang.String-java.lang.String-">concat</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> s0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> s1)</code>
<div class="block">SQL <code>string || string</code> operator.</div>
</td>
</tr>
-<tr id="i26" class="altColor">
+<tr id="i27" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#currentDate-org.apache.calcite.DataContext-">currentDate</a></span>(<a href="../../../../org/apache/calcite/DataContext.html" title="interface in org.apache.calcite">DataContext</a> root)</code>
<div class="block">SQL <code>CURRENT_DATE</code> function.</div>
</td>
</tr>
-<tr id="i27" class="rowColor">
+<tr id="i28" class="altColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#currentTime-org.apache.calcite.DataContext-">currentTime</a></span>(<a href="../../../../org/apache/calcite/DataContext.html" title="interface in org.apache.calcite">DataContext</a> root)</code>
<div class="block">SQL <code>CURRENT_TIME</code> function.</div>
</td>
</tr>
-<tr id="i28" class="altColor">
+<tr id="i29" class="rowColor">
<td class="colFirst"><code>static long</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#currentTimestamp-org.apache.calcite.DataContext-">currentTimestamp</a></span>(<a href="../../../../org/apache/calcite/DataContext.html" title="interface in org.apache.calcite">DataContext</a> root)</code>
<div class="block">SQL <code>CURRENT_TIMESTAMP</code> function.</div>
</td>
</tr>
-<tr id="i29" class="rowColor">
+<tr id="i30" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#divide-java.math.BigDecimal-java.math.BigDecimal-">divide</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code>
<div class="block">SQL <code>/</code> operator applied to BigDecimal values.</div>
</td>
</tr>
-<tr id="i30" class="altColor">
+<tr id="i31" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#divide-int-java.math.BigDecimal-">divide</a></span>(int b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code> </td>
</tr>
-<tr id="i31" class="rowColor">
+<tr id="i32" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#divide-java.lang.Integer-int-">divide</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b0,
int b1)</code>
@@ -354,28 +361,28 @@ extends <a href="http://docs.oracle.com/
null.</div>
</td>
</tr>
-<tr id="i32" class="altColor">
+<tr id="i33" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#divide-java.lang.Integer-java.lang.Integer-">divide</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b1)</code>
<div class="block">SQL <code>/</code> operator applied to nullable int values.</div>
</td>
</tr>
-<tr id="i33" class="rowColor">
+<tr id="i34" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#divide-java.lang.Integer-java.lang.Long-">divide</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a> b1)</code>
<div class="block">SQL <code>/</code> operator applied to nullable int and long values.</div>
</td>
</tr>
-<tr id="i34" class="altColor">
+<tr id="i35" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#divide-int-int-">divide</a></span>(int b0,
int b1)</code>
<div class="block">SQL <code>/</code> operator applied to int values.</div>
</td>
</tr>
-<tr id="i35" class="rowColor">
+<tr id="i36" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#divide-int-java.lang.Integer-">divide</a></span>(int b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b1)</code>
@@ -383,32 +390,32 @@ extends <a href="http://docs.oracle.com/
null.</div>
</td>
</tr>
-<tr id="i36" class="altColor">
+<tr id="i37" class="rowColor">
<td class="colFirst"><code>static long</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#divide-long-java.math.BigDecimal-">divide</a></span>(long b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code> </td>
</tr>
-<tr id="i37" class="rowColor">
+<tr id="i38" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#divide-java.lang.Long-java.lang.Integer-">divide</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b1)</code>
<div class="block">SQL <code>/</code> operator applied to nullable long and int values.</div>
</td>
</tr>
-<tr id="i38" class="altColor">
+<tr id="i39" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#element-java.util.List-">element</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/util/List.html?is-external=true" title="class or interface in java.util">List</a> list)</code>
<div class="block">Support the ELEMENT function.</div>
</td>
</tr>
-<tr id="i39" class="rowColor">
+<tr id="i40" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#eq-java.math.BigDecimal-java.math.BigDecimal-">eq</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code>
<div class="block">SQL = operator applied to BigDecimal values (neither may be null).</div>
</td>
</tr>
-<tr id="i40" class="altColor">
+<tr id="i41" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#eq-java.lang.Object-java.lang.Object-">eq</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a> b1)</code>
@@ -416,349 +423,356 @@ extends <a href="http://docs.oracle.com/
side may be null).</div>
</td>
</tr>
-<tr id="i41" class="rowColor">
+<tr id="i42" class="altColor">
<td class="colFirst"><code>static double</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#exp-double-">exp</a></span>(double b0)</code>
<div class="block">SQL <code>EXP</code> operator applied to double values.</div>
</td>
</tr>
-<tr id="i42" class="altColor">
+<tr id="i43" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#exp-long-">exp</a></span>(long b0)</code> </td>
</tr>
-<tr id="i43" class="rowColor">
+<tr id="i44" class="altColor">
<td class="colFirst"><code>static <a href="../../../../org/apache/calcite/linq4j/function/Function1.html" title="interface in org.apache.calcite.linq4j.function">Function1</a><<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a>,<a href="../../../../org/apache/calcite/linq4j/Enumerable.html" title="interface in org.apache.calcite.linq4j">Enumerable</a><<a href="../../../../org/apache/calcite/runtime/FlatLists.ComparableList.html" title="interface in org.apache.calcite.runtime">FlatLists.ComparableList</a><<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Comparable.html?is-external=true" title="class or interface in java.lang">Comparable</a>>>></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#flatProduct-int:A-boolean-org.apache.calcite.runtime.SqlFunctions.FlatProductInputType:A-">flatProduct</a></span>(int[] fieldCounts,
boolean withOrdinality,
<a href="../../../../org/apache/calcite/runtime/SqlFunctions.FlatProductInputType.html" title="enum in org.apache.calcite.runtime">SqlFunctions.FlatProductInputType</a>[] inputTypes)</code> </td>
</tr>
-<tr id="i44" class="altColor">
+<tr id="i45" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#floor-java.math.BigDecimal-">floor</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0)</code> </td>
</tr>
-<tr id="i45" class="rowColor">
+<tr id="i46" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#floor-java.math.BigDecimal-java.math.BigDecimal-">floor</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code> </td>
</tr>
-<tr id="i46" class="altColor">
+<tr id="i47" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#floor-java.math.BigDecimal-int-">floor</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0,
int b1)</code> </td>
</tr>
-<tr id="i47" class="rowColor">
+<tr id="i48" class="altColor">
<td class="colFirst"><code>static byte</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#floor-byte-byte-">floor</a></span>(byte b0,
byte b1)</code>
<div class="block">SQL <code>FLOOR</code> operator applied to byte values.</div>
</td>
</tr>
-<tr id="i48" class="altColor">
+<tr id="i49" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#floor-double-">floor</a></span>(double b0)</code> </td>
</tr>
-<tr id="i49" class="rowColor">
+<tr id="i50" class="altColor">
<td class="colFirst"><code>static float</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#floor-float-">floor</a></span>(float b0)</code> </td>
</tr>
-<tr id="i50" class="altColor">
+<tr id="i51" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#floor-int-java.math.BigDecimal-">floor</a></span>(int b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code> </td>
</tr>
-<tr id="i51" class="rowColor">
+<tr id="i52" class="altColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#floor-int-int-">floor</a></span>(int b0,
int b1)</code>
<div class="block">SQL <code>FLOOR</code> operator applied to int values.</div>
</td>
</tr>
-<tr id="i52" class="altColor">
+<tr id="i53" class="rowColor">
<td class="colFirst"><code>static long</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#floor-long-long-">floor</a></span>(long b0,
long b1)</code>
<div class="block">SQL <code>FLOOR</code> operator applied to long values.</div>
</td>
</tr>
-<tr id="i53" class="rowColor">
+<tr id="i54" class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#floor-short-short-">floor</a></span>(short b0,
short b1)</code>
<div class="block">SQL <code>FLOOR</code> operator applied to short values.</div>
</td>
</tr>
-<tr id="i54" class="altColor">
+<tr id="i55" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ge-java.math.BigDecimal-java.math.BigDecimal-">ge</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code>
<div class="block">SQL ≥ operator applied to BigDecimal values.</div>
</td>
</tr>
-<tr id="i55" class="rowColor">
+<tr id="i56" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ge-boolean-boolean-">ge</a></span>(boolean b0,
boolean b1)</code>
<div class="block">SQL ≥ operator applied to boolean values.</div>
</td>
</tr>
-<tr id="i56" class="altColor">
+<tr id="i57" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ge-org.apache.calcite.avatica.util.ByteString-org.apache.calcite.avatica.util.ByteString-">ge</a></span>(org.apache.calcite.avatica.util.ByteString b0,
org.apache.calcite.avatica.util.ByteString b1)</code>
<div class="block">SQL ≥ operator applied to ByteString values.</div>
</td>
</tr>
-<tr id="i57" class="rowColor">
+<tr id="i58" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ge-java.lang.String-java.lang.String-">ge</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> b1)</code>
<div class="block">SQL ≥ operator applied to String values.</div>
</td>
</tr>
-<tr id="i58" class="altColor">
+<tr id="i59" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#greater-boolean-boolean-">greater</a></span>(boolean b0,
boolean b1)</code> </td>
</tr>
-<tr id="i59" class="rowColor">
+<tr id="i60" class="altColor">
<td class="colFirst"><code>static byte</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#greater-byte-byte-">greater</a></span>(byte b0,
byte b1)</code> </td>
</tr>
-<tr id="i60" class="altColor">
+<tr id="i61" class="rowColor">
<td class="colFirst"><code>static char</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#greater-char-char-">greater</a></span>(char b0,
char b1)</code> </td>
</tr>
-<tr id="i61" class="rowColor">
+<tr id="i62" class="altColor">
<td class="colFirst"><code>static double</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#greater-double-double-">greater</a></span>(double b0,
double b1)</code> </td>
</tr>
-<tr id="i62" class="altColor">
+<tr id="i63" class="rowColor">
<td class="colFirst"><code>static float</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#greater-float-float-">greater</a></span>(float b0,
float b1)</code> </td>
</tr>
-<tr id="i63" class="rowColor">
+<tr id="i64" class="altColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#greater-int-int-">greater</a></span>(int b0,
int b1)</code> </td>
</tr>
-<tr id="i64" class="altColor">
+<tr id="i65" class="rowColor">
<td class="colFirst"><code>static long</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#greater-long-long-">greater</a></span>(long b0,
long b1)</code> </td>
</tr>
-<tr id="i65" class="rowColor">
+<tr id="i66" class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#greater-short-short-">greater</a></span>(short b0,
short b1)</code> </td>
</tr>
-<tr id="i66" class="altColor">
+<tr id="i67" class="rowColor">
<td class="colFirst"><code>static <T extends <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Comparable.html?is-external=true" title="class or interface in java.lang">Comparable</a><T>><br>T</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#greater-T-T-">greater</a></span>(T b0,
T b1)</code>
<div class="block">Helper for implementing MAX.</div>
</td>
</tr>
-<tr id="i67" class="rowColor">
+<tr id="i68" class="altColor">
<td class="colFirst"><code>static <T extends <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Comparable.html?is-external=true" title="class or interface in java.lang">Comparable</a><T>><br>T</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#greatest-T-T-">greatest</a></span>(T b0,
T b1)</code>
<div class="block">GREATEST operator.</div>
</td>
</tr>
-<tr id="i68" class="altColor">
+<tr id="i69" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#gt-java.math.BigDecimal-java.math.BigDecimal-">gt</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code>
<div class="block">SQL > operator applied to BigDecimal values.</div>
</td>
</tr>
-<tr id="i69" class="rowColor">
+<tr id="i70" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#gt-boolean-boolean-">gt</a></span>(boolean b0,
boolean b1)</code>
<div class="block">SQL > operator applied to boolean values.</div>
</td>
</tr>
-<tr id="i70" class="altColor">
+<tr id="i71" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#gt-org.apache.calcite.avatica.util.ByteString-org.apache.calcite.avatica.util.ByteString-">gt</a></span>(org.apache.calcite.avatica.util.ByteString b0,
org.apache.calcite.avatica.util.ByteString b1)</code>
<div class="block">SQL > operator applied to ByteString values.</div>
</td>
</tr>
-<tr id="i71" class="rowColor">
+<tr id="i72" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#gt-java.lang.String-java.lang.String-">gt</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> b1)</code>
<div class="block">SQL > operator applied to String values.</div>
</td>
</tr>
-<tr id="i72" class="altColor">
+<tr id="i73" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#initcap-java.lang.String-">initcap</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> s)</code>
<div class="block">SQL INITCAP(string) function.</div>
</td>
</tr>
-<tr id="i73" class="rowColor">
+<tr id="i74" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/sql/Date.html?is-external=true" title="class or interface in java.sql">Date</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#internalToDate-int-">internalToDate</a></span>(int v)</code>
<div class="block">Converts the internal representation of a SQL DATE (int) to the Java
type used for UDF parameters (<a href="http://docs.oracle.com/javase/8/docs/api/java/sql/Date.html?is-external=true" title="class or interface in java.sql"><code>Date</code></a>).</div>
</td>
</tr>
-<tr id="i74" class="altColor">
+<tr id="i75" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/sql/Date.html?is-external=true" title="class or interface in java.sql">Date</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#internalToDate-java.lang.Integer-">internalToDate</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> v)</code>
<div class="block">As <a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#internalToDate-int-"><code>internalToDate(int)</code></a> but allows nulls.</div>
</td>
</tr>
-<tr id="i75" class="rowColor">
+<tr id="i76" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/sql/Time.html?is-external=true" title="class or interface in java.sql">Time</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#internalToTime-int-">internalToTime</a></span>(int v)</code>
<div class="block">Converts the internal representation of a SQL TIME (int) to the Java
type used for UDF parameters (<a href="http://docs.oracle.com/javase/8/docs/api/java/sql/Time.html?is-external=true" title="class or interface in java.sql"><code>Time</code></a>).</div>
</td>
</tr>
-<tr id="i76" class="altColor">
+<tr id="i77" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/sql/Time.html?is-external=true" title="class or interface in java.sql">Time</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#internalToTime-java.lang.Integer-">internalToTime</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> v)</code> </td>
</tr>
-<tr id="i77" class="rowColor">
+<tr id="i78" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/sql/Timestamp.html?is-external=true" title="class or interface in java.sql">Timestamp</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#internalToTimestamp-long-">internalToTimestamp</a></span>(long v)</code>
<div class="block">Converts the internal representation of a SQL TIMESTAMP (long) to the Java
type used for UDF parameters (<a href="http://docs.oracle.com/javase/8/docs/api/java/sql/Timestamp.html?is-external=true" title="class or interface in java.sql"><code>Timestamp</code></a>).</div>
</td>
</tr>
-<tr id="i78" class="altColor">
+<tr id="i79" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/sql/Timestamp.html?is-external=true" title="class or interface in java.sql">Timestamp</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#internalToTimestamp-java.lang.Long-">internalToTimestamp</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a> v)</code> </td>
</tr>
-<tr id="i79" class="rowColor">
+<tr id="i80" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#isFalse-java.lang.Boolean-">isFalse</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html?is-external=true" title="class or interface in java.lang">Boolean</a> b)</code>
<div class="block">NULL → FALSE, FALSE → TRUE, TRUE → FALSE.</div>
</td>
</tr>
-<tr id="i80" class="altColor">
+<tr id="i81" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#isNotFalse-java.lang.Boolean-">isNotFalse</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html?is-external=true" title="class or interface in java.lang">Boolean</a> b)</code>
<div class="block">NULL → TRUE, FALSE → FALSE, TRUE → TRUE.</div>
</td>
</tr>
-<tr id="i81" class="rowColor">
+<tr id="i82" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#isNotTrue-java.lang.Boolean-">isNotTrue</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html?is-external=true" title="class or interface in java.lang">Boolean</a> b)</code>
<div class="block">NULL → TRUE, FALSE → TRUE, TRUE → FALSE.</div>
</td>
</tr>
-<tr id="i82" class="altColor">
+<tr id="i83" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#isTrue-java.lang.Boolean-">isTrue</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html?is-external=true" title="class or interface in java.lang">Boolean</a> b)</code>
<div class="block">NULL → FALSE, FALSE → FALSE, TRUE → TRUE.</div>
</td>
</tr>
-<tr id="i83" class="rowColor">
+<tr id="i84" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#item-java.lang.Object-java.lang.Object-">item</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a> object,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a> index)</code>
<div class="block">Implements the {@code [ ...</div>
</td>
</tr>
-<tr id="i84" class="altColor">
+<tr id="i85" class="rowColor">
+<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a></code></td>
+<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#itemOptional-java.lang.Object-java.lang.Object-">itemOptional</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a> object,
+ <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a> index)</code>
+<div class="block">As <a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#item-java.lang.Object-java.lang.Object-"><code>item(java.lang.Object, java.lang.Object)</code></a> method, but allows object to be nullable.</div>
+</td>
+</tr>
+<tr id="i86" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#le-java.math.BigDecimal-java.math.BigDecimal-">le</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code>
<div class="block">SQL ≤ operator applied to BigDecimal values.</div>
</td>
</tr>
-<tr id="i85" class="rowColor">
+<tr id="i87" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#le-boolean-boolean-">le</a></span>(boolean b0,
boolean b1)</code>
<div class="block">SQL ≤ operator applied to boolean values.</div>
</td>
</tr>
-<tr id="i86" class="altColor">
+<tr id="i88" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#le-org.apache.calcite.avatica.util.ByteString-org.apache.calcite.avatica.util.ByteString-">le</a></span>(org.apache.calcite.avatica.util.ByteString b0,
org.apache.calcite.avatica.util.ByteString b1)</code>
<div class="block">SQL ≤ operator applied to ByteString values.</div>
</td>
</tr>
-<tr id="i87" class="rowColor">
+<tr id="i89" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#le-java.lang.String-java.lang.String-">le</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> b1)</code>
<div class="block">SQL ≤ operator applied to String values.</div>
</td>
</tr>
-<tr id="i88" class="altColor">
+<tr id="i90" class="altColor">
<td class="colFirst"><code>static <T extends <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Comparable.html?is-external=true" title="class or interface in java.lang">Comparable</a><T>><br>T</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#least-T-T-">least</a></span>(T b0,
T b1)</code>
<div class="block">LEAST operator.</div>
</td>
</tr>
-<tr id="i89" class="rowColor">
+<tr id="i91" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#lesser-boolean-boolean-">lesser</a></span>(boolean b0,
boolean b1)</code> </td>
</tr>
-<tr id="i90" class="altColor">
+<tr id="i92" class="altColor">
<td class="colFirst"><code>static byte</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#lesser-byte-byte-">lesser</a></span>(byte b0,
byte b1)</code> </td>
</tr>
-<tr id="i91" class="rowColor">
+<tr id="i93" class="rowColor">
<td class="colFirst"><code>static char</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#lesser-char-char-">lesser</a></span>(char b0,
char b1)</code> </td>
</tr>
-<tr id="i92" class="altColor">
+<tr id="i94" class="altColor">
<td class="colFirst"><code>static double</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#lesser-double-double-">lesser</a></span>(double b0,
double b1)</code> </td>
</tr>
-<tr id="i93" class="rowColor">
+<tr id="i95" class="rowColor">
<td class="colFirst"><code>static float</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#lesser-float-float-">lesser</a></span>(float b0,
float b1)</code> </td>
</tr>
-<tr id="i94" class="altColor">
+<tr id="i96" class="altColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#lesser-int-int-">lesser</a></span>(int b0,
int b1)</code> </td>
</tr>
-<tr id="i95" class="rowColor">
+<tr id="i97" class="rowColor">
<td class="colFirst"><code>static long</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#lesser-long-long-">lesser</a></span>(long b0,
long b1)</code> </td>
</tr>
-<tr id="i96" class="altColor">
+<tr id="i98" class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#lesser-short-short-">lesser</a></span>(short b0,
short b1)</code> </td>
</tr>
-<tr id="i97" class="rowColor">
+<tr id="i99" class="rowColor">
<td class="colFirst"><code>static <T extends <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Comparable.html?is-external=true" title="class or interface in java.lang">Comparable</a><T>><br>T</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#lesser-T-T-">lesser</a></span>(T b0,
T b1)</code>
<div class="block">Helper for implementing MIN.</div>
</td>
</tr>
-<tr id="i98" class="altColor">
+<tr id="i100" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#like-java.lang.String-java.lang.String-">like</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> s,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> pattern)</code>
<div class="block">SQL <code>LIKE</code> function.</div>
</td>
</tr>
-<tr id="i99" class="rowColor">
+<tr id="i101" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#like-java.lang.String-java.lang.String-java.lang.String-">like</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> s,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> pattern,
@@ -766,109 +780,116 @@ extends <a href="http://docs.oracle.com/
<div class="block">SQL <code>LIKE</code> function with escape.</div>
</td>
</tr>
-<tr id="i100" class="altColor">
+<tr id="i102" class="altColor">
<td class="colFirst"><code>static double</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ln-java.math.BigDecimal-">ln</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> d)</code>
<div class="block">SQL <code>LN(number)</code> function applied to BigDecimal values.</div>
</td>
</tr>
-<tr id="i101" class="rowColor">
+<tr id="i103" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ln-double-">ln</a></span>(double d)</code>
<div class="block">SQL <code>LN(number)</code> function applied to double values.</div>
</td>
</tr>
-<tr id="i102" class="altColor">
+<tr id="i104" class="altColor">
<td class="colFirst"><code>static double</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ln-long-">ln</a></span>(long b0)</code>
<div class="block">SQL <code>LN(number)</code> function applied to long values.</div>
</td>
</tr>
-<tr id="i103" class="rowColor">
+<tr id="i105" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#localTime-org.apache.calcite.DataContext-">localTime</a></span>(<a href="../../../../org/apache/calcite/DataContext.html" title="interface in org.apache.calcite">DataContext</a> root)</code>
<div class="block">SQL <code>LOCAL_TIME</code> function.</div>
</td>
</tr>
-<tr id="i104" class="altColor">
+<tr id="i106" class="altColor">
<td class="colFirst"><code>static long</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#localTimestamp-org.apache.calcite.DataContext-">localTimestamp</a></span>(<a href="../../../../org/apache/calcite/DataContext.html" title="interface in org.apache.calcite">DataContext</a> root)</code>
<div class="block">SQL <code>LOCAL_TIMESTAMP</code> function.</div>
</td>
</tr>
-<tr id="i105" class="rowColor">
+<tr id="i107" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#log10-java.math.BigDecimal-">log10</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> d)</code>
<div class="block">SQL <code>LOG10(number)</code> function applied to BigDecimal values.</div>
</td>
</tr>
-<tr id="i106" class="altColor">
+<tr id="i108" class="altColor">
<td class="colFirst"><code>static double</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#log10-double-">log10</a></span>(double b0)</code>
<div class="block">SQL <code>LOG10(numeric)</code> operator applied to double values.</div>
</td>
</tr>
-<tr id="i107" class="rowColor">
+<tr id="i109" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#log10-long-">log10</a></span>(long b0)</code>
<div class="block">SQL <code>LOG10(number)</code> function applied to long values.</div>
</td>
</tr>
-<tr id="i108" class="altColor">
+<tr id="i110" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#lower-java.lang.String-">lower</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> s)</code>
<div class="block">SQL LOWER(string) function.</div>
</td>
</tr>
-<tr id="i109" class="rowColor">
+<tr id="i111" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#lt-java.math.BigDecimal-java.math.BigDecimal-">lt</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code>
<div class="block">SQL < operator applied to BigDecimal values.</div>
</td>
</tr>
-<tr id="i110" class="altColor">
+<tr id="i112" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#lt-boolean-boolean-">lt</a></span>(boolean b0,
boolean b1)</code>
<div class="block">SQL < operator applied to boolean values.</div>
</td>
</tr>
-<tr id="i111" class="rowColor">
+<tr id="i113" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#lt-org.apache.calcite.avatica.util.ByteString-org.apache.calcite.avatica.util.ByteString-">lt</a></span>(org.apache.calcite.avatica.util.ByteString b0,
org.apache.calcite.avatica.util.ByteString b1)</code>
<div class="block">SQL < operator applied to ByteString values.</div>
</td>
</tr>
-<tr id="i112" class="altColor">
+<tr id="i114" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#lt-java.lang.String-java.lang.String-">lt</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> b1)</code>
<div class="block">SQL < operator applied to String values.</div>
</td>
</tr>
-<tr id="i113" class="rowColor">
+<tr id="i115" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ltrim-java.lang.String-">ltrim</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> s)</code>
<div class="block">SQL <code>LTRIM</code> function.</div>
</td>
</tr>
-<tr id="i114" class="altColor">
+<tr id="i116" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#mapItem-java.util.Map-java.lang.Object-">mapItem</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/util/Map.html?is-external=true" title="class or interface in java.util">Map</a> map,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a> item)</code>
<div class="block">Helper for "map element reference".</div>
</td>
</tr>
-<tr id="i115" class="rowColor">
+<tr id="i117" class="rowColor">
+<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a></code></td>
+<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#mapItemOptional-java.util.Map-java.lang.Object-">mapItemOptional</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/util/Map.html?is-external=true" title="class or interface in java.util">Map</a> map,
+ <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a> item)</code>
+<div class="block">As <a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#mapItem-java.util.Map-java.lang.Object-"><code>mapItem(java.util.Map, java.lang.Object)</code></a> method, but allows map to be nullable.</div>
+</td>
+</tr>
+<tr id="i118" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#minus-java.math.BigDecimal-java.math.BigDecimal-">minus</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code>
<div class="block">SQL <code>-</code> operator applied to BigDecimal values.</div>
</td>
</tr>
-<tr id="i116" class="altColor">
+<tr id="i119" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#minus-java.lang.Integer-int-">minus</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b0,
int b1)</code>
@@ -876,28 +897,28 @@ extends <a href="http://docs.oracle.com/
null.</div>
</td>
</tr>
-<tr id="i117" class="rowColor">
+<tr id="i120" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#minus-java.lang.Integer-java.lang.Integer-">minus</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b1)</code>
<div class="block">SQL <code>-</code> operator applied to nullable int values.</div>
</td>
</tr>
-<tr id="i118" class="altColor">
+<tr id="i121" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#minus-java.lang.Integer-java.lang.Long-">minus</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a> b1)</code>
<div class="block">SQL <code>-</code> operator applied to nullable int and long values.</div>
</td>
</tr>
-<tr id="i119" class="rowColor">
+<tr id="i122" class="altColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#minus-int-int-">minus</a></span>(int b0,
int b1)</code>
<div class="block">SQL <code>-</code> operator applied to int values.</div>
</td>
</tr>
-<tr id="i120" class="altColor">
+<tr id="i123" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#minus-int-java.lang.Integer-">minus</a></span>(int b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b1)</code>
@@ -905,64 +926,64 @@ extends <a href="http://docs.oracle.com/
null.</div>
</td>
</tr>
-<tr id="i121" class="rowColor">
+<tr id="i124" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#minus-java.lang.Long-java.lang.Integer-">minus</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b1)</code>
<div class="block">SQL <code>-</code> operator applied to nullable long and int values.</div>
</td>
</tr>
-<tr id="i122" class="altColor">
+<tr id="i125" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#mod-java.math.BigDecimal-java.math.BigDecimal-">mod</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code> </td>
</tr>
-<tr id="i123" class="rowColor">
+<tr id="i126" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#mod-java.math.BigDecimal-int-">mod</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0,
int b1)</code> </td>
</tr>
-<tr id="i124" class="altColor">
+<tr id="i127" class="rowColor">
<td class="colFirst"><code>static byte</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#mod-byte-byte-">mod</a></span>(byte b0,
byte b1)</code>
<div class="block">SQL <code>MOD</code> operator applied to byte values.</div>
</td>
</tr>
-<tr id="i125" class="rowColor">
+<tr id="i128" class="altColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#mod-int-java.math.BigDecimal-">mod</a></span>(int b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code> </td>
</tr>
-<tr id="i126" class="altColor">
+<tr id="i129" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#mod-int-int-">mod</a></span>(int b0,
int b1)</code>
<div class="block">SQL <code>MOD</code> operator applied to int values.</div>
</td>
</tr>
-<tr id="i127" class="rowColor">
+<tr id="i130" class="altColor">
<td class="colFirst"><code>static long</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#mod-long-long-">mod</a></span>(long b0,
long b1)</code>
<div class="block">SQL <code>MOD</code> operator applied to long values.</div>
</td>
</tr>
-<tr id="i128" class="altColor">
+<tr id="i131" class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#mod-short-short-">mod</a></span>(short b0,
short b1)</code>
<div class="block">SQL <code>MOD</code> operator applied to short values.</div>
</td>
</tr>
-<tr id="i129" class="rowColor">
+<tr id="i132" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#multiply-java.math.BigDecimal-java.math.BigDecimal-">multiply</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code>
<div class="block">SQL <code>*</code> operator applied to BigDecimal values.</div>
</td>
</tr>
-<tr id="i130" class="altColor">
+<tr id="i133" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#multiply-java.lang.Integer-int-">multiply</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b0,
int b1)</code>
@@ -970,28 +991,28 @@ extends <a href="http://docs.oracle.com/
null.</div>
</td>
</tr>
-<tr id="i131" class="rowColor">
+<tr id="i134" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#multiply-java.lang.Integer-java.lang.Integer-">multiply</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b1)</code>
<div class="block">SQL <code>*</code> operator applied to nullable int values.</div>
</td>
</tr>
-<tr id="i132" class="altColor">
+<tr id="i135" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#multiply-java.lang.Integer-java.lang.Long-">multiply</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a> b1)</code>
<div class="block">SQL <code>*</code> operator applied to nullable int and long values.</div>
</td>
</tr>
-<tr id="i133" class="rowColor">
+<tr id="i136" class="altColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#multiply-int-int-">multiply</a></span>(int b0,
int b1)</code>
<div class="block">SQL <code>*</code> operator applied to int values.</div>
</td>
</tr>
-<tr id="i134" class="altColor">
+<tr id="i137" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#multiply-int-java.lang.Integer-">multiply</a></span>(int b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b1)</code>
@@ -999,21 +1020,21 @@ extends <a href="http://docs.oracle.com/
null.</div>
</td>
</tr>
-<tr id="i135" class="rowColor">
+<tr id="i138" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#multiply-java.lang.Long-java.lang.Integer-">multiply</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b1)</code>
<div class="block">SQL <code>*</code> operator applied to nullable long and int values.</div>
</td>
</tr>
-<tr id="i136" class="altColor">
+<tr id="i139" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ne-java.math.BigDecimal-java.math.BigDecimal-">ne</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code>
<div class="block">SQL <> operator applied to BigDecimal values.</div>
</td>
</tr>
-<tr id="i137" class="rowColor">
+<tr id="i140" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#ne-java.lang.Object-java.lang.Object-">ne</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a> b1)</code>
@@ -1021,13 +1042,13 @@ extends <a href="http://docs.oracle.com/
neither side may be null).</div>
</td>
</tr>
-<tr id="i138" class="altColor">
+<tr id="i141" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html?is-external=true" title="class or interface in java.lang">Boolean</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#not-java.lang.Boolean-">not</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Boolean.html?is-external=true" title="class or interface in java.lang">Boolean</a> b)</code>
<div class="block">NULL → NULL, FALSE → TRUE, TRUE → FALSE.</div>
</td>
</tr>
-<tr id="i139" class="rowColor">
+<tr id="i142" class="altColor">
<td class="colFirst"><code>static org.apache.calcite.avatica.util.ByteString</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#overlay-org.apache.calcite.avatica.util.ByteString-org.apache.calcite.avatica.util.ByteString-int-">overlay</a></span>(org.apache.calcite.avatica.util.ByteString s,
org.apache.calcite.avatica.util.ByteString r,
@@ -1035,7 +1056,7 @@ extends <a href="http://docs.oracle.com/
<div class="block">SQL <code>OVERLAY</code> function applied to binary strings.</div>
</td>
</tr>
-<tr id="i140" class="altColor">
+<tr id="i143" class="rowColor">
<td class="colFirst"><code>static org.apache.calcite.avatica.util.ByteString</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#overlay-org.apache.calcite.avatica.util.ByteString-org.apache.calcite.avatica.util.ByteString-int-int-">overlay</a></span>(org.apache.calcite.avatica.util.ByteString s,
org.apache.calcite.avatica.util.ByteString r,
@@ -1044,7 +1065,7 @@ extends <a href="http://docs.oracle.com/
<div class="block">SQL <code>OVERLAY</code> function applied to binary strings.</div>
</td>
</tr>
-<tr id="i141" class="rowColor">
+<tr id="i144" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#overlay-java.lang.String-java.lang.String-int-">overlay</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> s,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> r,
@@ -1052,7 +1073,7 @@ extends <a href="http://docs.oracle.com/
<div class="block">SQL <code>OVERLAY</code> function.</div>
</td>
</tr>
-<tr id="i142" class="altColor">
+<tr id="i145" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#overlay-java.lang.String-java.lang.String-int-int-">overlay</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> s,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> r,
@@ -1061,14 +1082,14 @@ extends <a href="http://docs.oracle.com/
<div class="block">SQL <code>OVERLAY</code> function.</div>
</td>
</tr>
-<tr id="i143" class="rowColor">
+<tr id="i146" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#plus-java.math.BigDecimal-java.math.BigDecimal-">plus</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html?is-external=true" title="class or interface in java.math">BigDecimal</a> b1)</code>
<div class="block">SQL <code>+</code> operator applied to BigDecimal values.</div>
</td>
</tr>
-<tr id="i144" class="altColor">
+<tr id="i147" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#plus-java.lang.Integer-int-">plus</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b0,
int b1)</code>
@@ -1076,28 +1097,28 @@ extends <a href="http://docs.oracle.com/
null.</div>
</td>
</tr>
-<tr id="i145" class="rowColor">
+<tr id="i148" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#plus-java.lang.Integer-java.lang.Integer-">plus</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b1)</code>
<div class="block">SQL <code>+</code> operator applied to nullable int values.</div>
</td>
</tr>
-<tr id="i146" class="altColor">
+<tr id="i149" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#plus-java.lang.Integer-java.lang.Long-">plus</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a> b1)</code>
<div class="block">SQL <code>+</code> operator applied to nullable int and long values.</div>
</td>
</tr>
-<tr id="i147" class="rowColor">
+<tr id="i150" class="altColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#plus-int-int-">plus</a></span>(int b0,
int b1)</code>
<div class="block">SQL <code>+</code> operator applied to int values.</div>
</td>
</tr>
-<tr id="i148" class="altColor">
+<tr id="i151" class="rowColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#plus-int-java.lang.Integer-">plus</a></span>(int b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b1)</code>
@@ -1105,45 +1126,45 @@ extends <a href="http://docs.oracle.com/
null.</div>
</td>
</tr>
-<tr id="i149" class="rowColor">
+<tr id="i152" class="altColor">
<td class="colFirst"><code>static <a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a></code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#plus-java.lang.Long-java.lang.Integer-">plus</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Long.html?is-external=true" title="class or interface in java.lang">Long</a> b0,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/Integer.html?is-external=true" title="class or interface in java.lang">Integer</a> b1)</code>
<div class="block">SQL <code>+</code> operator applied to nullable long and int values.</div>
</td>
</tr>
-<tr id="i150" class="altColor">
+<tr id="i153" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#position-org.apache.calcite.avatica.util.ByteString-org.apache.calcite.avatica.util.ByteString-">position</a></span>(org.apache.calcite.avatica.util.ByteString seek,
org.apache.calcite.avatica.util.ByteString s)</code>
<div class="block">SQL <code>POSITION(seek IN string)</code> function.</div>
</td>
</tr>
-<tr id="i151" class="rowColor">
+<tr id="i154" class="altColor">
<td class="colFirst"><code>static int</code></td>
<td class="colLast"><code><span class="memberNameLink"><a href="../../../../org/apache/calcite/runtime/SqlFunctions.html#position-java.lang.String-java.lang.String-">position</a></span>(<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> seek,
<a href="http://docs.oracle.com/javase/8/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> s)</code>
<div class="block">SQL <code>POSITION(seek IN string)</code> function.</div>
</td>
</tr>
-<tr id="i152" class="altColor">
+<tr id="i155" class="rowColor">
<td class="colFirst"><code>static double</code></td>
[... 468 lines stripped ...]