blob: 4498e0c9477cabacd72d2ab2ff2fe41181d9c34e [file] [log] [blame]
<!DOCTYPE HTML>
<!-- NewPage -->
<html lang="en">
<head>
<!-- Generated by javadoc -->
<title>SqlFunctions (Apache Calcite API)</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">
<link rel="stylesheet" type="text/css" href="../../../../jquery/jquery-ui.css" title="Style">
<script type="text/javascript" src="../../../../script.js"></script>
<script type="text/javascript" src="../../../../jquery/jszip/dist/jszip.min.js"></script>
<script type="text/javascript" src="../../../../jquery/jszip-utils/dist/jszip-utils.min.js"></script>
<!--[if IE]>
<script type="text/javascript" src="../../../../jquery/jszip-utils/dist/jszip-utils-ie.min.js"></script>
<![endif]-->
<script type="text/javascript" src="../../../../jquery/jquery-3.3.1.js"></script>
<script type="text/javascript" src="../../../../jquery/jquery-migrate-3.0.1.js"></script>
<script type="text/javascript" src="../../../../jquery/jquery-ui.js"></script>
</head>
<body>
<script type="text/javascript"><!--
try {
if (location.href.indexOf('is-external=true') == -1) {
parent.document.title="SqlFunctions (Apache Calcite API)";
}
}
catch(err) {
}
//-->
var data = {"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,"i121":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,"i222":9,"i223":9,"i224":9,"i225":9,"i226":9,"i227":9,"i228":9,"i229":9,"i230":9,"i231":9,"i232":9,"i233":9,"i234":9,"i235":9,"i236":9,"i237":9,"i238":9,"i239":9,"i240":9,"i241":9,"i242":9,"i243":9,"i244":9,"i245":9,"i246":9,"i247":9,"i248":9,"i249":9,"i250":9,"i251":9,"i252":9,"i253":9,"i254":9,"i255":9,"i256":9,"i257":9,"i258":9,"i259":9,"i260":9,"i261":9,"i262":9,"i263":9,"i264":9,"i265":9,"i266":9,"i267":9,"i268":9,"i269":9,"i270":9,"i271":9,"i272":9,"i273":9,"i274":9,"i275":9,"i276":9,"i277":9,"i278":9,"i279":9,"i280":9,"i281":9,"i282":9,"i283":9,"i284":9,"i285":9,"i286":9,"i287":9,"i288":9,"i289":9,"i290":9,"i291":9,"i292":9,"i293":9,"i294":9,"i295":9,"i296":9,"i297":9,"i298":9,"i299":9,"i300":9,"i301":9,"i302":9,"i303":9,"i304":9,"i305":9,"i306":9,"i307":9,"i308":9,"i309":9,"i310":9,"i311":9,"i312":9,"i313":9,"i314":9,"i315":9,"i316":9,"i317":9,"i318":9,"i319":9,"i320":9,"i321":9,"i322":9,"i323":9,"i324":9,"i325":9,"i326":9,"i327":9,"i328":9,"i329":9,"i330":9,"i331":9,"i332":9,"i333":9,"i334":9,"i335":9,"i336":9,"i337":9,"i338":9,"i339":9,"i340":9,"i341":9,"i342":9,"i343":9,"i344":9,"i345":9,"i346":9,"i347":9,"i348":9};
var tabs = {65535:["t0","All Methods"],1:["t1","Static Methods"],8:["t4","Concrete Methods"]};
var altColor = "altColor";
var rowColor = "rowColor";
var tableTab = "tableTab";
var activeTableTab = "activeTableTab";
var pathtoroot = "../../../../";
var useModuleDirectories = true;
loadScripts(document, 'script');</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
<header role="banner">
<nav role="navigation">
<div class="fixedNav">
<!-- ========= START OF TOP NAVBAR ======= -->
<div class="topNav"><a id="navbar.top">
<!-- -->
</a>
<div class="skipNav"><a href="#skip.navbar.top" title="Skip navigation links">Skip navigation links</a></div>
<a id="navbar.top.firstrow">
<!-- -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../index.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/SqlFunctions.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../index-all.html">Index</a></li>
<li><a href="../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList" id="allclasses_navbar_top">
<li><a href="../../../../allclasses.html">All&nbsp;Classes</a></li>
</ul>
<ul class="navListSearch">
<li><label for="search">SEARCH:</label>
<input type="text" id="search" value="search" disabled="disabled">
<input type="reset" id="reset" value="reset" disabled="disabled">
</li>
</ul>
<div>
<script type="text/javascript"><!--
allClassesLink = document.getElementById("allclasses_navbar_top");
if(window==top) {
allClassesLink.style.display = "block";
}
else {
allClassesLink.style.display = "none";
}
//-->
</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
</div>
<div>
<ul class="subNavList">
<li>Summary:&nbsp;</li>
<li><a href="#nested.class.summary">Nested</a>&nbsp;|&nbsp;</li>
<li><a href="#field.summary">Field</a>&nbsp;|&nbsp;</li>
<li><a href="#constructor.summary">Constr</a>&nbsp;|&nbsp;</li>
<li><a href="#method.summary">Method</a></li>
</ul>
<ul class="subNavList">
<li>Detail:&nbsp;</li>
<li><a href="#field.detail">Field</a>&nbsp;|&nbsp;</li>
<li><a href="#constructor.detail">Constr</a>&nbsp;|&nbsp;</li>
<li><a href="#method.detail">Method</a></li>
</ul>
</div>
<a id="skip.navbar.top">
<!-- -->
</a></div>
<!-- ========= END OF TOP NAVBAR ========= -->
</div>
<div class="navPadding">&nbsp;</div>
<script type="text/javascript"><!--
$('.navPadding').css('padding-top', $('.fixedNav').css("height"));
//-->
</script>
</nav>
</header>
<!-- ======== START OF CLASS DATA ======== -->
<main role="main">
<div class="header">
<div class="subTitle"><span class="packageLabelInType">Package</span>&nbsp;<a href="package-summary.html">org.apache.calcite.runtime</a></div>
<h2 title="Class SqlFunctions" class="title">Class SqlFunctions</h2>
</div>
<div class="contentContainer">
<ul class="inheritance">
<li>java.lang.Object</li>
<li>
<ul class="inheritance">
<li>org.apache.calcite.runtime.SqlFunctions</li>
</ul>
</li>
</ul>
<div class="description">
<ul class="blockList">
<li class="blockList">
<hr>
<pre>public class <span class="typeNameLabel">SqlFunctions</span>
extends java.lang.Object</pre>
<div class="block">Helper methods to implement SQL functions in generated code.
<p>Not present: and, or, not (builtin operators are better, because they
use lazy evaluation. Implementations do not check for null values; the
calling code must do that.</p>
<p>Many of the functions do not check for null values. This is intentional.
If null arguments are possible, the code-generation framework checks for
nulls before calling the functions.</p></div>
</li>
</ul>
</div>
<div class="summary">
<ul class="blockList">
<li class="blockList">
<!-- ======== NESTED CLASS SUMMARY ======== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="nested.class.summary">
<!-- -->
</a>
<h3>Nested Class Summary</h3>
<table class="memberSummary">
<caption><span>Nested Classes</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colSecond" scope="col">Class</th>
<th class="colLast" scope="col">Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static class&nbsp;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="SqlFunctions.FlatProductInputType.html" title="enum in org.apache.calcite.runtime">SqlFunctions.FlatProductInputType</a></span></code></th>
<td class="colLast">
<div class="block">Type of argument passed into <a href="#flatProduct(int%5B%5D,boolean,org.apache.calcite.runtime.SqlFunctions.FlatProductInputType%5B%5D)"><code>flatProduct(int[], boolean, org.apache.calcite.runtime.SqlFunctions.FlatProductInputType[])</code></a>.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>private static class&nbsp;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="SqlFunctions.ProductComparableListEnumerator.html" title="class in org.apache.calcite.runtime">SqlFunctions.ProductComparableListEnumerator</a>&lt;<a href="SqlFunctions.ProductComparableListEnumerator.html" title="type parameter in SqlFunctions.ProductComparableListEnumerator">E</a> extends java.lang.Comparable&gt;</span></code></th>
<td class="colLast">
<div class="block">Enumerates over the cartesian product of the given lists, returning
a comparable list for each row.</div>
</td>
</tr>
</table>
</li>
</ul>
</section>
<!-- =========== FIELD SUMMARY =========== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="field.summary">
<!-- -->
</a>
<h3>Field Summary</h3>
<table class="memberSummary">
<caption><span>Fields</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colSecond" scope="col">Field</th>
<th class="colLast" scope="col">Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>private static <a href="../linq4j/function/Function1.html" title="interface in org.apache.calcite.linq4j.function">Function1</a>&lt;java.lang.Object[],&#8203;<a href="../linq4j/Enumerable.html" title="interface in org.apache.calcite.linq4j">Enumerable</a>&lt;java.lang.Object[]&gt;&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ARRAY_CARTESIAN_PRODUCT">ARRAY_CARTESIAN_PRODUCT</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>private static java.text.DecimalFormat</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DOUBLE_FORMAT">DOUBLE_FORMAT</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>private static java.util.regex.Pattern</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#FROM_BASE64_REGEXP">FROM_BASE64_REGEXP</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>private static <a href="../linq4j/function/Function1.html" title="interface in org.apache.calcite.linq4j.function">Function1</a>&lt;java.util.List&lt;java.lang.Object&gt;,&#8203;<a href="../linq4j/Enumerable.html" title="interface in org.apache.calcite.linq4j">Enumerable</a>&lt;java.lang.Object&gt;&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LIST_AS_ENUMERABLE">LIST_AS_ENUMERABLE</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>private static java.util.TimeZone</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LOCAL_TZ">LOCAL_TZ</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>private static java.lang.String[]</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#POSIX_CHARACTER_CLASSES">POSIX_CHARACTER_CLASSES</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>private static java.time.format.DateTimeFormatter</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ROOT_DAY_FORMAT">ROOT_DAY_FORMAT</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>private static java.time.format.DateTimeFormatter</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ROOT_MONTH_FORMAT">ROOT_MONTH_FORMAT</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>private static org.apache.commons.codec.language.Soundex</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SOUNDEX">SOUNDEX</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>private static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#SOUNDEX_LENGTH">SOUNDEX_LENGTH</a></span></code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>private static java.lang.ThreadLocal&lt;java.util.Map&lt;java.lang.String,&#8203;java.util.concurrent.atomic.AtomicLong&gt;&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#THREAD_SEQUENCES">THREAD_SEQUENCES</a></span></code></th>
<td class="colLast">
<div class="block">Holds, for each thread, a map from sequence name to sequence current
value.</div>
</td>
</tr>
</table>
</li>
</ul>
</section>
<!-- ======== CONSTRUCTOR SUMMARY ======== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="constructor.summary">
<!-- -->
</a>
<h3>Constructor Summary</h3>
<table class="memberSummary">
<caption><span>Constructors</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier</th>
<th class="colSecond" scope="col">Constructor</th>
<th class="colLast" scope="col">Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>private </code></td>
<th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E()">SqlFunctions</a></span>()</code></th>
<td class="colLast">&nbsp;</td>
</tr>
</table>
</li>
</ul>
</section>
<!-- ========== METHOD SUMMARY =========== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="method.summary">
<!-- -->
</a>
<h3>Method Summary</h3>
<table class="memberSummary">
<caption><span id="t0" class="activeTableTab"><span>All Methods</span><span class="tabEnd">&nbsp;</span></span><span id="t1" class="tableTab"><span><a href="javascript:show(1);">Static Methods</a></span><span class="tabEnd">&nbsp;</span></span><span id="t4" class="tableTab"><span><a href="javascript:show(8);">Concrete Methods</a></span><span class="tabEnd">&nbsp;</span></span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colSecond" scope="col">Method</th>
<th class="colLast" scope="col">Description</th>
</tr>
<tr id="i0" class="altColor">
<td class="colFirst"><code>static byte</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#abs(byte)">abs</a></span>&#8203;(byte&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>ABS</code> operator applied to byte values.</div>
</td>
</tr>
<tr id="i1" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#abs(double)">abs</a></span>&#8203;(double&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>ABS</code> operator applied to double values.</div>
</td>
</tr>
<tr id="i2" class="altColor">
<td class="colFirst"><code>static float</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#abs(float)">abs</a></span>&#8203;(float&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>ABS</code> operator applied to float values.</div>
</td>
</tr>
<tr id="i3" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#abs(int)">abs</a></span>&#8203;(int&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>ABS</code> operator applied to int values.</div>
</td>
</tr>
<tr id="i4" class="altColor">
<td class="colFirst"><code>static long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#abs(long)">abs</a></span>&#8203;(long&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>ABS</code> operator applied to long values.</div>
</td>
</tr>
<tr id="i5" class="rowColor">
<td class="colFirst"><code>static short</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#abs(short)">abs</a></span>&#8203;(short&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>ABS</code> operator applied to short values.</div>
</td>
</tr>
<tr id="i6" class="altColor">
<td class="colFirst"><code>static java.math.BigDecimal</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#abs(java.math.BigDecimal)">abs</a></span>&#8203;(java.math.BigDecimal&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>ABS</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i7" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#acos(double)">acos</a></span>&#8203;(double&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>ACOS</code> operator applied to double values.</div>
</td>
</tr>
<tr id="i8" class="altColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#acos(java.math.BigDecimal)">acos</a></span>&#8203;(java.math.BigDecimal&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>ACOS</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i9" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#addMonths(int,int)">addMonths</a></span>&#8203;(int&nbsp;date,
int&nbsp;m)</code></th>
<td class="colLast">
<div class="block">Adds a given number of months to a date, represented as the number of
days since the epoch.</div>
</td>
</tr>
<tr id="i10" class="altColor">
<td class="colFirst"><code>static long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#addMonths(long,int)">addMonths</a></span>&#8203;(long&nbsp;timestamp,
int&nbsp;m)</code></th>
<td class="colLast">
<div class="block">Adds a given number of months to a timestamp, represented as the number
of milliseconds since the epoch.</div>
</td>
</tr>
<tr id="i11" class="rowColor">
<td class="colFirst"><code>private static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#allAssignable(java.lang.Class,java.lang.Object,java.lang.Object)">allAssignable</a></span>&#8203;(java.lang.Class&nbsp;clazz,
java.lang.Object&nbsp;o0,
java.lang.Object&nbsp;o1)</code></th>
<td class="colLast">
<div class="block">Returns whether two objects can both be assigned to a given class.</div>
</td>
</tr>
<tr id="i12" class="altColor">
<td class="colFirst"><code>static java.lang.Object[]</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#array(java.lang.Object...)">array</a></span>&#8203;(java.lang.Object...&nbsp;args)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i13" class="rowColor">
<td class="colFirst"><code>static java.lang.Object</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#arrayItem(java.util.List,int)">arrayItem</a></span>&#8203;(java.util.List&nbsp;list,
int&nbsp;item)</code></th>
<td class="colLast">
<div class="block">Helper for "array element reference".</div>
</td>
</tr>
<tr id="i14" class="altColor">
<td class="colFirst"><code>static java.lang.Object</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#arrayItemOptional(java.util.List,int)">arrayItemOptional</a></span>&#8203;(java.util.List&nbsp;list,
int&nbsp;item)</code></th>
<td class="colLast">
<div class="block">As <a href="#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="i15" class="rowColor">
<td class="colFirst"><code>static java.util.List</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#arrayToList(java.sql.Array)">arrayToList</a></span>&#8203;(java.sql.Array&nbsp;a)</code></th>
<td class="colLast">
<div class="block">Converts a JDBC array to a list.</div>
</td>
</tr>
<tr id="i16" class="altColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ascii(java.lang.String)">ascii</a></span>&#8203;(java.lang.String&nbsp;s)</code></th>
<td class="colLast">
<div class="block">SQL ASCII(string) function.</div>
</td>
</tr>
<tr id="i17" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#asin(double)">asin</a></span>&#8203;(double&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>ASIN</code> operator applied to double values.</div>
</td>
</tr>
<tr id="i18" class="altColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#asin(java.math.BigDecimal)">asin</a></span>&#8203;(java.math.BigDecimal&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>ASIN</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i19" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#atan(double)">atan</a></span>&#8203;(double&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>ATAN</code> operator applied to double values.</div>
</td>
</tr>
<tr id="i20" class="altColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#atan(java.math.BigDecimal)">atan</a></span>&#8203;(java.math.BigDecimal&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>ATAN</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i21" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#atan2(double,double)">atan2</a></span>&#8203;(double&nbsp;b0,
double&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>ATAN2</code> operator applied to double values.</div>
</td>
</tr>
<tr id="i22" class="altColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#atan2(double,java.math.BigDecimal)">atan2</a></span>&#8203;(double&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>ATAN2</code> operator applied to double/BigDecimal values.</div>
</td>
</tr>
<tr id="i23" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#atan2(java.math.BigDecimal,double)">atan2</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
double&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>ATAN2</code> operator applied to BigDecimal/double values.</div>
</td>
</tr>
<tr id="i24" class="altColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#atan2(java.math.BigDecimal,java.math.BigDecimal)">atan2</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>ATAN2</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i25" class="rowColor">
<td class="colFirst"><code>static long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#bitAnd(long,long)">bitAnd</a></span>&#8203;(long&nbsp;b0,
long&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">Helper function for implementing <code>BIT_AND</code></div>
</td>
</tr>
<tr id="i26" class="altColor">
<td class="colFirst"><code>static long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#bitOr(long,long)">bitOr</a></span>&#8203;(long&nbsp;b0,
long&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">Helper function for implementing <code>BIT_OR</code></div>
</td>
</tr>
<tr id="i27" class="rowColor">
<td class="colFirst"><code>private static java.lang.Object</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#cannotConvert(java.lang.Object,java.lang.Class)">cannotConvert</a></span>&#8203;(java.lang.Object&nbsp;o,
java.lang.Class&nbsp;toType)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i28" class="altColor">
<td class="colFirst"><code>static byte</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ceil(byte,byte)">ceil</a></span>&#8203;(byte&nbsp;b0,
byte&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>CEIL</code> operator applied to byte values.</div>
</td>
</tr>
<tr id="i29" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ceil(double)">ceil</a></span>&#8203;(double&nbsp;b0)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i30" class="altColor">
<td class="colFirst"><code>static float</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ceil(float)">ceil</a></span>&#8203;(float&nbsp;b0)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i31" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ceil(int,int)">ceil</a></span>&#8203;(int&nbsp;b0,
int&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>CEIL</code> operator applied to int values.</div>
</td>
</tr>
<tr id="i32" class="altColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ceil(int,java.math.BigDecimal)">ceil</a></span>&#8203;(int&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i33" class="rowColor">
<td class="colFirst"><code>static long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ceil(long,long)">ceil</a></span>&#8203;(long&nbsp;b0,
long&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>CEIL</code> operator applied to long values.</div>
</td>
</tr>
<tr id="i34" class="altColor">
<td class="colFirst"><code>static short</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ceil(short,short)">ceil</a></span>&#8203;(short&nbsp;b0,
short&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>CEIL</code> operator applied to short values.</div>
</td>
</tr>
<tr id="i35" class="rowColor">
<td class="colFirst"><code>static java.math.BigDecimal</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ceil(java.math.BigDecimal)">ceil</a></span>&#8203;(java.math.BigDecimal&nbsp;b0)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i36" class="altColor">
<td class="colFirst"><code>static java.math.BigDecimal</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ceil(java.math.BigDecimal,int)">ceil</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
int&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i37" class="rowColor">
<td class="colFirst"><code>static java.math.BigDecimal</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ceil(java.math.BigDecimal,java.math.BigDecimal)">ceil</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i38" class="altColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#charLength(java.lang.String)">charLength</a></span>&#8203;(java.lang.String&nbsp;s)</code></th>
<td class="colLast">
<div class="block">SQL CHARACTER_LENGTH(string) function.</div>
</td>
</tr>
<tr id="i39" class="rowColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#chr(long)">chr</a></span>&#8203;(long&nbsp;n)</code></th>
<td class="colLast">
<div class="block">SQL CHR(long) function.</div>
</td>
</tr>
<tr id="i40" class="altColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#compare(boolean,boolean)">compare</a></span>&#8203;(boolean&nbsp;x,
boolean&nbsp;y)</code></th>
<td class="colLast">
<div class="block">Boolean comparison.</div>
</td>
</tr>
<tr id="i41" class="rowColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#concat(java.lang.String,java.lang.String)">concat</a></span>&#8203;(java.lang.String&nbsp;s0,
java.lang.String&nbsp;s1)</code></th>
<td class="colLast">
<div class="block">SQL <code>string || string</code> operator.</div>
</td>
</tr>
<tr id="i42" class="altColor">
<td class="colFirst"><code>static org.apache.calcite.avatica.util.ByteString</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#concat(org.apache.calcite.avatica.util.ByteString,org.apache.calcite.avatica.util.ByteString)">concat</a></span>&#8203;(org.apache.calcite.avatica.util.ByteString&nbsp;s0,
org.apache.calcite.avatica.util.ByteString&nbsp;s1)</code></th>
<td class="colLast">
<div class="block">SQL <code>binary || binary</code> operator.</div>
</td>
</tr>
<tr id="i43" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#cos(double)">cos</a></span>&#8203;(double&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>COS</code> operator applied to double values.</div>
</td>
</tr>
<tr id="i44" class="altColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#cos(java.math.BigDecimal)">cos</a></span>&#8203;(java.math.BigDecimal&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>COS</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i45" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#cot(double)">cot</a></span>&#8203;(double&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>COT</code> operator applied to double values.</div>
</td>
</tr>
<tr id="i46" class="altColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#cot(java.math.BigDecimal)">cot</a></span>&#8203;(java.math.BigDecimal&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>COT</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i47" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#currentDate(org.apache.calcite.DataContext)">currentDate</a></span>&#8203;(<a href="../DataContext.html" title="interface in org.apache.calcite">DataContext</a>&nbsp;root)</code></th>
<td class="colLast">
<div class="block">SQL <code>CURRENT_DATE</code> function.</div>
</td>
</tr>
<tr id="i48" class="altColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#currentTime(org.apache.calcite.DataContext)">currentTime</a></span>&#8203;(<a href="../DataContext.html" title="interface in org.apache.calcite">DataContext</a>&nbsp;root)</code></th>
<td class="colLast">
<div class="block">SQL <code>CURRENT_TIME</code> function.</div>
</td>
</tr>
<tr id="i49" class="rowColor">
<td class="colFirst"><code>static long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#currentTimestamp(org.apache.calcite.DataContext)">currentTimestamp</a></span>&#8203;(<a href="../DataContext.html" title="interface in org.apache.calcite">DataContext</a>&nbsp;root)</code></th>
<td class="colLast">
<div class="block">SQL <code>CURRENT_TIMESTAMP</code> function.</div>
</td>
</tr>
<tr id="i50" class="altColor">
<td class="colFirst"><code>private static java.time.LocalDate</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#dateToLocalDate(int)">dateToLocalDate</a></span>&#8203;(int&nbsp;date)</code></th>
<td class="colLast">
<div class="block">Converts a date (days since epoch) to a <code>LocalDate</code>.</div>
</td>
</tr>
<tr id="i51" class="rowColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#dayNameWithDate(int,java.util.Locale)">dayNameWithDate</a></span>&#8203;(int&nbsp;date,
java.util.Locale&nbsp;locale)</code></th>
<td class="colLast">
<div class="block">SQL <code>DAYNAME</code> function, applied to a DATE argument.</div>
</td>
</tr>
<tr id="i52" class="altColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#dayNameWithTimestamp(long,java.util.Locale)">dayNameWithTimestamp</a></span>&#8203;(long&nbsp;timestamp,
java.util.Locale&nbsp;locale)</code></th>
<td class="colLast">
<div class="block">SQL <code>DAYNAME</code> function, applied to a TIMESTAMP argument.</div>
</td>
</tr>
<tr id="i53" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#degrees(double)">degrees</a></span>&#8203;(double&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>DEGREES</code> operator applied to double values.</div>
</td>
</tr>
<tr id="i54" class="altColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#degrees(java.math.BigDecimal)">degrees</a></span>&#8203;(java.math.BigDecimal&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>DEGREES</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i55" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#difference(java.lang.String,java.lang.String)">difference</a></span>&#8203;(java.lang.String&nbsp;s0,
java.lang.String&nbsp;s1)</code></th>
<td class="colLast">
<div class="block">SQL DIFFERENCE(string, string) function.</div>
</td>
</tr>
<tr id="i56" class="altColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#divide(int,int)">divide</a></span>&#8203;(int&nbsp;b0,
int&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>/</code> operator applied to int values.</div>
</td>
</tr>
<tr id="i57" class="rowColor">
<td class="colFirst"><code>static java.lang.Integer</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#divide(int,java.lang.Integer)">divide</a></span>&#8203;(int&nbsp;b0,
java.lang.Integer&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>/</code> operator applied to int values; right side may be
null.</div>
</td>
</tr>
<tr id="i58" class="altColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#divide(int,java.math.BigDecimal)">divide</a></span>&#8203;(int&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i59" class="rowColor">
<td class="colFirst"><code>static long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#divide(long,java.math.BigDecimal)">divide</a></span>&#8203;(long&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i60" class="altColor">
<td class="colFirst"><code>static java.lang.Integer</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#divide(java.lang.Integer,int)">divide</a></span>&#8203;(java.lang.Integer&nbsp;b0,
int&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>/</code> operator applied to int values; left side may be
null.</div>
</td>
</tr>
<tr id="i61" class="rowColor">
<td class="colFirst"><code>static java.lang.Integer</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#divide(java.lang.Integer,java.lang.Integer)">divide</a></span>&#8203;(java.lang.Integer&nbsp;b0,
java.lang.Integer&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>/</code> operator applied to nullable int values.</div>
</td>
</tr>
<tr id="i62" class="altColor">
<td class="colFirst"><code>static java.lang.Long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#divide(java.lang.Integer,java.lang.Long)">divide</a></span>&#8203;(java.lang.Integer&nbsp;b0,
java.lang.Long&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>/</code> operator applied to nullable int and long values.</div>
</td>
</tr>
<tr id="i63" class="rowColor">
<td class="colFirst"><code>static java.lang.Long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#divide(java.lang.Long,java.lang.Integer)">divide</a></span>&#8203;(java.lang.Long&nbsp;b0,
java.lang.Integer&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>/</code> operator applied to nullable long and int values.</div>
</td>
</tr>
<tr id="i64" class="altColor">
<td class="colFirst"><code>static java.math.BigDecimal</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#divide(java.math.BigDecimal,java.math.BigDecimal)">divide</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>/</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i65" class="rowColor">
<td class="colFirst"><code>static java.lang.Object</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#divideAny(java.lang.Object,java.lang.Object)">divideAny</a></span>&#8203;(java.lang.Object&nbsp;b0,
java.lang.Object&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>/</code> operator applied to Object values (at least one operand
has ANY type; either may be null).</div>
</td>
</tr>
<tr id="i66" class="altColor">
<td class="colFirst"><code>static java.lang.Object</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#element(java.util.List)">element</a></span>&#8203;(java.util.List&nbsp;list)</code></th>
<td class="colLast">
<div class="block">Support the ELEMENT function.</div>
</td>
</tr>
<tr id="i67" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#eq(java.lang.Object,java.lang.Object)">eq</a></span>&#8203;(java.lang.Object&nbsp;b0,
java.lang.Object&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>=</code> operator applied to Object values (including String;
neither side may be null).</div>
</td>
</tr>
<tr id="i68" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#eq(java.math.BigDecimal,java.math.BigDecimal)">eq</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>=</code> operator applied to BigDecimal values (neither may be
null).</div>
</td>
</tr>
<tr id="i69" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#eqAny(java.lang.Object,java.lang.Object)">eqAny</a></span>&#8203;(java.lang.Object&nbsp;b0,
java.lang.Object&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>=</code> operator applied to Object values (at least one operand
has ANY type; neither may be null).</div>
</td>
</tr>
<tr id="i70" class="altColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#exp(double)">exp</a></span>&#8203;(double&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>EXP</code> operator applied to double values.</div>
</td>
</tr>
<tr id="i71" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#exp(java.math.BigDecimal)">exp</a></span>&#8203;(java.math.BigDecimal&nbsp;b0)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i72" class="altColor">
<td class="colFirst"><code>static <a href="../linq4j/function/Function1.html" title="interface in org.apache.calcite.linq4j.function">Function1</a>&lt;java.lang.Object,&#8203;<a href="../linq4j/Enumerable.html" title="interface in org.apache.calcite.linq4j">Enumerable</a>&lt;<a href="FlatLists.ComparableList.html" title="interface in org.apache.calcite.runtime">FlatLists.ComparableList</a>&lt;java.lang.Comparable&gt;&gt;&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#flatProduct(int%5B%5D,boolean,org.apache.calcite.runtime.SqlFunctions.FlatProductInputType%5B%5D)">flatProduct</a></span>&#8203;(int[]&nbsp;fieldCounts,
boolean&nbsp;withOrdinality,
<a href="SqlFunctions.FlatProductInputType.html" title="enum in org.apache.calcite.runtime">SqlFunctions.FlatProductInputType</a>[]&nbsp;inputTypes)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i73" class="rowColor">
<td class="colFirst"><code>static byte</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#floor(byte,byte)">floor</a></span>&#8203;(byte&nbsp;b0,
byte&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>FLOOR</code> operator applied to byte values.</div>
</td>
</tr>
<tr id="i74" class="altColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#floor(double)">floor</a></span>&#8203;(double&nbsp;b0)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i75" class="rowColor">
<td class="colFirst"><code>static float</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#floor(float)">floor</a></span>&#8203;(float&nbsp;b0)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i76" class="altColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#floor(int,int)">floor</a></span>&#8203;(int&nbsp;b0,
int&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>FLOOR</code> operator applied to int values.</div>
</td>
</tr>
<tr id="i77" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#floor(int,java.math.BigDecimal)">floor</a></span>&#8203;(int&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i78" class="altColor">
<td class="colFirst"><code>static long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#floor(long,long)">floor</a></span>&#8203;(long&nbsp;b0,
long&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>FLOOR</code> operator applied to long values.</div>
</td>
</tr>
<tr id="i79" class="rowColor">
<td class="colFirst"><code>static short</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#floor(short,short)">floor</a></span>&#8203;(short&nbsp;b0,
short&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>FLOOR</code> operator applied to short values.</div>
</td>
</tr>
<tr id="i80" class="altColor">
<td class="colFirst"><code>static java.math.BigDecimal</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#floor(java.math.BigDecimal)">floor</a></span>&#8203;(java.math.BigDecimal&nbsp;b0)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i81" class="rowColor">
<td class="colFirst"><code>static java.math.BigDecimal</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#floor(java.math.BigDecimal,int)">floor</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
int&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i82" class="altColor">
<td class="colFirst"><code>static java.math.BigDecimal</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#floor(java.math.BigDecimal,java.math.BigDecimal)">floor</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i83" class="rowColor">
<td class="colFirst"><code>static org.apache.calcite.avatica.util.ByteString</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#fromBase64(java.lang.String)">fromBase64</a></span>&#8203;(java.lang.String&nbsp;base64)</code></th>
<td class="colLast">
<div class="block">SQL FROM_BASE64(string) function.</div>
</td>
</tr>
<tr id="i84" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ge(boolean,boolean)">ge</a></span>&#8203;(boolean&nbsp;b0,
boolean&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&ge;</code> operator applied to boolean values.</div>
</td>
</tr>
<tr id="i85" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ge(java.lang.String,java.lang.String)">ge</a></span>&#8203;(java.lang.String&nbsp;b0,
java.lang.String&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&ge;</code> operator applied to String values.</div>
</td>
</tr>
<tr id="i86" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ge(java.math.BigDecimal,java.math.BigDecimal)">ge</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&ge;</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i87" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ge(org.apache.calcite.avatica.util.ByteString,org.apache.calcite.avatica.util.ByteString)">ge</a></span>&#8203;(org.apache.calcite.avatica.util.ByteString&nbsp;b0,
org.apache.calcite.avatica.util.ByteString&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&ge;</code> operator applied to ByteString values.</div>
</td>
</tr>
<tr id="i88" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#geAny(java.lang.Object,java.lang.Object)">geAny</a></span>&#8203;(java.lang.Object&nbsp;b0,
java.lang.Object&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&ge;</code> operator applied to Object values (at least one
operand has ANY type; neither may be null).</div>
</td>
</tr>
<tr id="i89" class="rowColor">
<td class="colFirst"><code>private static java.util.concurrent.atomic.AtomicLong</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getAtomicLong(java.lang.String)">getAtomicLong</a></span>&#8203;(java.lang.String&nbsp;key)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i90" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#greater(boolean,boolean)">greater</a></span>&#8203;(boolean&nbsp;b0,
boolean&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i91" class="rowColor">
<td class="colFirst"><code>static byte</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#greater(byte,byte)">greater</a></span>&#8203;(byte&nbsp;b0,
byte&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i92" class="altColor">
<td class="colFirst"><code>static char</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#greater(char,char)">greater</a></span>&#8203;(char&nbsp;b0,
char&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i93" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#greater(double,double)">greater</a></span>&#8203;(double&nbsp;b0,
double&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i94" class="altColor">
<td class="colFirst"><code>static float</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#greater(float,float)">greater</a></span>&#8203;(float&nbsp;b0,
float&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i95" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#greater(int,int)">greater</a></span>&#8203;(int&nbsp;b0,
int&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i96" class="altColor">
<td class="colFirst"><code>static long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#greater(long,long)">greater</a></span>&#8203;(long&nbsp;b0,
long&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i97" class="rowColor">
<td class="colFirst"><code>static short</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#greater(short,short)">greater</a></span>&#8203;(short&nbsp;b0,
short&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i98" class="altColor">
<td class="colFirst"><code>static &lt;T extends java.lang.Comparable&lt;T&gt;&gt;<br>T</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#greater(T,T)">greater</a></span>&#8203;(T&nbsp;b0,
T&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">Helper for implementing MAX.</div>
</td>
</tr>
<tr id="i99" class="rowColor">
<td class="colFirst"><code>static &lt;T extends java.lang.Comparable&lt;T&gt;&gt;<br>T</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#greatest(T,T)">greatest</a></span>&#8203;(T&nbsp;b0,
T&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">GREATEST operator.</div>
</td>
</tr>
<tr id="i100" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#gt(boolean,boolean)">gt</a></span>&#8203;(boolean&nbsp;b0,
boolean&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&gt;</code> operator applied to boolean values.</div>
</td>
</tr>
<tr id="i101" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#gt(java.lang.String,java.lang.String)">gt</a></span>&#8203;(java.lang.String&nbsp;b0,
java.lang.String&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&gt;</code> operator applied to String values.</div>
</td>
</tr>
<tr id="i102" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#gt(java.math.BigDecimal,java.math.BigDecimal)">gt</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&gt;</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i103" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#gt(org.apache.calcite.avatica.util.ByteString,org.apache.calcite.avatica.util.ByteString)">gt</a></span>&#8203;(org.apache.calcite.avatica.util.ByteString&nbsp;b0,
org.apache.calcite.avatica.util.ByteString&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&gt;</code> operator applied to ByteString values.</div>
</td>
</tr>
<tr id="i104" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#gtAny(java.lang.Object,java.lang.Object)">gtAny</a></span>&#8203;(java.lang.Object&nbsp;b0,
java.lang.Object&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&gt;</code> operator applied to Object values (at least one
operand has ANY type; neither may be null).</div>
</td>
</tr>
<tr id="i105" class="rowColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#initcap(java.lang.String)">initcap</a></span>&#8203;(java.lang.String&nbsp;s)</code></th>
<td class="colLast">
<div class="block">SQL INITCAP(string) function.</div>
</td>
</tr>
<tr id="i106" class="altColor">
<td class="colFirst"><code>static java.sql.Date</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#internalToDate(int)">internalToDate</a></span>&#8203;(int&nbsp;v)</code></th>
<td class="colLast">
<div class="block">Converts the internal representation of a SQL DATE (int) to the Java
type used for UDF parameters (<code>Date</code>).</div>
</td>
</tr>
<tr id="i107" class="rowColor">
<td class="colFirst"><code>static java.sql.Date</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#internalToDate(java.lang.Integer)">internalToDate</a></span>&#8203;(java.lang.Integer&nbsp;v)</code></th>
<td class="colLast">
<div class="block">As <a href="#internalToDate(int)"><code>internalToDate(int)</code></a> but allows nulls.</div>
</td>
</tr>
<tr id="i108" class="altColor">
<td class="colFirst"><code>static java.sql.Time</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#internalToTime(int)">internalToTime</a></span>&#8203;(int&nbsp;v)</code></th>
<td class="colLast">
<div class="block">Converts the internal representation of a SQL TIME (int) to the Java
type used for UDF parameters (<code>Time</code>).</div>
</td>
</tr>
<tr id="i109" class="rowColor">
<td class="colFirst"><code>static java.sql.Time</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#internalToTime(java.lang.Integer)">internalToTime</a></span>&#8203;(java.lang.Integer&nbsp;v)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i110" class="altColor">
<td class="colFirst"><code>static java.sql.Timestamp</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#internalToTimestamp(long)">internalToTimestamp</a></span>&#8203;(long&nbsp;v)</code></th>
<td class="colLast">
<div class="block">Converts the internal representation of a SQL TIMESTAMP (long) to the Java
type used for UDF parameters (<code>Timestamp</code>).</div>
</td>
</tr>
<tr id="i111" class="rowColor">
<td class="colFirst"><code>static java.sql.Timestamp</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#internalToTimestamp(java.lang.Long)">internalToTimestamp</a></span>&#8203;(java.lang.Long&nbsp;v)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i112" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#isASet(java.util.Collection)">isASet</a></span>&#8203;(java.util.Collection&nbsp;collection)</code></th>
<td class="colLast">
<div class="block">Support the IS A SET function.</div>
</td>
</tr>
<tr id="i113" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#isFalse(java.lang.Boolean)">isFalse</a></span>&#8203;(java.lang.Boolean&nbsp;b)</code></th>
<td class="colLast">
<div class="block">NULL &rarr; FALSE, FALSE &rarr; TRUE, TRUE &rarr; FALSE.</div>
</td>
</tr>
<tr id="i114" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#isNotFalse(java.lang.Boolean)">isNotFalse</a></span>&#8203;(java.lang.Boolean&nbsp;b)</code></th>
<td class="colLast">
<div class="block">NULL &rarr; TRUE, FALSE &rarr; FALSE, TRUE &rarr; TRUE.</div>
</td>
</tr>
<tr id="i115" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#isNotTrue(java.lang.Boolean)">isNotTrue</a></span>&#8203;(java.lang.Boolean&nbsp;b)</code></th>
<td class="colLast">
<div class="block">NULL &rarr; TRUE, FALSE &rarr; TRUE, TRUE &rarr; FALSE.</div>
</td>
</tr>
<tr id="i116" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#isTrue(java.lang.Boolean)">isTrue</a></span>&#8203;(java.lang.Boolean&nbsp;b)</code></th>
<td class="colLast">
<div class="block">NULL &rarr; FALSE, FALSE &rarr; FALSE, TRUE &rarr; TRUE.</div>
</td>
</tr>
<tr id="i117" class="rowColor">
<td class="colFirst"><code>static java.lang.Object</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#item(java.lang.Object,java.lang.Object)">item</a></span>&#8203;(java.lang.Object&nbsp;object,
java.lang.Object&nbsp;index)</code></th>
<td class="colLast">
<div class="block">Implements the <code>[ ... ]</code> operator on an object whose type is not
known until runtime.</div>
</td>
</tr>
<tr id="i118" class="altColor">
<td class="colFirst"><code>static java.lang.Object</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#itemOptional(java.lang.Object,java.lang.Object)">itemOptional</a></span>&#8203;(java.lang.Object&nbsp;object,
java.lang.Object&nbsp;index)</code></th>
<td class="colLast">
<div class="block">As <a href="#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="i119" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lastDay(int)">lastDay</a></span>&#8203;(int&nbsp;date)</code></th>
<td class="colLast">
<div class="block">SQL <code>LAST_DAY</code> function.</div>
</td>
</tr>
<tr id="i120" class="altColor">
<td class="colFirst"><code>private static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lastDay(int,int)">lastDay</a></span>&#8203;(int&nbsp;y,
int&nbsp;m)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i121" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lastDay(long)">lastDay</a></span>&#8203;(long&nbsp;timestamp)</code></th>
<td class="colLast">
<div class="block">SQL <code>LAST_DAY</code> function.</div>
</td>
</tr>
<tr id="i122" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#le(boolean,boolean)">le</a></span>&#8203;(boolean&nbsp;b0,
boolean&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&le;</code> operator applied to boolean values.</div>
</td>
</tr>
<tr id="i123" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#le(java.lang.String,java.lang.String)">le</a></span>&#8203;(java.lang.String&nbsp;b0,
java.lang.String&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&le;</code> operator applied to String values.</div>
</td>
</tr>
<tr id="i124" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#le(java.math.BigDecimal,java.math.BigDecimal)">le</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&le;</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i125" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#le(org.apache.calcite.avatica.util.ByteString,org.apache.calcite.avatica.util.ByteString)">le</a></span>&#8203;(org.apache.calcite.avatica.util.ByteString&nbsp;b0,
org.apache.calcite.avatica.util.ByteString&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&le;</code> operator applied to ByteString values.</div>
</td>
</tr>
<tr id="i126" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#leAny(java.lang.Object,java.lang.Object)">leAny</a></span>&#8203;(java.lang.Object&nbsp;b0,
java.lang.Object&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&le;</code> operator applied to Object values (at least one
operand has ANY type; neither may be null).</div>
</td>
</tr>
<tr id="i127" class="rowColor">
<td class="colFirst"><code>static &lt;T extends java.lang.Comparable&lt;T&gt;&gt;<br>T</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#least(T,T)">least</a></span>&#8203;(T&nbsp;b0,
T&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">LEAST operator.</div>
</td>
</tr>
<tr id="i128" class="altColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#left(java.lang.String,int)">left</a></span>&#8203;(java.lang.String&nbsp;s,
int&nbsp;n)</code></th>
<td class="colLast">
<div class="block">SQL LEFT(string, integer) function.</div>
</td>
</tr>
<tr id="i129" class="rowColor">
<td class="colFirst"><code>static org.apache.calcite.avatica.util.ByteString</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#left(org.apache.calcite.avatica.util.ByteString,int)">left</a></span>&#8203;(org.apache.calcite.avatica.util.ByteString&nbsp;s,
int&nbsp;n)</code></th>
<td class="colLast">
<div class="block">SQL LEFT(ByteString, integer) function.</div>
</td>
</tr>
<tr id="i130" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lesser(boolean,boolean)">lesser</a></span>&#8203;(boolean&nbsp;b0,
boolean&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i131" class="rowColor">
<td class="colFirst"><code>static byte</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lesser(byte,byte)">lesser</a></span>&#8203;(byte&nbsp;b0,
byte&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i132" class="altColor">
<td class="colFirst"><code>static char</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lesser(char,char)">lesser</a></span>&#8203;(char&nbsp;b0,
char&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i133" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lesser(double,double)">lesser</a></span>&#8203;(double&nbsp;b0,
double&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i134" class="altColor">
<td class="colFirst"><code>static float</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lesser(float,float)">lesser</a></span>&#8203;(float&nbsp;b0,
float&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i135" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lesser(int,int)">lesser</a></span>&#8203;(int&nbsp;b0,
int&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i136" class="altColor">
<td class="colFirst"><code>static long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lesser(long,long)">lesser</a></span>&#8203;(long&nbsp;b0,
long&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i137" class="rowColor">
<td class="colFirst"><code>static short</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lesser(short,short)">lesser</a></span>&#8203;(short&nbsp;b0,
short&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i138" class="altColor">
<td class="colFirst"><code>static &lt;T extends java.lang.Comparable&lt;T&gt;&gt;<br>T</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lesser(T,T)">lesser</a></span>&#8203;(T&nbsp;b0,
T&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">Helper for implementing MIN.</div>
</td>
</tr>
<tr id="i139" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#like(java.lang.String,java.lang.String)">like</a></span>&#8203;(java.lang.String&nbsp;s,
java.lang.String&nbsp;pattern)</code></th>
<td class="colLast">
<div class="block">SQL <code>LIKE</code> function.</div>
</td>
</tr>
<tr id="i140" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#like(java.lang.String,java.lang.String,java.lang.String)">like</a></span>&#8203;(java.lang.String&nbsp;s,
java.lang.String&nbsp;pattern,
java.lang.String&nbsp;escape)</code></th>
<td class="colLast">
<div class="block">SQL <code>LIKE</code> function with escape.</div>
</td>
</tr>
<tr id="i141" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ln(double)">ln</a></span>&#8203;(double&nbsp;d)</code></th>
<td class="colLast">
<div class="block">SQL <code>LN(number)</code> function applied to double values.</div>
</td>
</tr>
<tr id="i142" class="altColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ln(java.math.BigDecimal)">ln</a></span>&#8203;(java.math.BigDecimal&nbsp;d)</code></th>
<td class="colLast">
<div class="block">SQL <code>LN(number)</code> function applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i143" class="rowColor">
<td class="colFirst"><code>static java.util.Locale</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#locale(org.apache.calcite.DataContext)">locale</a></span>&#8203;(<a href="../DataContext.html" title="interface in org.apache.calcite">DataContext</a>&nbsp;root)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i144" class="altColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#localTime(org.apache.calcite.DataContext)">localTime</a></span>&#8203;(<a href="../DataContext.html" title="interface in org.apache.calcite">DataContext</a>&nbsp;root)</code></th>
<td class="colLast">
<div class="block">SQL <code>LOCAL_TIME</code> function.</div>
</td>
</tr>
<tr id="i145" class="rowColor">
<td class="colFirst"><code>static long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#localTimestamp(org.apache.calcite.DataContext)">localTimestamp</a></span>&#8203;(<a href="../DataContext.html" title="interface in org.apache.calcite">DataContext</a>&nbsp;root)</code></th>
<td class="colLast">
<div class="block">SQL <code>LOCAL_TIMESTAMP</code> function.</div>
</td>
</tr>
<tr id="i146" class="altColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#log10(double)">log10</a></span>&#8203;(double&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>LOG10(numeric)</code> operator applied to double values.</div>
</td>
</tr>
<tr id="i147" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#log10(java.math.BigDecimal)">log10</a></span>&#8203;(java.math.BigDecimal&nbsp;d)</code></th>
<td class="colLast">
<div class="block">SQL <code>LOG10(number)</code> function applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i148" class="altColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lower(java.lang.String)">lower</a></span>&#8203;(java.lang.String&nbsp;s)</code></th>
<td class="colLast">
<div class="block">SQL LOWER(string) function.</div>
</td>
</tr>
<tr id="i149" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lt(boolean,boolean)">lt</a></span>&#8203;(boolean&nbsp;b0,
boolean&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&lt;</code> operator applied to boolean values.</div>
</td>
</tr>
<tr id="i150" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lt(java.lang.String,java.lang.String)">lt</a></span>&#8203;(java.lang.String&nbsp;b0,
java.lang.String&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&lt;</code> operator applied to String values.</div>
</td>
</tr>
<tr id="i151" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lt(java.math.BigDecimal,java.math.BigDecimal)">lt</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&lt;</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i152" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#lt(org.apache.calcite.avatica.util.ByteString,org.apache.calcite.avatica.util.ByteString)">lt</a></span>&#8203;(org.apache.calcite.avatica.util.ByteString&nbsp;b0,
org.apache.calcite.avatica.util.ByteString&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&lt;</code> operator applied to ByteString values.</div>
</td>
</tr>
<tr id="i153" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ltAny(java.lang.Object,java.lang.Object)">ltAny</a></span>&#8203;(java.lang.Object&nbsp;b0,
java.lang.Object&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&lt;</code> operator applied to Object values.</div>
</td>
</tr>
<tr id="i154" class="altColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ltrim(java.lang.String)">ltrim</a></span>&#8203;(java.lang.String&nbsp;s)</code></th>
<td class="colLast">
<div class="block">SQL <code>LTRIM</code> function.</div>
</td>
</tr>
<tr id="i155" class="rowColor">
<td class="colFirst"><code>private static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#makeRegexpFlags(java.lang.String)">makeRegexpFlags</a></span>&#8203;(java.lang.String&nbsp;stringFlags)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i156" class="altColor">
<td class="colFirst"><code>static java.lang.Object</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#mapItem(java.util.Map,java.lang.Object)">mapItem</a></span>&#8203;(java.util.Map&nbsp;map,
java.lang.Object&nbsp;item)</code></th>
<td class="colLast">
<div class="block">Helper for "map element reference".</div>
</td>
</tr>
<tr id="i157" class="rowColor">
<td class="colFirst"><code>static java.lang.Object</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#mapItemOptional(java.util.Map,java.lang.Object)">mapItemOptional</a></span>&#8203;(java.util.Map&nbsp;map,
java.lang.Object&nbsp;item)</code></th>
<td class="colLast">
<div class="block">As <a href="#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="i158" class="altColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#md5(java.lang.String)">md5</a></span>&#8203;(java.lang.String&nbsp;string)</code></th>
<td class="colLast">
<div class="block">SQL MD5(string) function.</div>
</td>
</tr>
<tr id="i159" class="rowColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#md5(org.apache.calcite.avatica.util.ByteString)">md5</a></span>&#8203;(org.apache.calcite.avatica.util.ByteString&nbsp;string)</code></th>
<td class="colLast">
<div class="block">SQL MD5(string) function for binary string.</div>
</td>
</tr>
<tr id="i160" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#memberOf(java.lang.Object,java.util.Collection)">memberOf</a></span>&#8203;(java.lang.Object&nbsp;object,
java.util.Collection&nbsp;collection)</code></th>
<td class="colLast">
<div class="block">Support the MEMBER OF function.</div>
</td>
</tr>
<tr id="i161" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#minus(int,int)">minus</a></span>&#8203;(int&nbsp;b0,
int&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>-</code> operator applied to int values.</div>
</td>
</tr>
<tr id="i162" class="altColor">
<td class="colFirst"><code>static java.lang.Integer</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#minus(int,java.lang.Integer)">minus</a></span>&#8203;(int&nbsp;b0,
java.lang.Integer&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>-</code> operator applied to int values; right side may be
null.</div>
</td>
</tr>
<tr id="i163" class="rowColor">
<td class="colFirst"><code>static java.lang.Integer</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#minus(java.lang.Integer,int)">minus</a></span>&#8203;(java.lang.Integer&nbsp;b0,
int&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>-</code> operator applied to int values; left side may be
null.</div>
</td>
</tr>
<tr id="i164" class="altColor">
<td class="colFirst"><code>static java.lang.Integer</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#minus(java.lang.Integer,java.lang.Integer)">minus</a></span>&#8203;(java.lang.Integer&nbsp;b0,
java.lang.Integer&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>-</code> operator applied to nullable int values.</div>
</td>
</tr>
<tr id="i165" class="rowColor">
<td class="colFirst"><code>static java.lang.Long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#minus(java.lang.Integer,java.lang.Long)">minus</a></span>&#8203;(java.lang.Integer&nbsp;b0,
java.lang.Long&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>-</code> operator applied to nullable int and long values.</div>
</td>
</tr>
<tr id="i166" class="altColor">
<td class="colFirst"><code>static java.lang.Long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#minus(java.lang.Long,java.lang.Integer)">minus</a></span>&#8203;(java.lang.Long&nbsp;b0,
java.lang.Integer&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>-</code> operator applied to nullable long and int values.</div>
</td>
</tr>
<tr id="i167" class="rowColor">
<td class="colFirst"><code>static java.math.BigDecimal</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#minus(java.math.BigDecimal,java.math.BigDecimal)">minus</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>-</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i168" class="altColor">
<td class="colFirst"><code>static java.lang.Object</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#minusAny(java.lang.Object,java.lang.Object)">minusAny</a></span>&#8203;(java.lang.Object&nbsp;b0,
java.lang.Object&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>-</code> operator applied to Object values (at least one operand
has ANY type; either may be null).</div>
</td>
</tr>
<tr id="i169" class="rowColor">
<td class="colFirst"><code>static byte</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#mod(byte,byte)">mod</a></span>&#8203;(byte&nbsp;b0,
byte&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>MOD</code> operator applied to byte values.</div>
</td>
</tr>
<tr id="i170" class="altColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#mod(int,int)">mod</a></span>&#8203;(int&nbsp;b0,
int&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>MOD</code> operator applied to int values.</div>
</td>
</tr>
<tr id="i171" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#mod(int,java.math.BigDecimal)">mod</a></span>&#8203;(int&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i172" class="altColor">
<td class="colFirst"><code>static long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#mod(long,long)">mod</a></span>&#8203;(long&nbsp;b0,
long&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>MOD</code> operator applied to long values.</div>
</td>
</tr>
<tr id="i173" class="rowColor">
<td class="colFirst"><code>static short</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#mod(short,short)">mod</a></span>&#8203;(short&nbsp;b0,
short&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>MOD</code> operator applied to short values.</div>
</td>
</tr>
<tr id="i174" class="altColor">
<td class="colFirst"><code>static java.math.BigDecimal</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#mod(java.math.BigDecimal,int)">mod</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
int&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i175" class="rowColor">
<td class="colFirst"><code>static java.math.BigDecimal</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#mod(java.math.BigDecimal,java.math.BigDecimal)">mod</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i176" class="altColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#monthNameWithDate(int,java.util.Locale)">monthNameWithDate</a></span>&#8203;(int&nbsp;date,
java.util.Locale&nbsp;locale)</code></th>
<td class="colLast">
<div class="block">SQL <code>MONTHNAME</code> function, applied to a DATE argument.</div>
</td>
</tr>
<tr id="i177" class="rowColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#monthNameWithTimestamp(long,java.util.Locale)">monthNameWithTimestamp</a></span>&#8203;(long&nbsp;timestamp,
java.util.Locale&nbsp;locale)</code></th>
<td class="colLast">
<div class="block">SQL <code>MONTHNAME</code> function, applied to a TIMESTAMP argument.</div>
</td>
</tr>
<tr id="i178" class="altColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#multiply(int,int)">multiply</a></span>&#8203;(int&nbsp;b0,
int&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>*</code> operator applied to int values.</div>
</td>
</tr>
<tr id="i179" class="rowColor">
<td class="colFirst"><code>static java.lang.Integer</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#multiply(int,java.lang.Integer)">multiply</a></span>&#8203;(int&nbsp;b0,
java.lang.Integer&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>*</code> operator applied to int values; right side may be
null.</div>
</td>
</tr>
<tr id="i180" class="altColor">
<td class="colFirst"><code>static java.lang.Integer</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#multiply(java.lang.Integer,int)">multiply</a></span>&#8203;(java.lang.Integer&nbsp;b0,
int&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>*</code> operator applied to int values; left side may be
null.</div>
</td>
</tr>
<tr id="i181" class="rowColor">
<td class="colFirst"><code>static java.lang.Integer</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#multiply(java.lang.Integer,java.lang.Integer)">multiply</a></span>&#8203;(java.lang.Integer&nbsp;b0,
java.lang.Integer&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>*</code> operator applied to nullable int values.</div>
</td>
</tr>
<tr id="i182" class="altColor">
<td class="colFirst"><code>static java.lang.Long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#multiply(java.lang.Integer,java.lang.Long)">multiply</a></span>&#8203;(java.lang.Integer&nbsp;b0,
java.lang.Long&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>*</code> operator applied to nullable int and long values.</div>
</td>
</tr>
<tr id="i183" class="rowColor">
<td class="colFirst"><code>static java.lang.Long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#multiply(java.lang.Long,java.lang.Integer)">multiply</a></span>&#8203;(java.lang.Long&nbsp;b0,
java.lang.Integer&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>*</code> operator applied to nullable long and int values.</div>
</td>
</tr>
<tr id="i184" class="altColor">
<td class="colFirst"><code>static java.math.BigDecimal</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#multiply(java.math.BigDecimal,java.math.BigDecimal)">multiply</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>*</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i185" class="rowColor">
<td class="colFirst"><code>static java.lang.Object</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#multiplyAny(java.lang.Object,java.lang.Object)">multiplyAny</a></span>&#8203;(java.lang.Object&nbsp;b0,
java.lang.Object&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>*</code> operator applied to Object values (at least one operand
has ANY type; either may be null).</div>
</td>
</tr>
<tr id="i186" class="altColor">
<td class="colFirst"><code>static &lt;E&gt;&nbsp;java.util.Collection&lt;E&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#multisetExceptAll(java.util.Collection,java.util.Collection)">multisetExceptAll</a></span>&#8203;(java.util.Collection&lt;E&gt;&nbsp;c1,
java.util.Collection&lt;E&gt;&nbsp;c2)</code></th>
<td class="colLast">
<div class="block">Support the MULTISET EXCEPT ALL function.</div>
</td>
</tr>
<tr id="i187" class="rowColor">
<td class="colFirst"><code>static &lt;E&gt;&nbsp;java.util.Collection&lt;E&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#multisetExceptDistinct(java.util.Collection,java.util.Collection)">multisetExceptDistinct</a></span>&#8203;(java.util.Collection&lt;E&gt;&nbsp;c1,
java.util.Collection&lt;E&gt;&nbsp;c2)</code></th>
<td class="colLast">
<div class="block">Support the MULTISET EXCEPT DISTINCT function.</div>
</td>
</tr>
<tr id="i188" class="altColor">
<td class="colFirst"><code>static &lt;E&gt;&nbsp;java.util.Collection&lt;E&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#multisetIntersectAll(java.util.Collection,java.util.Collection)">multisetIntersectAll</a></span>&#8203;(java.util.Collection&lt;E&gt;&nbsp;c1,
java.util.Collection&lt;E&gt;&nbsp;c2)</code></th>
<td class="colLast">
<div class="block">Support the MULTISET INTERSECT ALL function.</div>
</td>
</tr>
<tr id="i189" class="rowColor">
<td class="colFirst"><code>static &lt;E&gt;&nbsp;java.util.Collection&lt;E&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#multisetIntersectDistinct(java.util.Collection,java.util.Collection)">multisetIntersectDistinct</a></span>&#8203;(java.util.Collection&lt;E&gt;&nbsp;c1,
java.util.Collection&lt;E&gt;&nbsp;c2)</code></th>
<td class="colLast">
<div class="block">Support the MULTISET INTERSECT DISTINCT function.</div>
</td>
</tr>
<tr id="i190" class="altColor">
<td class="colFirst"><code>static java.util.Collection</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#multisetUnionAll(java.util.Collection,java.util.Collection)">multisetUnionAll</a></span>&#8203;(java.util.Collection&nbsp;collection1,
java.util.Collection&nbsp;collection2)</code></th>
<td class="colLast">
<div class="block">Support the MULTISET UNION ALL function.</div>
</td>
</tr>
<tr id="i191" class="rowColor">
<td class="colFirst"><code>static java.util.Collection</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#multisetUnionDistinct(java.util.Collection,java.util.Collection)">multisetUnionDistinct</a></span>&#8203;(java.util.Collection&nbsp;collection1,
java.util.Collection&nbsp;collection2)</code></th>
<td class="colLast">
<div class="block">Support the MULTISET UNION function.</div>
</td>
</tr>
<tr id="i192" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ne(java.lang.Object,java.lang.Object)">ne</a></span>&#8203;(java.lang.Object&nbsp;b0,
java.lang.Object&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&lt;gt;</code> operator applied to Object values (including
String; neither side may be null).</div>
</td>
</tr>
<tr id="i193" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#ne(java.math.BigDecimal,java.math.BigDecimal)">ne</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&lt;gt;</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i194" class="altColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#neAny(java.lang.Object,java.lang.Object)">neAny</a></span>&#8203;(java.lang.Object&nbsp;b0,
java.lang.Object&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>&lt;gt;</code> operator applied to Object values (at least one
operand has ANY type, including String; neither may be null).</div>
</td>
</tr>
<tr id="i195" class="rowColor">
<td class="colFirst"><code>static java.lang.Boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#not(java.lang.Boolean)">not</a></span>&#8203;(java.lang.Boolean&nbsp;b)</code></th>
<td class="colLast">
<div class="block">NULL &rarr; NULL, FALSE &rarr; TRUE, TRUE &rarr; FALSE.</div>
</td>
</tr>
<tr id="i196" class="altColor">
<td class="colFirst"><code>private static java.lang.RuntimeException</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#notArithmetic(java.lang.String,java.lang.Object,java.lang.Object)">notArithmetic</a></span>&#8203;(java.lang.String&nbsp;op,
java.lang.Object&nbsp;b0,
java.lang.Object&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i197" class="rowColor">
<td class="colFirst"><code>private static java.lang.RuntimeException</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#notComparable(java.lang.String,java.lang.Object,java.lang.Object)">notComparable</a></span>&#8203;(java.lang.String&nbsp;op,
java.lang.Object&nbsp;b0,
java.lang.Object&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i198" class="altColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#overlay(java.lang.String,java.lang.String,int)">overlay</a></span>&#8203;(java.lang.String&nbsp;s,
java.lang.String&nbsp;r,
int&nbsp;start)</code></th>
<td class="colLast">
<div class="block">SQL <code>OVERLAY</code> function.</div>
</td>
</tr>
<tr id="i199" class="rowColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#overlay(java.lang.String,java.lang.String,int,int)">overlay</a></span>&#8203;(java.lang.String&nbsp;s,
java.lang.String&nbsp;r,
int&nbsp;start,
int&nbsp;length)</code></th>
<td class="colLast">
<div class="block">SQL <code>OVERLAY</code> function.</div>
</td>
</tr>
<tr id="i200" class="altColor">
<td class="colFirst"><code>static org.apache.calcite.avatica.util.ByteString</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#overlay(org.apache.calcite.avatica.util.ByteString,org.apache.calcite.avatica.util.ByteString,int)">overlay</a></span>&#8203;(org.apache.calcite.avatica.util.ByteString&nbsp;s,
org.apache.calcite.avatica.util.ByteString&nbsp;r,
int&nbsp;start)</code></th>
<td class="colLast">
<div class="block">SQL <code>OVERLAY</code> function applied to binary strings.</div>
</td>
</tr>
<tr id="i201" class="rowColor">
<td class="colFirst"><code>static org.apache.calcite.avatica.util.ByteString</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#overlay(org.apache.calcite.avatica.util.ByteString,org.apache.calcite.avatica.util.ByteString,int,int)">overlay</a></span>&#8203;(org.apache.calcite.avatica.util.ByteString&nbsp;s,
org.apache.calcite.avatica.util.ByteString&nbsp;r,
int&nbsp;start,
int&nbsp;length)</code></th>
<td class="colLast">
<div class="block">SQL <code>OVERLAY</code> function applied to binary strings.</div>
</td>
</tr>
<tr id="i202" class="altColor">
<td class="colFirst"><code>private static <a href="../linq4j/Enumerable.html" title="interface in org.apache.calcite.linq4j">Enumerable</a>&lt;<a href="FlatLists.ComparableList.html" title="interface in org.apache.calcite.runtime">FlatLists.ComparableList</a>&lt;java.lang.Comparable&gt;&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#p2(java.lang.Object%5B%5D,int%5B%5D,boolean,org.apache.calcite.runtime.SqlFunctions.FlatProductInputType%5B%5D)">p2</a></span>&#8203;(java.lang.Object[]&nbsp;lists,
int[]&nbsp;fieldCounts,
boolean&nbsp;withOrdinality,
<a href="SqlFunctions.FlatProductInputType.html" title="enum in org.apache.calcite.runtime">SqlFunctions.FlatProductInputType</a>[]&nbsp;inputTypes)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i203" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#plus(int,int)">plus</a></span>&#8203;(int&nbsp;b0,
int&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>+</code> operator applied to int values.</div>
</td>
</tr>
<tr id="i204" class="altColor">
<td class="colFirst"><code>static java.lang.Integer</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#plus(int,java.lang.Integer)">plus</a></span>&#8203;(int&nbsp;b0,
java.lang.Integer&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>+</code> operator applied to int values; right side may be
null.</div>
</td>
</tr>
<tr id="i205" class="rowColor">
<td class="colFirst"><code>static java.lang.Integer</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#plus(java.lang.Integer,int)">plus</a></span>&#8203;(java.lang.Integer&nbsp;b0,
int&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>+</code> operator applied to int values; left side may be
null.</div>
</td>
</tr>
<tr id="i206" class="altColor">
<td class="colFirst"><code>static java.lang.Integer</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#plus(java.lang.Integer,java.lang.Integer)">plus</a></span>&#8203;(java.lang.Integer&nbsp;b0,
java.lang.Integer&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>+</code> operator applied to nullable int values.</div>
</td>
</tr>
<tr id="i207" class="rowColor">
<td class="colFirst"><code>static java.lang.Long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#plus(java.lang.Integer,java.lang.Long)">plus</a></span>&#8203;(java.lang.Integer&nbsp;b0,
java.lang.Long&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>+</code> operator applied to nullable int and long values.</div>
</td>
</tr>
<tr id="i208" class="altColor">
<td class="colFirst"><code>static java.lang.Long</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#plus(java.lang.Long,java.lang.Integer)">plus</a></span>&#8203;(java.lang.Long&nbsp;b0,
java.lang.Integer&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>+</code> operator applied to nullable long and int values.</div>
</td>
</tr>
<tr id="i209" class="rowColor">
<td class="colFirst"><code>static java.math.BigDecimal</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#plus(java.math.BigDecimal,java.math.BigDecimal)">plus</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>+</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i210" class="altColor">
<td class="colFirst"><code>static java.lang.Object</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#plusAny(java.lang.Object,java.lang.Object)">plusAny</a></span>&#8203;(java.lang.Object&nbsp;b0,
java.lang.Object&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>+</code> operator applied to Object values (at least one operand
has ANY type; either may be null).</div>
</td>
</tr>
<tr id="i211" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#position(java.lang.String,java.lang.String)">position</a></span>&#8203;(java.lang.String&nbsp;seek,
java.lang.String&nbsp;s)</code></th>
<td class="colLast">
<div class="block">SQL <code>POSITION(seek IN string)</code> function.</div>
</td>
</tr>
<tr id="i212" class="altColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#position(java.lang.String,java.lang.String,int)">position</a></span>&#8203;(java.lang.String&nbsp;seek,
java.lang.String&nbsp;s,
int&nbsp;from)</code></th>
<td class="colLast">
<div class="block">SQL <code>POSITION(seek IN string FROM integer)</code> function.</div>
</td>
</tr>
<tr id="i213" class="rowColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#position(org.apache.calcite.avatica.util.ByteString,org.apache.calcite.avatica.util.ByteString)">position</a></span>&#8203;(org.apache.calcite.avatica.util.ByteString&nbsp;seek,
org.apache.calcite.avatica.util.ByteString&nbsp;s)</code></th>
<td class="colLast">
<div class="block">SQL <code>POSITION(seek IN string)</code> function for byte strings.</div>
</td>
</tr>
<tr id="i214" class="altColor">
<td class="colFirst"><code>static int</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#position(org.apache.calcite.avatica.util.ByteString,org.apache.calcite.avatica.util.ByteString,int)">position</a></span>&#8203;(org.apache.calcite.avatica.util.ByteString&nbsp;seek,
org.apache.calcite.avatica.util.ByteString&nbsp;s,
int&nbsp;from)</code></th>
<td class="colLast">
<div class="block">SQL <code>POSITION(seek IN string FROM integer)</code> function for byte
strings.</div>
</td>
</tr>
<tr id="i215" class="rowColor">
<td class="colFirst"><code>static boolean</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#posixRegex(java.lang.String,java.lang.String,java.lang.Boolean)">posixRegex</a></span>&#8203;(java.lang.String&nbsp;s,
java.lang.String&nbsp;regex,
java.lang.Boolean&nbsp;caseSensitive)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i216" class="altColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#power(double,double)">power</a></span>&#8203;(double&nbsp;b0,
double&nbsp;b1)</code></th>
<td class="colLast">
<div class="block">SQL <code>POWER</code> operator applied to double values.</div>
</td>
</tr>
<tr id="i217" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#power(double,java.math.BigDecimal)">power</a></span>&#8203;(double&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i218" class="altColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#power(java.math.BigDecimal,double)">power</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
double&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i219" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#power(java.math.BigDecimal,java.math.BigDecimal)">power</a></span>&#8203;(java.math.BigDecimal&nbsp;b0,
java.math.BigDecimal&nbsp;b1)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i220" class="altColor">
<td class="colFirst"><code>static &lt;E extends java.lang.Comparable&gt;<br><a href="../linq4j/Enumerable.html" title="interface in org.apache.calcite.linq4j">Enumerable</a>&lt;<a href="FlatLists.ComparableList.html" title="interface in org.apache.calcite.runtime">FlatLists.ComparableList</a>&lt;E&gt;&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#product(java.util.List,int,boolean)">product</a></span>&#8203;(java.util.List&lt;<a href="../linq4j/Enumerator.html" title="interface in org.apache.calcite.linq4j">Enumerator</a>&lt;java.util.List&lt;E&gt;&gt;&gt;&nbsp;enumerators,
int&nbsp;fieldCount,
boolean&nbsp;withOrdinality)</code></th>
<td class="colLast">
<div class="block">Similar to <a href="../linq4j/Linq4j.html#product(java.lang.Iterable)"><code>Linq4j.product(Iterable)</code></a> but each resulting list
implements <a href="FlatLists.ComparableList.html" title="interface in org.apache.calcite.runtime"><code>FlatLists.ComparableList</code></a>.</div>
</td>
</tr>
<tr id="i221" class="rowColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#radians(double)">radians</a></span>&#8203;(double&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>RADIANS</code> operator applied to double values.</div>
</td>
</tr>
<tr id="i222" class="altColor">
<td class="colFirst"><code>static double</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#radians(java.math.BigDecimal)">radians</a></span>&#8203;(java.math.BigDecimal&nbsp;b0)</code></th>
<td class="colLast">
<div class="block">SQL <code>RADIANS</code> operator applied to BigDecimal values.</div>
</td>
</tr>
<tr id="i223" class="rowColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#regexpReplace(java.lang.String,java.lang.String,java.lang.String)">regexpReplace</a></span>&#8203;(java.lang.String&nbsp;s,
java.lang.String&nbsp;regex,
java.lang.String&nbsp;replacement)</code></th>
<td class="colLast">
<div class="block">SQL <code>REGEXP_REPLACE</code> function with 3 arguments.</div>
</td>
</tr>
<tr id="i224" class="altColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#regexpReplace(java.lang.String,java.lang.String,java.lang.String,int)">regexpReplace</a></span>&#8203;(java.lang.String&nbsp;s,
java.lang.String&nbsp;regex,
java.lang.String&nbsp;replacement,
int&nbsp;pos)</code></th>
<td class="colLast">
<div class="block">SQL <code>REGEXP_REPLACE</code> function with 4 arguments.</div>
</td>
</tr>
<tr id="i225" class="rowColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#regexpReplace(java.lang.String,java.lang.String,java.lang.String,int,int)">regexpReplace</a></span>&#8203;(java.lang.String&nbsp;s,
java.lang.String&nbsp;regex,
java.lang.String&nbsp;replacement,
int&nbsp;pos,
int&nbsp;occurrence)</code></th>
<td class="colLast">
<div class="block">SQL <code>REGEXP_REPLACE</code> function with 5 arguments.</div>
</td>
</tr>
<tr id="i226" class="altColor">
<td class="colFirst"><code>static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#regexpReplace(java.lang.String,java.lang.String,java.lang.String,int,int,java.lang.String)">regexpReplace</a></span>&#8203;(java.lang.String&nbsp;s,
java.lang.String&nbsp;regex,
java.lang.String&nbsp;replacement,
int&nbsp;pos,
int&nbsp;occurrence,
java.lang.String&nbsp;matchType)</code></th>
<td class="colLast">
<div