Google Git
Sign in
apache / calcite-site / f3651d86b6f63f8b6bbb735c74220c093b7bf506 / . / testapidocs / org / apache / calcite / test / JdbcAdapterTest.html
blob: 6738ca483e480929ff256c2c48183c7743a2cab3 [file] [log] [blame]
<!DOCTYPE HTML>
<!-- NewPage -->
<html lang="en">
<head>
<!-- Generated by javadoc -->
<title>JdbcAdapterTest (Calcite 1.20.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="JdbcAdapterTest (Calcite 1.20.0 Test API)";
}
}
catch(err) {
}
//-->
var data = {"i0":10,"i1":10,"i2":10,"i3":10,"i4":10,"i5":10,"i6":10,"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};
var tabs = {65535:["t0","All 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/JdbcAdapterTest.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.test</a></div>
<h2 title="Class JdbcAdapterTest" class="title">Class JdbcAdapterTest</h2>
</div>
<div class="contentContainer">
<ul class="inheritance">
<li>java.lang.Object</li>
<li>
<ul class="inheritance">
<li>org.apache.calcite.test.JdbcAdapterTest</li>
</ul>
</li>
</ul>
<div class="description">
<ul class="blockList">
<li class="blockList">
<hr>
<pre>public class <span class="typeNameLabel">JdbcAdapterTest</span>
extends java.lang.Object</pre>
<div class="block">Tests for the <code>org.apache.calcite.adapter.jdbc</code> package.</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="JdbcAdapterTest.LockWrapper.html" title="class in org.apache.calcite.test">JdbcAdapterTest.LockWrapper</a></span></code></th>
<td class="colLast">
<div class="block">Acquires a lock, and releases it when closed.</div>
</td>
</tr>
</table>
</li>
</ul>
</section>
<!-- =========== FIELD SUMMARY =========== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="field.summary">
<!-- -->
</a>
<h3>Field Summary</h3>
<table class="memberSummary">
<caption><span>Fields</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colSecond" scope="col">Field</th>
<th class="colLast" scope="col">Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>private static java.util.concurrent.locks.ReentrantLock</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#LOCK">LOCK</a></span></code></th>
<td class="colLast">
<div class="block">Ensures that tests that are modifying data (doing DML) do not run at the
same time.</div>
</td>
</tr>
</table>
</li>
</ul>
</section>
<!-- ======== CONSTRUCTOR SUMMARY ======== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="constructor.summary">
<!-- -->
</a>
<h3>Constructor Summary</h3>
<table class="memberSummary">
<caption><span>Constructors</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">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()">JdbcAdapterTest</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="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 <a href="JdbcAdapterTest.LockWrapper.html" title="class in org.apache.calcite.test">JdbcAdapterTest.LockWrapper</a></code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#exclusiveCleanDb(java.sql.Connection)">exclusiveCleanDb</a></span>&#8203;(java.sql.Connection&nbsp;c)</code></th>
<td class="colLast">
<div class="block">Acquires an exclusive connection to a test database, and cleans it.</div>
</td>
</tr>
<tr id="i1" class="rowColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#pushBindParameters()">pushBindParameters</a></span>()</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i2" class="altColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCartesianJoinWithoutKeyPlan()">testCartesianJoinWithoutKeyPlan</a></span>()</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i3" class="rowColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCast()">testCast</a></span>()</code></th>
<td class="colLast">
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-2305">[CALCITE-2305]
JDBC adapter generates invalid casts on PostgreSQL, because PostgreSQL does
not have TINYINT and DOUBLE types</a>.</div>
</td>
</tr>
<tr id="i4" class="altColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testColumnNullability()">testColumnNullability</a></span>()</code></th>
<td class="colLast">
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-1572">[CALCITE-1572]
JdbcSchema throws exception when detecting nullable columns</a>.</div>
</td>
</tr>
<tr id="i5" class="rowColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCrossJoinWithJoinKeyAndFilterPlan()">testCrossJoinWithJoinKeyAndFilterPlan</a></span>()</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i6" class="altColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCrossJoinWithJoinKeyPlan()">testCrossJoinWithJoinKeyPlan</a></span>()</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i7" class="rowColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testEquiJoinPlan()">testEquiJoinPlan</a></span>()</code></th>
<td class="colLast">&nbsp;</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="#testFilterUnionPlan()">testFilterUnionPlan</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="#testInPlan()">testInPlan</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="#testJdbcAggregate()">testJdbcAggregate</a></span>()</code></th>
<td class="colLast">
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-657">[CALCITE-657]
NullPointerException when executing JdbcAggregate implement method</a>.</div>
</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="#testJoin3TablesPlan()">testJoin3TablesPlan</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="#testJoinCartesian()">testJoinCartesian</a></span>()</code></th>
<td class="colLast">&nbsp;</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="#testJoinCartesianCount()">testJoinCartesianCount</a></span>()</code></th>
<td class="colLast">&nbsp;</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="#testJoinPlan()">testJoinPlan</a></span>()</code></th>
<td class="colLast">
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-893">[CALCITE-893]
Theta join in JdbcAdapter</a>.</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="#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="i16" class="altColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testLastValueOver()">testLastValueOver</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="#testMetadataTables()">testMetadataTables</a></span>()</code></th>
<td class="colLast">
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-865">[CALCITE-865]
Unknown table type causes NullPointerException in JdbcSchema</a>.</div>
</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="#testMixedJoinPlan()">testMixedJoinPlan</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="#testMixedJoinWithOrPlan()">testMixedJoinWithOrPlan</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="#testNonEquiJoinPlan()">testNonEquiJoinPlan</a></span>()</code></th>
<td class="colLast">
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-631">[CALCITE-631]
Push theta joins down to JDBC adapter</a>.</div>
</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="#testNonEquiJoinReverseConditionPlan()">testNonEquiJoinReverseConditionPlan</a></span>()</code></th>
<td class="colLast">&nbsp;</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="#testOverDefault()">testOverDefault</a></span>()</code></th>
<td class="colLast">
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-1506">[CALCITE-1506]
Push OVER Clause to underlying SQL via JDBC adapter</a>.</div>
</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="#testOverDisallowPartial()">testOverDisallowPartial</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="#testOverNonSupportedDialect()">testOverNonSupportedDialect</a></span>()</code></th>
<td class="colLast">
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-2206">[CALCITE-2206]
JDBC adapter incorrectly pushes windowed aggregates down to HSQLDB</a>.</div>
</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="#testOverRowsBetweenBoundFollowingAndFollowing()">testOverRowsBetweenBoundFollowingAndFollowing</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="#testOverRowsBetweenBoundPrecedingAndCurrent()">testOverRowsBetweenBoundPrecedingAndCurrent</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="#testScalarSubQuery()">testScalarSubQuery</a></span>()</code></th>
<td class="colLast">
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-666">[CALCITE-666]
Anti-semi-joins against JDBC adapter give wrong results</a>.</div>
</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="#testSubQueryWithSingleValue()">testSubQueryWithSingleValue</a></span>()</code></th>
<td class="colLast">
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-259">[CALCITE-259]
Using sub-queries in CASE statement against JDBC tables generates invalid
Oracle SQL</a>.</div>
</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="#testTableModifyDelete()">testTableModifyDelete</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="#testTableModifyInsert()">testTableModifyInsert</a></span>()</code></th>
<td class="colLast">
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-1527">[CALCITE-1527]
Support DML in the JDBC adapter</a>.</div>
</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="#testTableModifyInsertMultiValues()">testTableModifyInsertMultiValues</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="#testTableModifyInsertWithSubQuery()">testTableModifyInsertWithSubQuery</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="#testTableModifyUpdate()">testTableModifyUpdate</a></span>()</code></th>
<td class="colLast">&nbsp;</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="#testTablesNoCatalogSchema()">testTablesNoCatalogSchema</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="#testUnionPlan()">testUnionPlan</a></span>()</code></th>
<td class="colLast">&nbsp;</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="#testValuesPlan()">testValuesPlan</a></span>()</code></th>
<td class="colLast">
<div class="block">VALUES is not pushed down, currently.</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="LOCK">
<!-- -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>LOCK</h4>
<pre>private static final&nbsp;java.util.concurrent.locks.ReentrantLock LOCK</pre>
<div class="block">Ensures that tests that are modifying data (doing DML) do not run at the
same time.</div>
</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>JdbcAdapterTest</h4>
<pre>public&nbsp;JdbcAdapterTest()</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="testValuesPlan()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testValuesPlan</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testValuesPlan()</pre>
<div class="block">VALUES is not pushed down, currently.</div>
</li>
</ul>
<a id="testUnionPlan()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testUnionPlan</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testUnionPlan()</pre>
</li>
</ul>
<a id="testFilterUnionPlan()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testFilterUnionPlan</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testFilterUnionPlan()</pre>
</li>
</ul>
<a id="testInPlan()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testInPlan</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testInPlan()</pre>
</li>
</ul>
<a id="testEquiJoinPlan()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testEquiJoinPlan</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testEquiJoinPlan()</pre>
</li>
</ul>
<a id="testNonEquiJoinPlan()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testNonEquiJoinPlan</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testNonEquiJoinPlan()</pre>
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-631">[CALCITE-631]
Push theta joins down to JDBC adapter</a>.</div>
</li>
</ul>
<a id="testNonEquiJoinReverseConditionPlan()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testNonEquiJoinReverseConditionPlan</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testNonEquiJoinReverseConditionPlan()</pre>
</li>
</ul>
<a id="testMixedJoinPlan()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testMixedJoinPlan</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testMixedJoinPlan()</pre>
</li>
</ul>
<a id="testMixedJoinWithOrPlan()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testMixedJoinWithOrPlan</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testMixedJoinWithOrPlan()</pre>
</li>
</ul>
<a id="testJoin3TablesPlan()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testJoin3TablesPlan</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testJoin3TablesPlan()</pre>
</li>
</ul>
<a id="testCrossJoinWithJoinKeyPlan()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testCrossJoinWithJoinKeyPlan</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testCrossJoinWithJoinKeyPlan()</pre>
</li>
</ul>
<a id="testCartesianJoinWithoutKeyPlan()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testCartesianJoinWithoutKeyPlan</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testCartesianJoinWithoutKeyPlan()</pre>
</li>
</ul>
<a id="testCrossJoinWithJoinKeyAndFilterPlan()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testCrossJoinWithJoinKeyAndFilterPlan</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testCrossJoinWithJoinKeyAndFilterPlan()</pre>
</li>
</ul>
<a id="testJoinPlan()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testJoinPlan</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testJoinPlan()</pre>
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-893">[CALCITE-893]
Theta join in JdbcAdapter</a>.</div>
</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="testJoinCartesian()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testJoinCartesian</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testJoinCartesian()</pre>
</li>
</ul>
<a id="testJoinCartesianCount()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testJoinCartesianCount</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testJoinCartesianCount()</pre>
</li>
</ul>
<a id="testJdbcAggregate()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testJdbcAggregate</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testJdbcAggregate()
throws java.lang.Exception</pre>
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-657">[CALCITE-657]
NullPointerException when executing JdbcAggregate implement method</a>.</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.lang.Exception</code></dd>
</dl>
</li>
</ul>
<a id="testOverNonSupportedDialect()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testOverNonSupportedDialect</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testOverNonSupportedDialect()</pre>
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-2206">[CALCITE-2206]
JDBC adapter incorrectly pushes windowed aggregates down to HSQLDB</a>.</div>
</li>
</ul>
<a id="testTablesNoCatalogSchema()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testTablesNoCatalogSchema</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testTablesNoCatalogSchema()</pre>
</li>
</ul>
<a id="testOverDefault()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testOverDefault</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testOverDefault()</pre>
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-1506">[CALCITE-1506]
Push OVER Clause to underlying SQL via JDBC adapter</a>.
<p>Test runs only on Postgres; the default database, Hsqldb, does not
support OVER.</div>
</li>
</ul>
<a id="testCast()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testCast</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testCast()</pre>
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-2305">[CALCITE-2305]
JDBC adapter generates invalid casts on PostgreSQL, because PostgreSQL does
not have TINYINT and DOUBLE types</a>.</div>
</li>
</ul>
<a id="testOverRowsBetweenBoundFollowingAndFollowing()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testOverRowsBetweenBoundFollowingAndFollowing</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testOverRowsBetweenBoundFollowingAndFollowing()</pre>
</li>
</ul>
<a id="testOverRowsBetweenBoundPrecedingAndCurrent()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testOverRowsBetweenBoundPrecedingAndCurrent</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testOverRowsBetweenBoundPrecedingAndCurrent()</pre>
</li>
</ul>
<a id="testOverDisallowPartial()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testOverDisallowPartial</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testOverDisallowPartial()</pre>
</li>
</ul>
<a id="testLastValueOver()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testLastValueOver</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testLastValueOver()</pre>
</li>
</ul>
<a id="testSubQueryWithSingleValue()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testSubQueryWithSingleValue</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testSubQueryWithSingleValue()</pre>
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-259">[CALCITE-259]
Using sub-queries in CASE statement against JDBC tables generates invalid
Oracle SQL</a>.</div>
</li>
</ul>
<a id="testMetadataTables()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testMetadataTables</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testMetadataTables()
throws java.lang.Exception</pre>
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-865">[CALCITE-865]
Unknown table type causes NullPointerException in JdbcSchema</a>. The issue
occurred because of the "SYSTEM_INDEX" table type when run against
PostgreSQL.</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.lang.Exception</code></dd>
</dl>
</li>
</ul>
<a id="testScalarSubQuery()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testScalarSubQuery</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testScalarSubQuery()</pre>
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-666">[CALCITE-666]
Anti-semi-joins against JDBC adapter give wrong results</a>.</div>
</li>
</ul>
<a id="exclusiveCleanDb(java.sql.Connection)">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>exclusiveCleanDb</h4>
<pre class="methodSignature">private&nbsp;<a href="JdbcAdapterTest.LockWrapper.html" title="class in org.apache.calcite.test">JdbcAdapterTest.LockWrapper</a>&nbsp;exclusiveCleanDb&#8203;(java.sql.Connection&nbsp;c)
throws java.sql.SQLException</pre>
<div class="block">Acquires an exclusive connection to a test database, and cleans it.
<p>Cleans any previous TableModify states and creates
one expense_fact instance with store_id = 666.
<p>Caller must close the returned wrapper, so that the next test can
acquire the lock and use the database.</div>
<dl>
<dt><span class="paramLabel">Parameters:</span></dt>
<dd><code>c</code> - JDBC connection</dd>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="testTableModifyInsert()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testTableModifyInsert</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testTableModifyInsert()
throws java.lang.Exception</pre>
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-1527">[CALCITE-1527]
Support DML in the JDBC adapter</a>.</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.lang.Exception</code></dd>
</dl>
</li>
</ul>
<a id="testTableModifyInsertMultiValues()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testTableModifyInsertMultiValues</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testTableModifyInsertMultiValues()
throws java.lang.Exception</pre>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.lang.Exception</code></dd>
</dl>
</li>
</ul>
<a id="testTableModifyInsertWithSubQuery()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testTableModifyInsertWithSubQuery</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testTableModifyInsertWithSubQuery()
throws java.lang.Exception</pre>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.lang.Exception</code></dd>
</dl>
</li>
</ul>
<a id="testTableModifyUpdate()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testTableModifyUpdate</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testTableModifyUpdate()
throws java.lang.Exception</pre>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.lang.Exception</code></dd>
</dl>
</li>
</ul>
<a id="testTableModifyDelete()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testTableModifyDelete</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testTableModifyDelete()
throws java.lang.Exception</pre>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.lang.Exception</code></dd>
</dl>
</li>
</ul>
<a id="testColumnNullability()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testColumnNullability</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testColumnNullability()
throws java.lang.Exception</pre>
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-1572">[CALCITE-1572]
JdbcSchema throws exception when detecting nullable columns</a>.</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.lang.Exception</code></dd>
</dl>
</li>
</ul>
<a id="pushBindParameters()">
<!-- -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>pushBindParameters</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;pushBindParameters()
throws java.lang.Exception</pre>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.lang.Exception</code></dd>
</dl>
</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/JdbcAdapterTest.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>