testapidocs/org/apache/calcite/rel/rel2sql/RelToSqlConverterTest.html - calcite-site - Git at Google

 <!DOCTYPE HTML>
 <!-- NewPage -->
 <html lang="en">
 <head>
 <!-- Generated by javadoc -->
 <title>RelToSqlConverterTest (Calcite 1.21.0 Test 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="RelToSqlConverterTest (Calcite 1.21.0 Test API)";
         }
     }
     catch(err) {
     }
 //-->
 var data = {"i0":10,"i1":10,"i2":9,"i3":9,"i4":9,"i5":9,"i6":9,"i7":10,"i8":10,"i9":10,"i10":10,"i11":10,"i12":10,"i13":10,"i14":10,"i15":10,"i16":10,"i17":10,"i18":10,"i19":10,"i20":10,"i21":10,"i22":10,"i23":10,"i24":10,"i25":10,"i26":10,"i27":10,"i28":10,"i29":10,"i30":10,"i31":10,"i32":10,"i33":10,"i34":10,"i35":10,"i36":10,"i37":10,"i38":10,"i39":10,"i40":10,"i41":10,"i42":10,"i43":10,"i44":10,"i45":10,"i46":10,"i47":10,"i48":10,"i49":10,"i50":10,"i51":10,"i52":10,"i53":10,"i54":10,"i55":10,"i56":10,"i57":10,"i58":10,"i59":10,"i60":10,"i61":10,"i62":10,"i63":10,"i64":10,"i65":10,"i66":10,"i67":10,"i68":10,"i69":10,"i70":10,"i71":10,"i72":10,"i73":10,"i74":10,"i75":10,"i76":10,"i77":10,"i78":10,"i79":10,"i80":10,"i81":10,"i82":10,"i83":10,"i84":10,"i85":10,"i86":10,"i87":10,"i88":10,"i89":10,"i90":10,"i91":10,"i92":10,"i93":10,"i94":10,"i95":10,"i96":10,"i97":10,"i98":10,"i99":10,"i100":10,"i101":10,"i102":10,"i103":10,"i104":10,"i105":10,"i106":10,"i107":10,"i108":10,"i109":10,"i110":10,"i111":10,"i112":10,"i113":10,"i114":10,"i115":10,"i116":10,"i117":10,"i118":10,"i119":10,"i120":10,"i121":10,"i122":10,"i123":10,"i124":10,"i125":10,"i126":10,"i127":10,"i128":10,"i129":10,"i130":10,"i131":10,"i132":10,"i133":10,"i134":10,"i135":10,"i136":10,"i137":10,"i138":10,"i139":10,"i140":10,"i141":10,"i142":10,"i143":10,"i144":10,"i145":10,"i146":10,"i147":10,"i148":10,"i149":10,"i150":10,"i151":10,"i152":10,"i153":10,"i154":10,"i155":10,"i156":10,"i157":10,"i158":10,"i159":10,"i160":10,"i161":10,"i162":10,"i163":10,"i164":10,"i165":10,"i166":10,"i167":10,"i168":10,"i169":10,"i170":10,"i171":10,"i172":10,"i173":10,"i174":10,"i175":10,"i176":10,"i177":10,"i178":10,"i179":10,"i180":10,"i181":10,"i182":10,"i183":10,"i184":10,"i185":10,"i186":10,"i187":10,"i188":10,"i189":10,"i190":10,"i191":10,"i192":10,"i193":10,"i194":10,"i195":10,"i196":10,"i197":10,"i198":10,"i199":10,"i200":10,"i201":10,"i202":10,"i203":10,"i204":10,"i205":10,"i206":10,"i207":10,"i208":10,"i209":10,"i210":10,"i211":10,"i212":10,"i213":10,"i214":10,"i215":10,"i216":10,"i217":10,"i218":10,"i219":10,"i220":10,"i221":10,"i222":10,"i223":10,"i224":10,"i225":10,"i226":10,"i227":10,"i228":10,"i229":10,"i230":10,"i231":10,"i232":10,"i233":10,"i234":10,"i235":10,"i236":10,"i237":10,"i238":9};
 var tabs = {65535:["t0","All Methods"],1:["t1","Static Methods"],2:["t2","Instance 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/RelToSqlConverterTest.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.rel.rel2sql</a></div>
 <h2 title="Class RelToSqlConverterTest" class="title">Class RelToSqlConverterTest</h2>
 </div>
 <div class="contentContainer">
 <ul class="inheritance">
 <li>java.lang.Object</li>
 <li>
 <ul class="inheritance">
 <li>org.apache.calcite.rel.rel2sql.RelToSqlConverterTest</li>
 </ul>
 </li>
 </ul>
 <div class="description">
 <ul class="blockList">
 <li class="blockList">
 <hr>
 <pre>public class <span class="typeNameLabel">RelToSqlConverterTest</span>
 extends java.lang.Object</pre>
 <div class="block">Tests for <code>RelToSqlConverter</code>.</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>(package private) static class&nbsp;</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="RelToSqlConverterTest.Sql.html" title="class in org.apache.calcite.rel.rel2sql">RelToSqlConverterTest.Sql</a></span></code></th>
 <td class="colLast">
 <div class="block">Fluid interface to run tests.</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>(package private) static org.apache.calcite.sql2rel.SqlToRelConverter.Config</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#DEFAULT_REL_CONFIG">DEFAULT_REL_CONFIG</a></span></code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr class="rowColor">
 <td class="colFirst"><code>(package private) static org.apache.calcite.sql2rel.SqlToRelConverter.Config</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#NO_EXPAND_CONFIG">NO_EXPAND_CONFIG</a></span></code></th>
 <td class="colLast">&nbsp;</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">Constructor</th>
 <th class="colLast" scope="col">Description</th>
 </tr>
 <tr class="altColor">
 <th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E()">RelToSqlConverterTest</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="t2" class="tableTab"><span><a href="javascript:show(2);">Instance 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>private void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#checkLiteral(java.lang.String)">checkLiteral</a></span>&#8203;(java.lang.String&nbsp;expression)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i1" class="rowColor">
 <td class="colFirst"><code>private void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#checkLiteral2(java.lang.String,java.lang.String)">checkLiteral2</a></span>&#8203;(java.lang.String&nbsp;expression,
              java.lang.String&nbsp;expected)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i2" class="altColor">
 <td class="colFirst"><code>private static java.util.Map&lt;org.apache.calcite.sql.SqlDialect,&#8203;org.apache.calcite.sql.SqlDialect.DatabaseProduct&gt;</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#dialects()">dialects</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Returns a collection of common dialects, and the database products they
  represent.</div>
 </td>
 </tr>
 <tr id="i3" class="rowColor">
 <td class="colFirst"><code>private static org.apache.calcite.tools.Planner</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#getPlanner(java.util.List,org.apache.calcite.sql.parser.SqlParser.Config,org.apache.calcite.schema.SchemaPlus,org.apache.calcite.sql2rel.SqlToRelConverter.Config,org.apache.calcite.tools.Program...)">getPlanner</a></span>&#8203;(java.util.List&lt;org.apache.calcite.plan.RelTraitDef&gt;&nbsp;traitDefs,
           org.apache.calcite.sql.parser.SqlParser.Config&nbsp;parserConfig,
           org.apache.calcite.schema.SchemaPlus&nbsp;schema,
           org.apache.calcite.sql2rel.SqlToRelConverter.Config&nbsp;sqlToRelConf,
           org.apache.calcite.tools.Program...&nbsp;programs)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i4" class="altColor">
 <td class="colFirst"><code>private static org.apache.calcite.sql.dialect.JethroDataSqlDialect</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#jethroDataSqlDialect()">jethroDataSqlDialect</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i5" class="rowColor">
 <td class="colFirst"><code>private static org.apache.calcite.sql.dialect.MysqlSqlDialect</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#mySqlDialect(org.apache.calcite.config.NullCollation)">mySqlDialect</a></span>&#8203;(org.apache.calcite.config.NullCollation&nbsp;nullCollation)</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i6" class="altColor">
 <td class="colFirst"><code>private static org.apache.calcite.tools.RelBuilder</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#relBuilder()">relBuilder</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Creates a RelBuilder.</div>
 </td>
 </tr>
 <tr id="i7" class="rowColor">
 <td class="colFirst"><code>private <a href="RelToSqlConverterTest.Sql.html" title="class in org.apache.calcite.rel.rel2sql">RelToSqlConverterTest.Sql</a></code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#sql(java.lang.String)">sql</a></span>&#8203;(java.lang.String&nbsp;sql)</code></th>
 <td class="colLast">
 <div class="block">Initiates a test case with a given SQL query.</div>
 </td>
 </tr>
 <tr id="i8" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testBigintOracle()">testBigintOracle</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i9" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCartesianProductWithCommaSyntax()">testCartesianProductWithCommaSyntax</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i10" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCartesianProductWithInnerJoinSyntax()">testCartesianProductWithInnerJoinSyntax</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i11" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCastDecimal1()">testCastDecimal1</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i12" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCastLongVarchar1()">testCastLongVarchar1</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-2713">[CALCITE-2713]
  JDBC adapter may generate casts on PostgreSQL for VARCHAR type exceeding
  max length</a>.</div>
 </td>
 </tr>
 <tr id="i13" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCastLongVarchar2()">testCastLongVarchar2</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-2713">[CALCITE-2713]
  JDBC adapter may generate casts on PostgreSQL for VARCHAR type exceeding
  max length</a>.</div>
 </td>
 </tr>
 <tr id="i14" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCharLiteralForBigQuery()">testCharLiteralForBigQuery</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Tests that we escape single-quotes in character literals using back-slash
  in BigQuery.</div>
 </td>
 </tr>
 <tr id="i15" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCorrelate()">testCorrelate</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i16" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCrossJoinEmulationForSpark()">testCrossJoinEmulationForSpark</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i17" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCubeInSpark()">testCubeInSpark</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i18" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testDateLiteralOracle()">testDateLiteralOracle</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i19" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testDb2DialectCast()">testDb2DialectCast</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i20" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testDb2DialectJoin()">testDb2DialectJoin</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i21" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testDb2DialectJoinStar()">testDb2DialectJoinStar</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1332">[CALCITE-1332]
  DB2 should always use aliases for tables: x.y.z AS z</a>.</div>
 </td>
 </tr>
 <tr id="i22" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testDb2DialectJoinWhere()">testDb2DialectJoinWhere</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i23" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testDb2DialectSelectQueryComplex()">testDb2DialectSelectQueryComplex</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i24" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testDb2DialectSelectQueryWithGroup()">testDb2DialectSelectQueryWithGroup</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i25" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testDb2DialectSelectQueryWithGroupByHaving()">testDb2DialectSelectQueryWithGroupByHaving</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i26" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testDb2DialectSelfJoin()">testDb2DialectSelfJoin</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i27" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testDb2DialectSelfJoinStar()">testDb2DialectSelfJoinStar</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i28" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testDb2DialectSelfJoinWhere()">testDb2DialectSelfJoinWhere</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i29" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testDb2DialectWhere()">testDb2DialectWhere</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i30" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testDialectQuoteStringLiteral()">testDialectQuoteStringLiteral</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i31" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testDoubleOracle()">testDoubleOracle</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i32" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testExceptOperatorForBigQuery()">testExceptOperatorForBigQuery</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i33" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testExistsWithExpand()">testExistsWithExpand</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1849">[CALCITE-1849]
  Support sub-queries (RexSubQuery) in RelToSqlConverter</a>.</div>
 </td>
 </tr>
 <tr id="i34" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testFieldNamesWithAggregateSubQuery()">testFieldNamesWithAggregateSubQuery</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i35" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testFloor()">testFloor</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1798">[CALCITE-1798]
  Generate dialect-specific SQL for FLOOR operator</a>.</div>
 </td>
 </tr>
 <tr id="i36" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testFloorInSpark()">testFloorInSpark</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i37" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testFloorMssqlMonth()">testFloorMssqlMonth</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i38" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testFloorMssqlWeek()">testFloorMssqlWeek</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i39" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testFloorMysqlHour()">testFloorMysqlHour</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i40" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testFloorMysqlMinute()">testFloorMysqlMinute</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i41" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testFloorMysqlMonth()">testFloorMysqlMonth</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i42" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testFloorMysqlSecond()">testFloorMysqlSecond</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i43" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testFloorMysqlWeek()">testFloorMysqlWeek</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i44" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testFloorOracle()">testFloorOracle</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i45" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testFloorPostgres()">testFloorPostgres</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i46" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testFloorWithGroupBy()">testFloorWithGroupBy</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1826">[CALCITE-1826]
  JDBC dialect-specific FLOOR fails when in GROUP BY</a>.</div>
 </td>
 </tr>
 <tr id="i47" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testFullJoinOnTrueCondition()">testFullJoinOnTrueCondition</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i48" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testGroupByGroupingSets()">testGroupByGroupingSets</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-3097">[CALCITE-3097]
  GROUPING SETS breaks on sets of size &gt; 1 due to precedence issues</a>,
  in particular, that we maintain proper precedence around nested lists.</div>
 </td>
 </tr>
 <tr id="i49" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testHaving4()">testHaving4</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i50" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testHiveSelectCharset()">testHiveSelectCharset</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i51" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testHiveSelectQueryWithOrderByAscAndNullsLastShouldBeEmulated()">testHiveSelectQueryWithOrderByAscAndNullsLastShouldBeEmulated</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i52" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testHiveSelectQueryWithOrderByAscNullsFirstShouldNotAddNullEmulation()">testHiveSelectQueryWithOrderByAscNullsFirstShouldNotAddNullEmulation</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i53" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testHiveSelectQueryWithOrderByDescAndHighNullsWithVersion20()">testHiveSelectQueryWithOrderByDescAndHighNullsWithVersion20</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i54" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testHiveSelectQueryWithOrderByDescAndHighNullsWithVersionGreaterThanOrEq21()">testHiveSelectQueryWithOrderByDescAndHighNullsWithVersionGreaterThanOrEq21</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i55" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testHiveSelectQueryWithOrderByDescAndNullsFirstShouldBeEmulated()">testHiveSelectQueryWithOrderByDescAndNullsFirstShouldBeEmulated</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i56" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testHiveSelectQueryWithOrderByDescNullsLastShouldNotAddNullEmulation()">testHiveSelectQueryWithOrderByDescNullsLastShouldNotAddNullEmulation</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i57" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testHiveTrim()">testHiveTrim</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-3220">[CALCITE-3220]
  HiveSqlDialect should transform the SQL-standard TRIM function to TRIM,
  LTRIM or RTRIM</a>.</div>
 </td>
 </tr>
 <tr id="i58" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testHiveTrimWithBoth()">testHiveTrimWithBoth</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i59" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testHiveTrimWithLeading()">testHiveTrimWithLeading</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i60" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testHiveTrimWithTailing()">testHiveTrimWithTailing</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i61" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testIdentifier()">testIdentifier</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i62" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testIntersectOperatorForBigQuery()">testIntersectOperatorForBigQuery</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i63" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJethroDataSelectQueryWithOrderByDescAndNullsFirstShouldBeEmulated()">testJethroDataSelectQueryWithOrderByDescAndNullsFirstShouldBeEmulated</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i64" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJoinOnBoolean()">testJoinOnBoolean</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-2652">[CALCITE-2652]
  SqlNode to SQL conversion fails if the join condition references a BOOLEAN
  column</a>.</div>
 </td>
 </tr>
 <tr id="i65" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJoinPlan2()">testJoinPlan2</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1372">[CALCITE-1372]
  JDBC adapter generates SQL with wrong field names</a>.</div>
 </td>
 </tr>
 <tr id="i66" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJoinWithLikeConditionRel2Sql()">testJoinWithLikeConditionRel2Sql</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-3207">[CALCITE-3207]
  Fail to convert Join RelNode with like condition to sql statement </a>.</div>
 </td>
 </tr>
 <tr id="i67" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonArray()">testJsonArray</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i68" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonArrayAgg()">testJsonArrayAgg</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i69" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonDepth()">testJsonDepth</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i70" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonExists()">testJsonExists</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i71" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonKeys()">testJsonKeys</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i72" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonLength()">testJsonLength</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i73" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonObject()">testJsonObject</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i74" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonObjectAgg()">testJsonObjectAgg</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i75" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonPredicate()">testJsonPredicate</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i76" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonPretty()">testJsonPretty</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i77" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonQuery()">testJsonQuery</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i78" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonRemove()">testJsonRemove</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i79" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonStorageSize()">testJsonStorageSize</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i80" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonType()">testJsonType</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i81" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonValue()">testJsonValue</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i82" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonValueExpressionOperator()">testJsonValueExpressionOperator</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i83" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testLagFunctionForPrintingOfFrameBoundary()">testLagFunctionForPrintingOfFrameBoundary</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i84" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testLeadFunctionForPrintingOfFrameBoundary()">testLeadFunctionForPrintingOfFrameBoundary</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i85" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testLike()">testLike</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i86" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testLiteral()">testLiteral</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i87" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeDefineClause()">testMatchRecognizeDefineClause</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i88" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeDefineClause2()">testMatchRecognizeDefineClause2</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i89" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeDefineClause3()">testMatchRecognizeDefineClause3</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i90" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeDefineClause4()">testMatchRecognizeDefineClause4</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i91" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeIn()">testMatchRecognizeIn</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i92" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeMeasures1()">testMatchRecognizeMeasures1</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i93" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeMeasures2()">testMatchRecognizeMeasures2</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i94" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeMeasures3()">testMatchRecognizeMeasures3</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i95" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeMeasures4()">testMatchRecognizeMeasures4</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i96" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeMeasures5()">testMatchRecognizeMeasures5</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i97" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeMeasures6()">testMatchRecognizeMeasures6</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i98" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeMeasures7()">testMatchRecognizeMeasures7</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i99" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternExpression()">testMatchRecognizePatternExpression</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i100" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternExpression10()">testMatchRecognizePatternExpression10</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i101" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternExpression11()">testMatchRecognizePatternExpression11</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i102" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternExpression12()">testMatchRecognizePatternExpression12</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i103" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternExpression13()">testMatchRecognizePatternExpression13</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i104" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternExpression2()">testMatchRecognizePatternExpression2</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i105" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternExpression3()">testMatchRecognizePatternExpression3</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i106" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternExpression4()">testMatchRecognizePatternExpression4</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i107" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternExpression5()">testMatchRecognizePatternExpression5</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i108" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternExpression6()">testMatchRecognizePatternExpression6</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i109" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternExpression7()">testMatchRecognizePatternExpression7</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i110" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternExpression8()">testMatchRecognizePatternExpression8</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i111" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternExpression9()">testMatchRecognizePatternExpression9</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i112" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternSkip1()">testMatchRecognizePatternSkip1</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i113" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternSkip2()">testMatchRecognizePatternSkip2</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i114" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternSkip3()">testMatchRecognizePatternSkip3</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i115" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternSkip4()">testMatchRecognizePatternSkip4</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i116" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizePatternSkip5()">testMatchRecognizePatternSkip5</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i117" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeRowsPerMatch1()">testMatchRecognizeRowsPerMatch1</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i118" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeRowsPerMatch2()">testMatchRecognizeRowsPerMatch2</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i119" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeSubset1()">testMatchRecognizeSubset1</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i120" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeSubset2()">testMatchRecognizeSubset2</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i121" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeSubset3()">testMatchRecognizeSubset3</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i122" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeSubset4()">testMatchRecognizeSubset4</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i123" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMatchRecognizeWithin()">testMatchRecognizeWithin</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i124" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testModFunctionForHive()">testModFunctionForHive</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i125" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMssqlCharacterSet()">testMssqlCharacterSet</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-2715">[CALCITE-2715]
  MS SQL Server does not support character set as part of data type</a>.</div>
 </td>
 </tr>
 <tr id="i126" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMysqlCastToBigint()">testMysqlCastToBigint</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i127" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMysqlCastToInteger()">testMysqlCastToInteger</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i128" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMySqlSelectQueryWithOrderByAscAndNullsLastShouldBeEmulated()">testMySqlSelectQueryWithOrderByAscAndNullsLastShouldBeEmulated</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i129" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMySqlSelectQueryWithOrderByAscNullsFirstShouldNotAddNullEmulation()">testMySqlSelectQueryWithOrderByAscNullsFirstShouldNotAddNullEmulation</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i130" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMySqlSelectQueryWithOrderByDescAndNullsFirstShouldBeEmulated()">testMySqlSelectQueryWithOrderByDescAndNullsFirstShouldBeEmulated</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i131" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMySqlSelectQueryWithOrderByDescNullsLastShouldNotAddNullEmulation()">testMySqlSelectQueryWithOrderByDescNullsLastShouldNotAddNullEmulation</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i132" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMySqlWithFirstNullsSelectWithOrderByAscAndNullsFirstShouldNotBeEmulated()">testMySqlWithFirstNullsSelectWithOrderByAscAndNullsFirstShouldNotBeEmulated</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i133" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMySqlWithFirstNullsSelectWithOrderByAscAndNullsLastShouldBeEmulated()">testMySqlWithFirstNullsSelectWithOrderByAscAndNullsLastShouldBeEmulated</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i134" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMySqlWithFirstNullsSelectWithOrderByDescAndNullsFirstShouldNotBeEmulated()">testMySqlWithFirstNullsSelectWithOrderByDescAndNullsFirstShouldNotBeEmulated</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i135" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMySqlWithFirstNullsSelectWithOrderByDescAndNullsLastShouldBeEmulated()">testMySqlWithFirstNullsSelectWithOrderByDescAndNullsLastShouldBeEmulated</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i136" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMySqlWithHighNullsSelectWithOrderByAscNullsFirstAndNullEmulation()">testMySqlWithHighNullsSelectWithOrderByAscNullsFirstAndNullEmulation</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i137" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMySqlWithHighNullsSelectWithOrderByAscNullsLastAndNoEmulation()">testMySqlWithHighNullsSelectWithOrderByAscNullsLastAndNoEmulation</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i138" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMySqlWithHighNullsSelectWithOrderByDescNullsFirstAndNoEmulation()">testMySqlWithHighNullsSelectWithOrderByDescNullsFirstAndNoEmulation</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i139" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMySqlWithHighNullsSelectWithOrderByDescNullsLastAndNullEmulation()">testMySqlWithHighNullsSelectWithOrderByDescNullsLastAndNullEmulation</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i140" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMySqlWithLastNullsSelectWithOrderByAscAndNullsFirstShouldBeEmulated()">testMySqlWithLastNullsSelectWithOrderByAscAndNullsFirstShouldBeEmulated</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i141" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMySqlWithLastNullsSelectWithOrderByAscAndNullsLastShouldNotBeEmulated()">testMySqlWithLastNullsSelectWithOrderByAscAndNullsLastShouldNotBeEmulated</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i142" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMySqlWithLastNullsSelectWithOrderByDescAndNullsFirstShouldBeEmulated()">testMySqlWithLastNullsSelectWithOrderByDescAndNullsFirstShouldBeEmulated</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i143" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testMySqlWithLastNullsSelectWithOrderByDescAndNullsLastShouldNotBeEmulated()">testMySqlWithLastNullsSelectWithOrderByDescAndNullsLastShouldNotBeEmulated</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i144" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testNestedAggregates()">testNestedAggregates</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1946">[CALCITE-1946]
  JDBC adapter should generate sub-SELECT if dialect does not support nested
  aggregate functions</a>.</div>
 </td>
 </tr>
 <tr id="i145" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testNestedAggregatesMySqlStar()">testNestedAggregatesMySqlStar</a></span>()</code></th>
 <td class="colLast">
 <div class="block">As <a href="#testNestedAggregatesMySqlTable()"><code>testNestedAggregatesMySqlTable()</code></a>, but input is a sub-query,
  not a table.</div>
 </td>
 </tr>
 <tr id="i146" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testNestedAggregatesMySqlTable()">testNestedAggregatesMySqlTable</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-2628">[CALCITE-2628]
  JDBC adapter throws NullPointerException while generating GROUP BY query
  for MySQL</a>.</div>
 </td>
 </tr>
 <tr id="i147" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testNotExistsWithExpand()">testNotExistsWithExpand</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i148" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testNotLike()">testNotLike</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i149" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testNumericFloorInSpark()">testNumericFloorInSpark</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i150" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testPositionFunctionForBigQuery()">testPositionFunctionForBigQuery</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i151" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testPositionFunctionForHive()">testPositionFunctionForHive</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i152" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testPreserveAlias()">testPreserveAlias</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-2118">[CALCITE-2118]
  RelToSqlConverter should only generate "*" if field names match</a>.</div>
 </td>
 </tr>
 <tr id="i153" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testPreservePermutation()">testPreservePermutation</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i154" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testRankFunctionForPrintingOfFrameBoundary()">testRankFunctionForPrintingOfFrameBoundary</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i155" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testRollupInSpark()">testRollupInSpark</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i156" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testRowNumberFunctionForPrintingOfFrameBoundary()">testRowNumberFunctionForPrintingOfFrameBoundary</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-2625">[CALCITE-2625]
  Removing Window Boundaries from SqlWindow of Aggregate Function which do not allow Framing</a></div>
 </td>
 </tr>
 <tr id="i157" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectNull()">testSelectNull</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i158" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectNullWithCount()">testSelectNullWithCount</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i159" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectNullWithGroupByNull()">testSelectNullWithGroupByNull</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i160" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectNullWithGroupByVar()">testSelectNullWithGroupByVar</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i161" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectNullWithInsert()">testSelectNullWithInsert</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i162" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectNullWithInsertFromJoin()">testSelectNullWithInsertFromJoin</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i163" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryComplex()">testSelectQueryComplex</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i164" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithAscDescOrderByClause()">testSelectQueryWithAscDescOrderByClause</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i165" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithCubeLimit()">testSelectQueryWithCubeLimit</a></span>()</code></th>
 <td class="colLast">
 <div class="block">As <a href="#testSelectQueryWithSingletonCube()"><code>testSelectQueryWithSingletonCube()</code></a>, but with LIMIT.</div>
 </td>
 </tr>
 <tr id="i166" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithFetchOffsetClause()">testSelectQueryWithFetchOffsetClause</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i167" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithGroup()">testSelectQueryWithGroup</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i168" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithGroupBy()">testSelectQueryWithGroupBy</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i169" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithGroupByAndProjectList()">testSelectQueryWithGroupByAndProjectList</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i170" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithGroupByAndProjectList1()">testSelectQueryWithGroupByAndProjectList1</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i171" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithGroupByEmpty()">testSelectQueryWithGroupByEmpty</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i172" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithGroupByEmpty2()">testSelectQueryWithGroupByEmpty2</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i173" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithGroupByHaving()">testSelectQueryWithGroupByHaving</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i174" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithGroupByHaving2()">testSelectQueryWithGroupByHaving2</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1665">[CALCITE-1665]
  Aggregates and having cannot be combined</a>.</div>
 </td>
 </tr>
 <tr id="i175" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithGroupByHaving3()">testSelectQueryWithGroupByHaving3</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1665">[CALCITE-1665]
  Aggregates and having cannot be combined</a>.</div>
 </td>
 </tr>
 <tr id="i176" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithGroupByRollup()">testSelectQueryWithGroupByRollup</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Tests GROUP BY ROLLUP of two columns.</div>
 </td>
 </tr>
 <tr id="i177" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithGroupByRollup2()">testSelectQueryWithGroupByRollup2</a></span>()</code></th>
 <td class="colLast">
 <div class="block">As <a href="#testSelectQueryWithGroupByRollup()"><code>testSelectQueryWithGroupByRollup()</code></a>,
  but ORDER BY columns reversed.</div>
 </td>
 </tr>
 <tr id="i178" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithLimitClause()">testSelectQueryWithLimitClause</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i179" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithLimitClauseWithoutOrder()">testSelectQueryWithLimitClauseWithoutOrder</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i180" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithLimitOffsetClause()">testSelectQueryWithLimitOffsetClause</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i181" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithMinAggregateFunction()">testSelectQueryWithMinAggregateFunction</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i182" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithMinAggregateFunction1()">testSelectQueryWithMinAggregateFunction1</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i183" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithMultipleAggregateFunction()">testSelectQueryWithMultipleAggregateFunction</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i184" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithMultipleAggregateFunction1()">testSelectQueryWithMultipleAggregateFunction1</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i185" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithOrderByClause()">testSelectQueryWithOrderByClause</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i186" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithOrderByClause1()">testSelectQueryWithOrderByClause1</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i187" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithParameters()">testSelectQueryWithParameters</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i188" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithRollupOrderByCount()">testSelectQueryWithRollupOrderByCount</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Cannot rewrite if ORDER BY contains a column not in GROUP BY (in this
  case COUNT(*)).</div>
 </td>
 </tr>
 <tr id="i189" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithSingletonCube()">testSelectQueryWithSingletonCube</a></span>()</code></th>
 <td class="colLast">
 <div class="block">CUBE of one column is equivalent to ROLLUP, and Calcite recognizes
  this.</div>
 </td>
 </tr>
 <tr id="i190" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithSingletonCubeNoOrderBy()">testSelectQueryWithSingletonCubeNoOrderBy</a></span>()</code></th>
 <td class="colLast">
 <div class="block">As <a href="#testSelectQueryWithSingletonCube()"><code>testSelectQueryWithSingletonCube()</code></a>, but no ORDER BY
  clause.</div>
 </td>
 </tr>
 <tr id="i191" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithSumAggregateFunction()">testSelectQueryWithSumAggregateFunction</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i192" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithTwoOrderByClause()">testSelectQueryWithTwoOrderByClause</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i193" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithWhereClauseOfBasicOperators()">testSelectQueryWithWhereClauseOfBasicOperators</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i194" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSelectQueryWithWhereClauseOfLessThan()">testSelectQueryWithWhereClauseOfLessThan</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i195" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSimpleIn()">testSimpleIn</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i196" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSimpleJoin()">testSimpleJoin</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i197" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSimpleJoinConditionWithIsNullOperators()">testSimpleJoinConditionWithIsNullOperators</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1422">[CALCITE-1422]
  In JDBC adapter, allow IS NULL and IS NOT NULL operators in generated SQL
  join condition</a>.</div>
 </td>
 </tr>
 <tr id="i198" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSimpleJoinUsing()">testSimpleJoinUsing</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i199" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSimpleSelectQueryFromProductTable()">testSimpleSelectQueryFromProductTable</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i200" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSimpleSelectStarFromProductTable()">testSimpleSelectStarFromProductTable</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i201" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSmallintOracle()">testSmallintOracle</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i202" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testStack()">testStack</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-2722">[CALCITE-2722]
  SqlImplementor createLeftCall method throws StackOverflowError</a>.</div>
 </td>
 </tr>
 <tr id="i203" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSubQueryAlias()">testSubQueryAlias</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1636">[CALCITE-1636]
  JDBC adapter generates wrong SQL for self join with sub-query</a>.</div>
 </td>
 </tr>
 <tr id="i204" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSubQueryInWithExpand()">testSubQueryInWithExpand</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i205" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSubQueryInWithExpand2()">testSubQueryInWithExpand2</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i206" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSubQueryNotInWithExpand()">testSubQueryNotInWithExpand</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i207" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSubstring()">testSubstring</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i208" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSubstringInSpark()">testSubstringInSpark</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i209" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSubstringWithFor()">testSubstringWithFor</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i210" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSubstringWithForInSpark()">testSubstringWithForInSpark</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i211" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSum0BecomesCoalesce()">testSum0BecomesCoalesce</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1174">[CALCITE-1174]
  When generating SQL, translate SUM0(x) to COALESCE(SUM(x), 0)</a>.</div>
 </td>
 </tr>
 <tr id="i212" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSupportsDataType()">testSupportsDataType</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i213" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testThreeQueryUnion()">testThreeQueryUnion</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1586">[CALCITE-1586]
  JDBC adapter generates wrong SQL if UNION has more than two inputs</a>.</div>
 </td>
 </tr>
 <tr id="i214" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testTimeLiteralOracle()">testTimeLiteralOracle</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i215" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testTimestampLiteralOracle()">testTimestampLiteralOracle</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i216" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testUncollectExplicitAlias()">testUncollectExplicitAlias</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i217" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testUncollectImplicitAlias()">testUncollectImplicitAlias</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i218" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testUnionAllWithNoOperands()">testUnionAllWithNoOperands</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i219" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testUnionAllWithNoOperandsUsingOracleDialect()">testUnionAllWithNoOperandsUsingOracleDialect</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i220" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testUnionOperatorForBigQuery()">testUnionOperatorForBigQuery</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i221" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testUnionWrappedInASelect()">testUnionWrappedInASelect</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1800">[CALCITE-1800]
  JDBC adapter fails to SELECT FROM a UNION query</a>.</div>
 </td>
 </tr>
 <tr id="i222" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testUnparseIn1()">testUnparseIn1</a></span>()</code></th>
 <td class="colLast">
 <div class="block">Tests that IN can be un-parsed.</div>
 </td>
 </tr>
 <tr id="i223" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testUnparseIn2()">testUnparseIn2</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i224" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testUnparseInStruct1()">testUnparseInStruct1</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i225" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testUnparseInStruct2()">testUnparseInStruct2</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i226" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testUnparseSelectMustUseDialect()">testUnparseSelectMustUseDialect</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i227" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testUnparseSqlIntervalQualifierDb2()">testUnparseSqlIntervalQualifierDb2</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i228" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testUnparseSqlIntervalQualifierMsSql()">testUnparseSqlIntervalQualifierMsSql</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i229" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testUnparseSqlIntervalQualifierMySql()">testUnparseSqlIntervalQualifierMySql</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i230" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testValues()">testValues</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i231" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testValuesEmpty()">testValuesEmpty</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i232" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testWindowedSum0BecomesCoalesce()">testWindowedSum0BecomesCoalesce</a></span>()</code></th>
 <td class="colLast">
 <div class="block">As <a href="#testSum0BecomesCoalesce()"><code>testSum0BecomesCoalesce()</code></a> but for windowed aggregates.</div>
 </td>
 </tr>
 <tr id="i233" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testWithinGroup1()">testWithinGroup1</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i234" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testWithinGroup2()">testWithinGroup2</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i235" class="rowColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testWithinGroup3()">testWithinGroup3</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i236" class="altColor">
 <td class="colFirst"><code>void</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testWithinGroup4()">testWithinGroup4</a></span>()</code></th>
 <td class="colLast">&nbsp;</td>
 </tr>
 <tr id="i237" class="rowColor">
 <td class="colFirst"><code>private java.lang.String</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#toSql(org.apache.calcite.rel.RelNode)">toSql</a></span>&#8203;(org.apache.calcite.rel.RelNode&nbsp;root)</code></th>
 <td class="colLast">
 <div class="block">Converts a relational expression to SQL.</div>
 </td>
 </tr>
 <tr id="i238" class="altColor">
 <td class="colFirst"><code>private static java.lang.String</code></td>
 <th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#toSql(org.apache.calcite.rel.RelNode,org.apache.calcite.sql.SqlDialect)">toSql</a></span>&#8203;(org.apache.calcite.rel.RelNode&nbsp;root,
      org.apache.calcite.sql.SqlDialect&nbsp;dialect)</code></th>
 <td class="colLast">
 <div class="block">Converts a relational expression to SQL in a given dialect.</div>
 </td>
 </tr>
 </table>
 <ul class="blockList">
 <li class="blockList"><a id="methods.inherited.from.class.java.lang.Object">
 <!--   -->
 </a>
 <h3>Methods inherited from class&nbsp;java.lang.Object</h3>
 <code>clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</code></li>
 </ul>
 </li>
 </ul>
 </section>
 </li>
 </ul>
 </div>
 <div class="details">
 <ul class="blockList">
 <li class="blockList">
 <!-- ============ FIELD DETAIL =========== -->
 <section role="region">
 <ul class="blockList">
 <li class="blockList"><a id="field.detail">
 <!--   -->
 </a>
 <h3>Field Detail</h3>
 <a id="DEFAULT_REL_CONFIG">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>DEFAULT_REL_CONFIG</h4>
 <pre>static final&nbsp;org.apache.calcite.sql2rel.SqlToRelConverter.Config DEFAULT_REL_CONFIG</pre>
 </li>
 </ul>
 <a id="NO_EXPAND_CONFIG">
 <!--   -->
 </a>
 <ul class="blockListLast">
 <li class="blockList">
 <h4>NO_EXPAND_CONFIG</h4>
 <pre>static final&nbsp;org.apache.calcite.sql2rel.SqlToRelConverter.Config NO_EXPAND_CONFIG</pre>
 </li>
 </ul>
 </li>
 </ul>
 </section>
 <!-- ========= CONSTRUCTOR DETAIL ======== -->
 <section role="region">
 <ul class="blockList">
 <li class="blockList"><a id="constructor.detail">
 <!--   -->
 </a>
 <h3>Constructor Detail</h3>
 <a id="&lt;init&gt;()">
 <!--   -->
 </a>
 <ul class="blockListLast">
 <li class="blockList">
 <h4>RelToSqlConverterTest</h4>
 <pre>public&nbsp;RelToSqlConverterTest()</pre>
 </li>
 </ul>
 </li>
 </ul>
 </section>
 <!-- ============ METHOD DETAIL ========== -->
 <section role="region">
 <ul class="blockList">
 <li class="blockList"><a id="method.detail">
 <!--   -->
 </a>
 <h3>Method Detail</h3>
 <a id="sql(java.lang.String)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>sql</h4>
 <pre class="methodSignature">private&nbsp;<a href="RelToSqlConverterTest.Sql.html" title="class in org.apache.calcite.rel.rel2sql">RelToSqlConverterTest.Sql</a>&nbsp;sql&#8203;(java.lang.String&nbsp;sql)</pre>
 <div class="block">Initiates a test case with a given SQL query.</div>
 </li>
 </ul>
 <a id="getPlanner(java.util.List,org.apache.calcite.sql.parser.SqlParser.Config,org.apache.calcite.schema.SchemaPlus,org.apache.calcite.sql2rel.SqlToRelConverter.Config,org.apache.calcite.tools.Program...)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>getPlanner</h4>
 <pre class="methodSignature">private static&nbsp;org.apache.calcite.tools.Planner&nbsp;getPlanner&#8203;(java.util.List&lt;org.apache.calcite.plan.RelTraitDef&gt;&nbsp;traitDefs,
                                                            org.apache.calcite.sql.parser.SqlParser.Config&nbsp;parserConfig,
                                                            org.apache.calcite.schema.SchemaPlus&nbsp;schema,
                                                            org.apache.calcite.sql2rel.SqlToRelConverter.Config&nbsp;sqlToRelConf,
                                                            org.apache.calcite.tools.Program...&nbsp;programs)</pre>
 </li>
 </ul>
 <a id="jethroDataSqlDialect()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>jethroDataSqlDialect</h4>
 <pre class="methodSignature">private static&nbsp;org.apache.calcite.sql.dialect.JethroDataSqlDialect&nbsp;jethroDataSqlDialect()</pre>
 </li>
 </ul>
 <a id="mySqlDialect(org.apache.calcite.config.NullCollation)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>mySqlDialect</h4>
 <pre class="methodSignature">private static&nbsp;org.apache.calcite.sql.dialect.MysqlSqlDialect&nbsp;mySqlDialect&#8203;(org.apache.calcite.config.NullCollation&nbsp;nullCollation)</pre>
 </li>
 </ul>
 <a id="dialects()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>dialects</h4>
 <pre class="methodSignature">private static&nbsp;java.util.Map&lt;org.apache.calcite.sql.SqlDialect,&#8203;org.apache.calcite.sql.SqlDialect.DatabaseProduct&gt;&nbsp;dialects()</pre>
 <div class="block">Returns a collection of common dialects, and the database products they
  represent.</div>
 </li>
 </ul>
 <a id="relBuilder()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>relBuilder</h4>
 <pre class="methodSignature">private static&nbsp;org.apache.calcite.tools.RelBuilder&nbsp;relBuilder()</pre>
 <div class="block">Creates a RelBuilder.</div>
 </li>
 </ul>
 <a id="toSql(org.apache.calcite.rel.RelNode)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>toSql</h4>
 <pre class="methodSignature">private&nbsp;java.lang.String&nbsp;toSql&#8203;(org.apache.calcite.rel.RelNode&nbsp;root)</pre>
 <div class="block">Converts a relational expression to SQL.</div>
 </li>
 </ul>
 <a id="toSql(org.apache.calcite.rel.RelNode,org.apache.calcite.sql.SqlDialect)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>toSql</h4>
 <pre class="methodSignature">private static&nbsp;java.lang.String&nbsp;toSql&#8203;(org.apache.calcite.rel.RelNode&nbsp;root,
                                       org.apache.calcite.sql.SqlDialect&nbsp;dialect)</pre>
 <div class="block">Converts a relational expression to SQL in a given dialect.</div>
 </li>
 </ul>
 <a id="testSimpleSelectStarFromProductTable()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSimpleSelectStarFromProductTable</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSimpleSelectStarFromProductTable()</pre>
 </li>
 </ul>
 <a id="testSimpleSelectQueryFromProductTable()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSimpleSelectQueryFromProductTable</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSimpleSelectQueryFromProductTable()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithWhereClauseOfLessThan()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithWhereClauseOfLessThan</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithWhereClauseOfLessThan()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithWhereClauseOfBasicOperators()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithWhereClauseOfBasicOperators</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithWhereClauseOfBasicOperators()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithGroupBy()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithGroupBy</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithGroupBy()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithGroupByEmpty()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithGroupByEmpty</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithGroupByEmpty()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithGroupByEmpty2()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithGroupByEmpty2</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithGroupByEmpty2()</pre>
 </li>
 </ul>
 <a id="testGroupByGroupingSets()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testGroupByGroupingSets</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testGroupByGroupingSets()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-3097">[CALCITE-3097]
  GROUPING SETS breaks on sets of size &gt; 1 due to precedence issues</a>,
  in particular, that we maintain proper precedence around nested lists.</div>
 </li>
 </ul>
 <a id="testSelectQueryWithGroupByRollup()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithGroupByRollup</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithGroupByRollup()</pre>
 <div class="block">Tests GROUP BY ROLLUP of two columns. The SQL for MySQL has
  "GROUP BY ... ROLLUP" but no "ORDER BY".</div>
 </li>
 </ul>
 <a id="testSelectQueryWithGroupByRollup2()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithGroupByRollup2</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithGroupByRollup2()</pre>
 <div class="block">As <a href="#testSelectQueryWithGroupByRollup()"><code>testSelectQueryWithGroupByRollup()</code></a>,
  but ORDER BY columns reversed.</div>
 </li>
 </ul>
 <a id="testSelectQueryWithSingletonCube()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithSingletonCube</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithSingletonCube()</pre>
 <div class="block">CUBE of one column is equivalent to ROLLUP, and Calcite recognizes
  this.</div>
 </li>
 </ul>
 <a id="testSelectQueryWithSingletonCubeNoOrderBy()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithSingletonCubeNoOrderBy</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithSingletonCubeNoOrderBy()</pre>
 <div class="block">As <a href="#testSelectQueryWithSingletonCube()"><code>testSelectQueryWithSingletonCube()</code></a>, but no ORDER BY
  clause.</div>
 </li>
 </ul>
 <a id="testSelectQueryWithRollupOrderByCount()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithRollupOrderByCount</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithRollupOrderByCount()</pre>
 <div class="block">Cannot rewrite if ORDER BY contains a column not in GROUP BY (in this
  case COUNT(*)).</div>
 </li>
 </ul>
 <a id="testSelectQueryWithCubeLimit()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithCubeLimit</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithCubeLimit()</pre>
 <div class="block">As <a href="#testSelectQueryWithSingletonCube()"><code>testSelectQueryWithSingletonCube()</code></a>, but with LIMIT.</div>
 </li>
 </ul>
 <a id="testSelectQueryWithMinAggregateFunction()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithMinAggregateFunction</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithMinAggregateFunction()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithMinAggregateFunction1()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithMinAggregateFunction1</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithMinAggregateFunction1()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithSumAggregateFunction()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithSumAggregateFunction</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithSumAggregateFunction()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithMultipleAggregateFunction()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithMultipleAggregateFunction</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithMultipleAggregateFunction()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithMultipleAggregateFunction1()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithMultipleAggregateFunction1</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithMultipleAggregateFunction1()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithGroupByAndProjectList()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithGroupByAndProjectList</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithGroupByAndProjectList()</pre>
 </li>
 </ul>
 <a id="testCastDecimal1()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testCastDecimal1</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testCastDecimal1()</pre>
 </li>
 </ul>
 <a id="testCastLongVarchar1()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testCastLongVarchar1</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testCastLongVarchar1()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-2713">[CALCITE-2713]
  JDBC adapter may generate casts on PostgreSQL for VARCHAR type exceeding
  max length</a>.</div>
 </li>
 </ul>
 <a id="testCastLongVarchar2()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testCastLongVarchar2</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testCastLongVarchar2()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-2713">[CALCITE-2713]
  JDBC adapter may generate casts on PostgreSQL for VARCHAR type exceeding
  max length</a>.</div>
 </li>
 </ul>
 <a id="testSum0BecomesCoalesce()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSum0BecomesCoalesce</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSum0BecomesCoalesce()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1174">[CALCITE-1174]
  When generating SQL, translate SUM0(x) to COALESCE(SUM(x), 0)</a>.</div>
 </li>
 </ul>
 <a id="testWindowedSum0BecomesCoalesce()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testWindowedSum0BecomesCoalesce</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testWindowedSum0BecomesCoalesce()</pre>
 <div class="block">As <a href="#testSum0BecomesCoalesce()"><code>testSum0BecomesCoalesce()</code></a> but for windowed aggregates.</div>
 </li>
 </ul>
 <a id="testStack()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testStack</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testStack()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-2722">[CALCITE-2722]
  SqlImplementor createLeftCall method throws StackOverflowError</a>.</div>
 </li>
 </ul>
 <a id="testNestedAggregates()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testNestedAggregates</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testNestedAggregates()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1946">[CALCITE-1946]
  JDBC adapter should generate sub-SELECT if dialect does not support nested
  aggregate functions</a>.</div>
 </li>
 </ul>
 <a id="testNestedAggregatesMySqlTable()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testNestedAggregatesMySqlTable</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testNestedAggregatesMySqlTable()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-2628">[CALCITE-2628]
  JDBC adapter throws NullPointerException while generating GROUP BY query
  for MySQL</a>.

  <p>MySQL does not support nested aggregates, so <code>RelToSqlConverter</code>
  performs some extra checks, looking for aggregates in the input
  sub-query, and these would fail with <code>NullPointerException</code>
  and <code>ClassCastException</code> in some cases.</div>
 </li>
 </ul>
 <a id="testNestedAggregatesMySqlStar()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testNestedAggregatesMySqlStar</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testNestedAggregatesMySqlStar()</pre>
 <div class="block">As <a href="#testNestedAggregatesMySqlTable()"><code>testNestedAggregatesMySqlTable()</code></a>, but input is a sub-query,
  not a table.</div>
 </li>
 </ul>
 <a id="testJoinWithLikeConditionRel2Sql()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJoinWithLikeConditionRel2Sql</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJoinWithLikeConditionRel2Sql()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-3207">[CALCITE-3207]
  Fail to convert Join RelNode with like condition to sql statement </a>.</div>
 </li>
 </ul>
 <a id="testSelectQueryWithGroupByAndProjectList1()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithGroupByAndProjectList1</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithGroupByAndProjectList1()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithGroupByHaving()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithGroupByHaving</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithGroupByHaving()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithGroupByHaving2()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithGroupByHaving2</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithGroupByHaving2()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1665">[CALCITE-1665]
  Aggregates and having cannot be combined</a>.</div>
 </li>
 </ul>
 <a id="testSelectQueryWithGroupByHaving3()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithGroupByHaving3</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithGroupByHaving3()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1665">[CALCITE-1665]
  Aggregates and having cannot be combined</a>.</div>
 </li>
 </ul>
 <a id="testHaving4()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testHaving4</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testHaving4()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithOrderByClause()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithOrderByClause</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithOrderByClause()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithOrderByClause1()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithOrderByClause1</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithOrderByClause1()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithTwoOrderByClause()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithTwoOrderByClause</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithTwoOrderByClause()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithAscDescOrderByClause()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithAscDescOrderByClause</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithAscDescOrderByClause()</pre>
 </li>
 </ul>
 <a id="testHiveSelectCharset()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testHiveSelectCharset</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testHiveSelectCharset()</pre>
 </li>
 </ul>
 <a id="testHiveTrim()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testHiveTrim</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testHiveTrim()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-3220">[CALCITE-3220]
  HiveSqlDialect should transform the SQL-standard TRIM function to TRIM,
  LTRIM or RTRIM</a>.</div>
 </li>
 </ul>
 <a id="testHiveTrimWithBoth()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testHiveTrimWithBoth</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testHiveTrimWithBoth()</pre>
 </li>
 </ul>
 <a id="testHiveTrimWithLeading()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testHiveTrimWithLeading</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testHiveTrimWithLeading()</pre>
 </li>
 </ul>
 <a id="testHiveTrimWithTailing()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testHiveTrimWithTailing</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testHiveTrimWithTailing()</pre>
 </li>
 </ul>
 <a id="testMssqlCharacterSet()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMssqlCharacterSet</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMssqlCharacterSet()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-2715">[CALCITE-2715]
  MS SQL Server does not support character set as part of data type</a>.</div>
 </li>
 </ul>
 <a id="testUnparseIn1()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testUnparseIn1</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testUnparseIn1()</pre>
 <div class="block">Tests that IN can be un-parsed.

  <p>This cannot be tested using "sql", because because Calcite's SQL parser
  replaces INs with ORs or sub-queries.</div>
 </li>
 </ul>
 <a id="testUnparseIn2()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testUnparseIn2</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testUnparseIn2()</pre>
 </li>
 </ul>
 <a id="testUnparseInStruct1()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testUnparseInStruct1</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testUnparseInStruct1()</pre>
 </li>
 </ul>
 <a id="testUnparseInStruct2()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testUnparseInStruct2</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testUnparseInStruct2()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithLimitClause()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithLimitClause</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithLimitClause()</pre>
 </li>
 </ul>
 <a id="testPositionFunctionForHive()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testPositionFunctionForHive</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testPositionFunctionForHive()</pre>
 </li>
 </ul>
 <a id="testPositionFunctionForBigQuery()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testPositionFunctionForBigQuery</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testPositionFunctionForBigQuery()</pre>
 </li>
 </ul>
 <a id="testCharLiteralForBigQuery()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testCharLiteralForBigQuery</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testCharLiteralForBigQuery()</pre>
 <div class="block">Tests that we escape single-quotes in character literals using back-slash
  in BigQuery. The norm is to escape single-quotes with single-quotes.</div>
 </li>
 </ul>
 <a id="testIdentifier()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testIdentifier</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testIdentifier()</pre>
 </li>
 </ul>
 <a id="testModFunctionForHive()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testModFunctionForHive</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testModFunctionForHive()</pre>
 </li>
 </ul>
 <a id="testUnionOperatorForBigQuery()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testUnionOperatorForBigQuery</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testUnionOperatorForBigQuery()</pre>
 </li>
 </ul>
 <a id="testIntersectOperatorForBigQuery()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testIntersectOperatorForBigQuery</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testIntersectOperatorForBigQuery()</pre>
 </li>
 </ul>
 <a id="testExceptOperatorForBigQuery()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testExceptOperatorForBigQuery</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testExceptOperatorForBigQuery()</pre>
 </li>
 </ul>
 <a id="testHiveSelectQueryWithOrderByDescAndNullsFirstShouldBeEmulated()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testHiveSelectQueryWithOrderByDescAndNullsFirstShouldBeEmulated</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testHiveSelectQueryWithOrderByDescAndNullsFirstShouldBeEmulated()</pre>
 </li>
 </ul>
 <a id="testHiveSelectQueryWithOrderByAscAndNullsLastShouldBeEmulated()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testHiveSelectQueryWithOrderByAscAndNullsLastShouldBeEmulated</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testHiveSelectQueryWithOrderByAscAndNullsLastShouldBeEmulated()</pre>
 </li>
 </ul>
 <a id="testHiveSelectQueryWithOrderByAscNullsFirstShouldNotAddNullEmulation()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testHiveSelectQueryWithOrderByAscNullsFirstShouldNotAddNullEmulation</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testHiveSelectQueryWithOrderByAscNullsFirstShouldNotAddNullEmulation()</pre>
 </li>
 </ul>
 <a id="testHiveSelectQueryWithOrderByDescNullsLastShouldNotAddNullEmulation()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testHiveSelectQueryWithOrderByDescNullsLastShouldNotAddNullEmulation</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testHiveSelectQueryWithOrderByDescNullsLastShouldNotAddNullEmulation()</pre>
 </li>
 </ul>
 <a id="testMysqlCastToBigint()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMysqlCastToBigint</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMysqlCastToBigint()</pre>
 </li>
 </ul>
 <a id="testMysqlCastToInteger()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMysqlCastToInteger</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMysqlCastToInteger()</pre>
 </li>
 </ul>
 <a id="testHiveSelectQueryWithOrderByDescAndHighNullsWithVersionGreaterThanOrEq21()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testHiveSelectQueryWithOrderByDescAndHighNullsWithVersionGreaterThanOrEq21</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testHiveSelectQueryWithOrderByDescAndHighNullsWithVersionGreaterThanOrEq21()</pre>
 </li>
 </ul>
 <a id="testHiveSelectQueryWithOrderByDescAndHighNullsWithVersion20()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testHiveSelectQueryWithOrderByDescAndHighNullsWithVersion20</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testHiveSelectQueryWithOrderByDescAndHighNullsWithVersion20()</pre>
 </li>
 </ul>
 <a id="testJethroDataSelectQueryWithOrderByDescAndNullsFirstShouldBeEmulated()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJethroDataSelectQueryWithOrderByDescAndNullsFirstShouldBeEmulated</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJethroDataSelectQueryWithOrderByDescAndNullsFirstShouldBeEmulated()</pre>
 </li>
 </ul>
 <a id="testMySqlSelectQueryWithOrderByDescAndNullsFirstShouldBeEmulated()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMySqlSelectQueryWithOrderByDescAndNullsFirstShouldBeEmulated</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMySqlSelectQueryWithOrderByDescAndNullsFirstShouldBeEmulated()</pre>
 </li>
 </ul>
 <a id="testMySqlSelectQueryWithOrderByAscAndNullsLastShouldBeEmulated()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMySqlSelectQueryWithOrderByAscAndNullsLastShouldBeEmulated</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMySqlSelectQueryWithOrderByAscAndNullsLastShouldBeEmulated()</pre>
 </li>
 </ul>
 <a id="testMySqlSelectQueryWithOrderByAscNullsFirstShouldNotAddNullEmulation()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMySqlSelectQueryWithOrderByAscNullsFirstShouldNotAddNullEmulation</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMySqlSelectQueryWithOrderByAscNullsFirstShouldNotAddNullEmulation()</pre>
 </li>
 </ul>
 <a id="testMySqlSelectQueryWithOrderByDescNullsLastShouldNotAddNullEmulation()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMySqlSelectQueryWithOrderByDescNullsLastShouldNotAddNullEmulation</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMySqlSelectQueryWithOrderByDescNullsLastShouldNotAddNullEmulation()</pre>
 </li>
 </ul>
 <a id="testMySqlWithHighNullsSelectWithOrderByAscNullsLastAndNoEmulation()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMySqlWithHighNullsSelectWithOrderByAscNullsLastAndNoEmulation</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMySqlWithHighNullsSelectWithOrderByAscNullsLastAndNoEmulation()</pre>
 </li>
 </ul>
 <a id="testMySqlWithHighNullsSelectWithOrderByAscNullsFirstAndNullEmulation()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMySqlWithHighNullsSelectWithOrderByAscNullsFirstAndNullEmulation</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMySqlWithHighNullsSelectWithOrderByAscNullsFirstAndNullEmulation()</pre>
 </li>
 </ul>
 <a id="testMySqlWithHighNullsSelectWithOrderByDescNullsFirstAndNoEmulation()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMySqlWithHighNullsSelectWithOrderByDescNullsFirstAndNoEmulation</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMySqlWithHighNullsSelectWithOrderByDescNullsFirstAndNoEmulation()</pre>
 </li>
 </ul>
 <a id="testMySqlWithHighNullsSelectWithOrderByDescNullsLastAndNullEmulation()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMySqlWithHighNullsSelectWithOrderByDescNullsLastAndNullEmulation</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMySqlWithHighNullsSelectWithOrderByDescNullsLastAndNullEmulation()</pre>
 </li>
 </ul>
 <a id="testMySqlWithFirstNullsSelectWithOrderByDescAndNullsFirstShouldNotBeEmulated()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMySqlWithFirstNullsSelectWithOrderByDescAndNullsFirstShouldNotBeEmulated</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMySqlWithFirstNullsSelectWithOrderByDescAndNullsFirstShouldNotBeEmulated()</pre>
 </li>
 </ul>
 <a id="testMySqlWithFirstNullsSelectWithOrderByAscAndNullsFirstShouldNotBeEmulated()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMySqlWithFirstNullsSelectWithOrderByAscAndNullsFirstShouldNotBeEmulated</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMySqlWithFirstNullsSelectWithOrderByAscAndNullsFirstShouldNotBeEmulated()</pre>
 </li>
 </ul>
 <a id="testMySqlWithFirstNullsSelectWithOrderByDescAndNullsLastShouldBeEmulated()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMySqlWithFirstNullsSelectWithOrderByDescAndNullsLastShouldBeEmulated</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMySqlWithFirstNullsSelectWithOrderByDescAndNullsLastShouldBeEmulated()</pre>
 </li>
 </ul>
 <a id="testMySqlWithFirstNullsSelectWithOrderByAscAndNullsLastShouldBeEmulated()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMySqlWithFirstNullsSelectWithOrderByAscAndNullsLastShouldBeEmulated</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMySqlWithFirstNullsSelectWithOrderByAscAndNullsLastShouldBeEmulated()</pre>
 </li>
 </ul>
 <a id="testMySqlWithLastNullsSelectWithOrderByDescAndNullsFirstShouldBeEmulated()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMySqlWithLastNullsSelectWithOrderByDescAndNullsFirstShouldBeEmulated</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMySqlWithLastNullsSelectWithOrderByDescAndNullsFirstShouldBeEmulated()</pre>
 </li>
 </ul>
 <a id="testMySqlWithLastNullsSelectWithOrderByAscAndNullsFirstShouldBeEmulated()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMySqlWithLastNullsSelectWithOrderByAscAndNullsFirstShouldBeEmulated</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMySqlWithLastNullsSelectWithOrderByAscAndNullsFirstShouldBeEmulated()</pre>
 </li>
 </ul>
 <a id="testMySqlWithLastNullsSelectWithOrderByDescAndNullsLastShouldNotBeEmulated()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMySqlWithLastNullsSelectWithOrderByDescAndNullsLastShouldNotBeEmulated</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMySqlWithLastNullsSelectWithOrderByDescAndNullsLastShouldNotBeEmulated()</pre>
 </li>
 </ul>
 <a id="testMySqlWithLastNullsSelectWithOrderByAscAndNullsLastShouldNotBeEmulated()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMySqlWithLastNullsSelectWithOrderByAscAndNullsLastShouldNotBeEmulated</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMySqlWithLastNullsSelectWithOrderByAscAndNullsLastShouldNotBeEmulated()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithLimitClauseWithoutOrder()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithLimitClauseWithoutOrder</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithLimitClauseWithoutOrder()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithLimitOffsetClause()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithLimitOffsetClause</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithLimitOffsetClause()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithParameters()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithParameters</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithParameters()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithFetchOffsetClause()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithFetchOffsetClause</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithFetchOffsetClause()</pre>
 </li>
 </ul>
 <a id="testSelectQueryComplex()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryComplex</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryComplex()</pre>
 </li>
 </ul>
 <a id="testSelectQueryWithGroup()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectQueryWithGroup</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectQueryWithGroup()</pre>
 </li>
 </ul>
 <a id="testSimpleJoin()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSimpleJoin</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSimpleJoin()</pre>
 </li>
 </ul>
 <a id="testSimpleJoinUsing()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSimpleJoinUsing</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSimpleJoinUsing()</pre>
 </li>
 </ul>
 <a id="testSubQueryAlias()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSubQueryAlias</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSubQueryAlias()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1636">[CALCITE-1636]
  JDBC adapter generates wrong SQL for self join with sub-query</a>.</div>
 </li>
 </ul>
 <a id="testCartesianProductWithCommaSyntax()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testCartesianProductWithCommaSyntax</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testCartesianProductWithCommaSyntax()</pre>
 </li>
 </ul>
 <a id="testJoinOnBoolean()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJoinOnBoolean</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJoinOnBoolean()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-2652">[CALCITE-2652]
  SqlNode to SQL conversion fails if the join condition references a BOOLEAN
  column</a>.</div>
 </li>
 </ul>
 <a id="testCartesianProductWithInnerJoinSyntax()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testCartesianProductWithInnerJoinSyntax</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testCartesianProductWithInnerJoinSyntax()</pre>
 </li>
 </ul>
 <a id="testFullJoinOnTrueCondition()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testFullJoinOnTrueCondition</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testFullJoinOnTrueCondition()</pre>
 </li>
 </ul>
 <a id="testSimpleIn()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSimpleIn</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSimpleIn()</pre>
 </li>
 </ul>
 <a id="testDb2DialectJoinStar()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testDb2DialectJoinStar</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testDb2DialectJoinStar()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1332">[CALCITE-1332]
  DB2 should always use aliases for tables: x.y.z AS z</a>.</div>
 </li>
 </ul>
 <a id="testDb2DialectSelfJoinStar()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testDb2DialectSelfJoinStar</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testDb2DialectSelfJoinStar()</pre>
 </li>
 </ul>
 <a id="testDb2DialectJoin()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testDb2DialectJoin</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testDb2DialectJoin()</pre>
 </li>
 </ul>
 <a id="testDb2DialectSelfJoin()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testDb2DialectSelfJoin</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testDb2DialectSelfJoin()</pre>
 </li>
 </ul>
 <a id="testDb2DialectWhere()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testDb2DialectWhere</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testDb2DialectWhere()</pre>
 </li>
 </ul>
 <a id="testDb2DialectJoinWhere()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testDb2DialectJoinWhere</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testDb2DialectJoinWhere()</pre>
 </li>
 </ul>
 <a id="testDb2DialectSelfJoinWhere()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testDb2DialectSelfJoinWhere</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testDb2DialectSelfJoinWhere()</pre>
 </li>
 </ul>
 <a id="testDb2DialectCast()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testDb2DialectCast</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testDb2DialectCast()</pre>
 </li>
 </ul>
 <a id="testDb2DialectSelectQueryWithGroupByHaving()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testDb2DialectSelectQueryWithGroupByHaving</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testDb2DialectSelectQueryWithGroupByHaving()</pre>
 </li>
 </ul>
 <a id="testDb2DialectSelectQueryComplex()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testDb2DialectSelectQueryComplex</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testDb2DialectSelectQueryComplex()</pre>
 </li>
 </ul>
 <a id="testDb2DialectSelectQueryWithGroup()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testDb2DialectSelectQueryWithGroup</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testDb2DialectSelectQueryWithGroup()</pre>
 </li>
 </ul>
 <a id="testJoinPlan2()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJoinPlan2</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJoinPlan2()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1372">[CALCITE-1372]
  JDBC adapter generates SQL with wrong field names</a>.</div>
 </li>
 </ul>
 <a id="testSimpleJoinConditionWithIsNullOperators()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSimpleJoinConditionWithIsNullOperators</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSimpleJoinConditionWithIsNullOperators()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1422">[CALCITE-1422]
  In JDBC adapter, allow IS NULL and IS NOT NULL operators in generated SQL
  join condition</a>.</div>
 </li>
 </ul>
 <a id="testThreeQueryUnion()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testThreeQueryUnion</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testThreeQueryUnion()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1586">[CALCITE-1586]
  JDBC adapter generates wrong SQL if UNION has more than two inputs</a>.</div>
 </li>
 </ul>
 <a id="testUnionWrappedInASelect()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testUnionWrappedInASelect</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testUnionWrappedInASelect()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1800">[CALCITE-1800]
  JDBC adapter fails to SELECT FROM a UNION query</a>.</div>
 </li>
 </ul>
 <a id="testLiteral()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testLiteral</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testLiteral()</pre>
 </li>
 </ul>
 <a id="checkLiteral(java.lang.String)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>checkLiteral</h4>
 <pre class="methodSignature">private&nbsp;void&nbsp;checkLiteral&#8203;(java.lang.String&nbsp;expression)</pre>
 </li>
 </ul>
 <a id="checkLiteral2(java.lang.String,java.lang.String)">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>checkLiteral2</h4>
 <pre class="methodSignature">private&nbsp;void&nbsp;checkLiteral2&#8203;(java.lang.String&nbsp;expression,
                            java.lang.String&nbsp;expected)</pre>
 </li>
 </ul>
 <a id="testRowNumberFunctionForPrintingOfFrameBoundary()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testRowNumberFunctionForPrintingOfFrameBoundary</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testRowNumberFunctionForPrintingOfFrameBoundary()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-2625">[CALCITE-2625]
  Removing Window Boundaries from SqlWindow of Aggregate Function which do not allow Framing</a></div>
 </li>
 </ul>
 <a id="testRankFunctionForPrintingOfFrameBoundary()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testRankFunctionForPrintingOfFrameBoundary</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testRankFunctionForPrintingOfFrameBoundary()</pre>
 </li>
 </ul>
 <a id="testLeadFunctionForPrintingOfFrameBoundary()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testLeadFunctionForPrintingOfFrameBoundary</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testLeadFunctionForPrintingOfFrameBoundary()</pre>
 </li>
 </ul>
 <a id="testLagFunctionForPrintingOfFrameBoundary()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testLagFunctionForPrintingOfFrameBoundary</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testLagFunctionForPrintingOfFrameBoundary()</pre>
 </li>
 </ul>
 <a id="testFloor()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testFloor</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testFloor()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1798">[CALCITE-1798]
  Generate dialect-specific SQL for FLOOR operator</a>.</div>
 </li>
 </ul>
 <a id="testFloorPostgres()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testFloorPostgres</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testFloorPostgres()</pre>
 </li>
 </ul>
 <a id="testFloorOracle()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testFloorOracle</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testFloorOracle()</pre>
 </li>
 </ul>
 <a id="testFloorMssqlWeek()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testFloorMssqlWeek</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testFloorMssqlWeek()</pre>
 </li>
 </ul>
 <a id="testFloorMssqlMonth()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testFloorMssqlMonth</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testFloorMssqlMonth()</pre>
 </li>
 </ul>
 <a id="testFloorMysqlMonth()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testFloorMysqlMonth</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testFloorMysqlMonth()</pre>
 </li>
 </ul>
 <a id="testUnparseSqlIntervalQualifierDb2()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testUnparseSqlIntervalQualifierDb2</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testUnparseSqlIntervalQualifierDb2()</pre>
 </li>
 </ul>
 <a id="testUnparseSqlIntervalQualifierMySql()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testUnparseSqlIntervalQualifierMySql</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testUnparseSqlIntervalQualifierMySql()</pre>
 </li>
 </ul>
 <a id="testUnparseSqlIntervalQualifierMsSql()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testUnparseSqlIntervalQualifierMsSql</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testUnparseSqlIntervalQualifierMsSql()</pre>
 </li>
 </ul>
 <a id="testFloorMysqlWeek()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testFloorMysqlWeek</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testFloorMysqlWeek()</pre>
 </li>
 </ul>
 <a id="testFloorMysqlHour()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testFloorMysqlHour</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testFloorMysqlHour()</pre>
 </li>
 </ul>
 <a id="testFloorMysqlMinute()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testFloorMysqlMinute</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testFloorMysqlMinute()</pre>
 </li>
 </ul>
 <a id="testFloorMysqlSecond()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testFloorMysqlSecond</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testFloorMysqlSecond()</pre>
 </li>
 </ul>
 <a id="testFloorWithGroupBy()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testFloorWithGroupBy</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testFloorWithGroupBy()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1826">[CALCITE-1826]
  JDBC dialect-specific FLOOR fails when in GROUP BY</a>.</div>
 </li>
 </ul>
 <a id="testSubstring()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSubstring</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSubstring()</pre>
 </li>
 </ul>
 <a id="testSubstringWithFor()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSubstringWithFor</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSubstringWithFor()</pre>
 </li>
 </ul>
 <a id="testExistsWithExpand()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testExistsWithExpand</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testExistsWithExpand()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-1849">[CALCITE-1849]
  Support sub-queries (RexSubQuery) in RelToSqlConverter</a>.</div>
 </li>
 </ul>
 <a id="testNotExistsWithExpand()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testNotExistsWithExpand</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testNotExistsWithExpand()</pre>
 </li>
 </ul>
 <a id="testSubQueryInWithExpand()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSubQueryInWithExpand</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSubQueryInWithExpand()</pre>
 </li>
 </ul>
 <a id="testSubQueryInWithExpand2()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSubQueryInWithExpand2</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSubQueryInWithExpand2()</pre>
 </li>
 </ul>
 <a id="testSubQueryNotInWithExpand()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSubQueryNotInWithExpand</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSubQueryNotInWithExpand()</pre>
 </li>
 </ul>
 <a id="testLike()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testLike</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testLike()</pre>
 </li>
 </ul>
 <a id="testNotLike()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testNotLike</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testNotLike()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternExpression()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternExpression</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternExpression()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternExpression2()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternExpression2</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternExpression2()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternExpression3()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternExpression3</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternExpression3()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternExpression4()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternExpression4</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternExpression4()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternExpression5()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternExpression5</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternExpression5()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternExpression6()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternExpression6</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternExpression6()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternExpression7()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternExpression7</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternExpression7()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternExpression8()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternExpression8</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternExpression8()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternExpression9()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternExpression9</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternExpression9()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternExpression10()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternExpression10</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternExpression10()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternExpression11()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternExpression11</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternExpression11()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternExpression12()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternExpression12</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternExpression12()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternExpression13()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternExpression13</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternExpression13()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeDefineClause()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeDefineClause</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeDefineClause()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeDefineClause2()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeDefineClause2</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeDefineClause2()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeDefineClause3()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeDefineClause3</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeDefineClause3()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeDefineClause4()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeDefineClause4</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeDefineClause4()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeMeasures1()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeMeasures1</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeMeasures1()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeMeasures2()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeMeasures2</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeMeasures2()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeMeasures3()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeMeasures3</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeMeasures3()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeMeasures4()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeMeasures4</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeMeasures4()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeMeasures5()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeMeasures5</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeMeasures5()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeMeasures6()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeMeasures6</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeMeasures6()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeMeasures7()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeMeasures7</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeMeasures7()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternSkip1()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternSkip1</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternSkip1()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternSkip2()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternSkip2</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternSkip2()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternSkip3()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternSkip3</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternSkip3()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternSkip4()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternSkip4</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternSkip4()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizePatternSkip5()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizePatternSkip5</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizePatternSkip5()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeSubset1()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeSubset1</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeSubset1()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeSubset2()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeSubset2</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeSubset2()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeSubset3()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeSubset3</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeSubset3()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeSubset4()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeSubset4</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeSubset4()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeRowsPerMatch1()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeRowsPerMatch1</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeRowsPerMatch1()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeRowsPerMatch2()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeRowsPerMatch2</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeRowsPerMatch2()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeWithin()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeWithin</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeWithin()</pre>
 </li>
 </ul>
 <a id="testMatchRecognizeIn()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testMatchRecognizeIn</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testMatchRecognizeIn()</pre>
 </li>
 </ul>
 <a id="testValues()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testValues</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testValues()</pre>
 </li>
 </ul>
 <a id="testValuesEmpty()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testValuesEmpty</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testValuesEmpty()</pre>
 </li>
 </ul>
 <a id="testPreserveAlias()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testPreserveAlias</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testPreserveAlias()</pre>
 <div class="block">Test case for
  <a href="https://issues.apache.org/jira/browse/CALCITE-2118">[CALCITE-2118]
  RelToSqlConverter should only generate "*" if field names match</a>.</div>
 </li>
 </ul>
 <a id="testPreservePermutation()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testPreservePermutation</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testPreservePermutation()</pre>
 </li>
 </ul>
 <a id="testFieldNamesWithAggregateSubQuery()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testFieldNamesWithAggregateSubQuery</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testFieldNamesWithAggregateSubQuery()</pre>
 </li>
 </ul>
 <a id="testUnparseSelectMustUseDialect()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testUnparseSelectMustUseDialect</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testUnparseSelectMustUseDialect()</pre>
 </li>
 </ul>
 <a id="testCorrelate()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testCorrelate</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testCorrelate()</pre>
 </li>
 </ul>
 <a id="testUncollectExplicitAlias()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testUncollectExplicitAlias</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testUncollectExplicitAlias()</pre>
 </li>
 </ul>
 <a id="testUncollectImplicitAlias()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testUncollectImplicitAlias</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testUncollectImplicitAlias()</pre>
 </li>
 </ul>
 <a id="testWithinGroup1()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testWithinGroup1</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testWithinGroup1()</pre>
 </li>
 </ul>
 <a id="testWithinGroup2()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testWithinGroup2</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testWithinGroup2()</pre>
 </li>
 </ul>
 <a id="testWithinGroup3()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testWithinGroup3</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testWithinGroup3()</pre>
 </li>
 </ul>
 <a id="testWithinGroup4()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testWithinGroup4</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testWithinGroup4()</pre>
 </li>
 </ul>
 <a id="testJsonValueExpressionOperator()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJsonValueExpressionOperator</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJsonValueExpressionOperator()</pre>
 </li>
 </ul>
 <a id="testJsonExists()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJsonExists</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJsonExists()</pre>
 </li>
 </ul>
 <a id="testJsonPretty()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJsonPretty</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJsonPretty()</pre>
 </li>
 </ul>
 <a id="testJsonValue()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJsonValue</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJsonValue()</pre>
 </li>
 </ul>
 <a id="testJsonQuery()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJsonQuery</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJsonQuery()</pre>
 </li>
 </ul>
 <a id="testJsonArray()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJsonArray</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJsonArray()</pre>
 </li>
 </ul>
 <a id="testJsonArrayAgg()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJsonArrayAgg</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJsonArrayAgg()</pre>
 </li>
 </ul>
 <a id="testJsonObject()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJsonObject</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJsonObject()</pre>
 </li>
 </ul>
 <a id="testJsonObjectAgg()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJsonObjectAgg</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJsonObjectAgg()</pre>
 </li>
 </ul>
 <a id="testJsonPredicate()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJsonPredicate</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJsonPredicate()</pre>
 </li>
 </ul>
 <a id="testCrossJoinEmulationForSpark()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testCrossJoinEmulationForSpark</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testCrossJoinEmulationForSpark()</pre>
 </li>
 </ul>
 <a id="testSubstringInSpark()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSubstringInSpark</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSubstringInSpark()</pre>
 </li>
 </ul>
 <a id="testSubstringWithForInSpark()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSubstringWithForInSpark</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSubstringWithForInSpark()</pre>
 </li>
 </ul>
 <a id="testFloorInSpark()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testFloorInSpark</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testFloorInSpark()</pre>
 </li>
 </ul>
 <a id="testNumericFloorInSpark()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testNumericFloorInSpark</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testNumericFloorInSpark()</pre>
 </li>
 </ul>
 <a id="testJsonStorageSize()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJsonStorageSize</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJsonStorageSize()</pre>
 </li>
 </ul>
 <a id="testCubeInSpark()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testCubeInSpark</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testCubeInSpark()</pre>
 </li>
 </ul>
 <a id="testRollupInSpark()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testRollupInSpark</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testRollupInSpark()</pre>
 </li>
 </ul>
 <a id="testJsonType()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJsonType</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJsonType()</pre>
 </li>
 </ul>
 <a id="testJsonDepth()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJsonDepth</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJsonDepth()</pre>
 </li>
 </ul>
 <a id="testJsonLength()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJsonLength</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJsonLength()</pre>
 </li>
 </ul>
 <a id="testJsonKeys()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJsonKeys</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJsonKeys()</pre>
 </li>
 </ul>
 <a id="testJsonRemove()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testJsonRemove</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testJsonRemove()</pre>
 </li>
 </ul>
 <a id="testUnionAllWithNoOperandsUsingOracleDialect()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testUnionAllWithNoOperandsUsingOracleDialect</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testUnionAllWithNoOperandsUsingOracleDialect()</pre>
 </li>
 </ul>
 <a id="testUnionAllWithNoOperands()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testUnionAllWithNoOperands</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testUnionAllWithNoOperands()</pre>
 </li>
 </ul>
 <a id="testSmallintOracle()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSmallintOracle</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSmallintOracle()</pre>
 </li>
 </ul>
 <a id="testBigintOracle()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testBigintOracle</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testBigintOracle()</pre>
 </li>
 </ul>
 <a id="testDoubleOracle()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testDoubleOracle</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testDoubleOracle()</pre>
 </li>
 </ul>
 <a id="testDateLiteralOracle()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testDateLiteralOracle</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testDateLiteralOracle()</pre>
 </li>
 </ul>
 <a id="testTimestampLiteralOracle()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testTimestampLiteralOracle</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testTimestampLiteralOracle()</pre>
 </li>
 </ul>
 <a id="testTimeLiteralOracle()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testTimeLiteralOracle</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testTimeLiteralOracle()</pre>
 </li>
 </ul>
 <a id="testSupportsDataType()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSupportsDataType</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSupportsDataType()</pre>
 </li>
 </ul>
 <a id="testSelectNull()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectNull</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectNull()</pre>
 </li>
 </ul>
 <a id="testSelectNullWithCount()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectNullWithCount</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectNullWithCount()</pre>
 </li>
 </ul>
 <a id="testSelectNullWithGroupByNull()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectNullWithGroupByNull</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectNullWithGroupByNull()</pre>
 </li>
 </ul>
 <a id="testSelectNullWithGroupByVar()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectNullWithGroupByVar</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectNullWithGroupByVar()</pre>
 </li>
 </ul>
 <a id="testSelectNullWithInsert()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectNullWithInsert</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectNullWithInsert()</pre>
 </li>
 </ul>
 <a id="testSelectNullWithInsertFromJoin()">
 <!--   -->
 </a>
 <ul class="blockList">
 <li class="blockList">
 <h4>testSelectNullWithInsertFromJoin</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testSelectNullWithInsertFromJoin()</pre>
 </li>
 </ul>
 <a id="testDialectQuoteStringLiteral()">
 <!--   -->
 </a>
 <ul class="blockListLast">
 <li class="blockList">
 <h4>testDialectQuoteStringLiteral</h4>
 <pre class="methodSignature">public&nbsp;void&nbsp;testDialectQuoteStringLiteral()</pre>
 </li>
 </ul>
 </li>
 </ul>
 </section>
 </li>
 </ul>
 </div>
 </div>
 </main>
 <!-- ========= END OF CLASS DATA ========= -->
 <footer role="contentinfo">
 <nav role="navigation">
 <!-- ======= START OF BOTTOM NAVBAR ====== -->
 <div class="bottomNav"><a id="navbar.bottom">
 <!--   -->
 </a>
 <div class="skipNav"><a href="#skip.navbar.bottom" title="Skip navigation links">Skip navigation links</a></div>
 <a id="navbar.bottom.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/RelToSqlConverterTest.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_bottom">
 <li><a href="../../../../../allclasses.html">All&nbsp;Classes</a></li>
 </ul>
 <div>
 <script type="text/javascript"><!--
   allClassesLink = document.getElementById("allclasses_navbar_bottom");
   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.bottom">
 <!--   -->
 </a></div>
 <!-- ======== END OF BOTTOM NAVBAR ======= -->
 </nav>
 <p class="legalCopy"><small>Copyright &#169; 2012&#x2013;2019 <a href="https://www.apache.org/">The Apache Software Foundation</a>. All rights reserved.</small></p>
 </footer>
 </body>
 </html>