java.lang.Object
- org.apache.calcite.test.JdbcAdapterTest

public class JdbcAdapterTest
extends java.lang.Object

Tests for the org.apache.calcite.adapter.jdbc package.

Nested Class Summary

Nested Classes
Modifier and Type Class Description

(package private) static class JdbcAdapterTest.LockWrapper
Acquires a lock, and releases it when closed.

Field Summary

Fields
Modifier and Type Field Description

private static java.util.concurrent.locks.ReentrantLock LOCK
Ensures that tests that are modifying data (doing DML) do not run at the same time.

Constructor Summary

Constructors
Constructor Description

JdbcAdapterTest()

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`private JdbcAdapterTest.LockWrapper`	`exclusiveCleanDb(java.sql.Connection c)`	Acquires an exclusive connection to a test database, and cleans it.
`void`	`pushBindParameters()`
`void`	`testCartesianJoinWithoutKeyPlan()`
`void`	`testCast()`	Test case for [CALCITE-2305] JDBC adapter generates invalid casts on PostgreSQL, because PostgreSQL does not have TINYINT and DOUBLE types.
`void`	`testColumnNullability()`	Test case for [CALCITE-1572] JdbcSchema throws exception when detecting nullable columns.
`void`	`testCrossJoinWithJoinKeyAndFilterPlan()`
`void`	`testCrossJoinWithJoinKeyPlan()`
`void`	`testEquiJoinPlan()`
`void`	`testFilterUnionPlan()`
`void`	`testInPlan()`
`void`	`testJdbcAggregate()`	Test case for [CALCITE-657] NullPointerException when executing JdbcAggregate implement method.
`void`	`testJoin3TablesPlan()`
`void`	`testJoinCartesian()`
`void`	`testJoinCartesianCount()`
`void`	`testJoinPlan()`	Test case for [CALCITE-893] Theta join in JdbcAdapter.
`void`	`testJoinPlan2()`	Test case for [CALCITE-1372] JDBC adapter generates SQL with wrong field names.
`void`	`testLastValueOver()`
`void`	`testMetadataTables()`	Test case for [CALCITE-865] Unknown table type causes NullPointerException in JdbcSchema.
`void`	`testMixedJoinPlan()`
`void`	`testMixedJoinWithOrPlan()`
`void`	`testNonEquiJoinPlan()`	Test case for [CALCITE-631] Push theta joins down to JDBC adapter.
`void`	`testNonEquiJoinReverseConditionPlan()`
`void`	`testOverDefault()`	Test case for [CALCITE-1506] Push OVER Clause to underlying SQL via JDBC adapter.
`void`	`testOverDisallowPartial()`
`void`	`testOverNonSupportedDialect()`	Test case for [CALCITE-2206] JDBC adapter incorrectly pushes windowed aggregates down to HSQLDB.
`void`	`testOverRowsBetweenBoundFollowingAndFollowing()`
`void`	`testOverRowsBetweenBoundPrecedingAndCurrent()`
`void`	`testScalarSubQuery()`	Test case for [CALCITE-666] Anti-semi-joins against JDBC adapter give wrong results.
`void`	`testSubQueryWithSingleValue()`	Test case for [CALCITE-259] Using sub-queries in CASE statement against JDBC tables generates invalid Oracle SQL.
`void`	`testTableModifyDelete()`
`void`	`testTableModifyInsert()`	Test case for [CALCITE-1527] Support DML in the JDBC adapter.
`void`	`testTableModifyInsertMultiValues()`
`void`	`testTableModifyInsertWithSubQuery()`
`void`	`testTableModifyUpdate()`
`void`	`testUnionPlan()`
`void`	`testValuesPlan()`	VALUES is not pushed down, currently.

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - LOCK
```
private static final java.util.concurrent.locks.ReentrantLock LOCK
```
    Ensures that tests that are modifying data (doing DML) do not run at the same time.
- Constructor Detail
  - JdbcAdapterTest
```
public JdbcAdapterTest()
```
- Method Detail
  - testValuesPlan
```
public void testValuesPlan()
```
    VALUES is not pushed down, currently.
  - testUnionPlan
```
public void testUnionPlan()
```
  - testFilterUnionPlan
```
public void testFilterUnionPlan()
```
  - testInPlan
```
public void testInPlan()
```
  - testEquiJoinPlan
```
public void testEquiJoinPlan()
```
  - testNonEquiJoinPlan
```
public void testNonEquiJoinPlan()
```
    Test case for [CALCITE-631] Push theta joins down to JDBC adapter.
  - testNonEquiJoinReverseConditionPlan
```
public void testNonEquiJoinReverseConditionPlan()
```
  - testMixedJoinPlan
```
public void testMixedJoinPlan()
```
  - testMixedJoinWithOrPlan
```
public void testMixedJoinWithOrPlan()
```
  - testJoin3TablesPlan
```
public void testJoin3TablesPlan()
```
  - testCrossJoinWithJoinKeyPlan
```
public void testCrossJoinWithJoinKeyPlan()
```
  - testCartesianJoinWithoutKeyPlan
```
public void testCartesianJoinWithoutKeyPlan()
```
  - testCrossJoinWithJoinKeyAndFilterPlan
```
public void testCrossJoinWithJoinKeyAndFilterPlan()
```
  - testJoinPlan
```
public void testJoinPlan()
```
    Test case for [CALCITE-893] Theta join in JdbcAdapter.
  - testJoinPlan2
```
public void testJoinPlan2()
```
    Test case for [CALCITE-1372] JDBC adapter generates SQL with wrong field names.
  - testJoinCartesian
```
public void testJoinCartesian()
```
  - testJoinCartesianCount
```
public void testJoinCartesianCount()
```
  - testJdbcAggregate
```
public void testJdbcAggregate()
                       throws java.lang.Exception
```
    Test case for [CALCITE-657] NullPointerException when executing JdbcAggregate implement method.
    
    Throws:
    
    java.lang.Exception
  - testOverNonSupportedDialect
```
public void testOverNonSupportedDialect()
```
    Test case for [CALCITE-2206] JDBC adapter incorrectly pushes windowed aggregates down to HSQLDB.
  - testOverDefault
```
public void testOverDefault()
```
    Test case for [CALCITE-1506] Push OVER Clause to underlying SQL via JDBC adapter.
    Test runs only on Postgres; the default database, Hsqldb, does not support OVER.
  - testCast
```
public void testCast()
```
    Test case for [CALCITE-2305] JDBC adapter generates invalid casts on PostgreSQL, because PostgreSQL does not have TINYINT and DOUBLE types.
  - testOverRowsBetweenBoundFollowingAndFollowing
```
public void testOverRowsBetweenBoundFollowingAndFollowing()
```
  - testOverRowsBetweenBoundPrecedingAndCurrent
```
public void testOverRowsBetweenBoundPrecedingAndCurrent()
```
  - testOverDisallowPartial
```
public void testOverDisallowPartial()
```
  - testLastValueOver
```
public void testLastValueOver()
```
  - testSubQueryWithSingleValue
```
public void testSubQueryWithSingleValue()
```
    Test case for [CALCITE-259] Using sub-queries in CASE statement against JDBC tables generates invalid Oracle SQL.
  - testMetadataTables
```
public void testMetadataTables()
                        throws java.lang.Exception
```
    Test case for [CALCITE-865] Unknown table type causes NullPointerException in JdbcSchema. The issue occurred because of the "SYSTEM_INDEX" table type when run against PostgreSQL.
    
    Throws:
    
    java.lang.Exception
  - testScalarSubQuery
```
public void testScalarSubQuery()
```
    Test case for [CALCITE-666] Anti-semi-joins against JDBC adapter give wrong results.
  - exclusiveCleanDb
```
private JdbcAdapterTest.LockWrapper exclusiveCleanDb(java.sql.Connection c)
                                              throws java.sql.SQLException
```
    Acquires an exclusive connection to a test database, and cleans it.
    Cleans any previous TableModify states and creates one expense_fact instance with store_id = 666.
    Caller must close the returned wrapper, so that the next test can acquire the lock and use the database.
    
    Parameters:
    
    c - JDBC connection
    
    Throws:
    
    java.sql.SQLException
  - testTableModifyInsert
```
public void testTableModifyInsert()
                           throws java.lang.Exception
```
    Test case for [CALCITE-1527] Support DML in the JDBC adapter.
    
    Throws:
    
    java.lang.Exception
  - testTableModifyInsertMultiValues
```
public void testTableModifyInsertMultiValues()
                                      throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testTableModifyInsertWithSubQuery
```
public void testTableModifyInsertWithSubQuery()
                                       throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testTableModifyUpdate
```
public void testTableModifyUpdate()
                           throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testTableModifyDelete
```
public void testTableModifyDelete()
                           throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testColumnNullability
```
public void testColumnNullability()
                           throws java.lang.Exception
```
    Test case for [CALCITE-1572] JdbcSchema throws exception when detecting nullable columns.
    
    Throws:
    
    java.lang.Exception
  - pushBindParameters
```
public void pushBindParameters()
                        throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception

Class JdbcAdapterTest

Nested Class Summary

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

LOCK

Constructor Detail

JdbcAdapterTest

Method Detail

testValuesPlan

testUnionPlan

testFilterUnionPlan

testInPlan

testEquiJoinPlan

testNonEquiJoinPlan

testNonEquiJoinReverseConditionPlan

testMixedJoinPlan

testMixedJoinWithOrPlan

testJoin3TablesPlan

testCrossJoinWithJoinKeyPlan

testCartesianJoinWithoutKeyPlan

testCrossJoinWithJoinKeyAndFilterPlan

testJoinPlan

testJoinPlan2

testJoinCartesian

testJoinCartesianCount

testJdbcAggregate

testOverNonSupportedDialect

testOverDefault

testCast

testOverRowsBetweenBoundFollowingAndFollowing

testOverRowsBetweenBoundPrecedingAndCurrent

testOverDisallowPartial

testLastValueOver

testSubQueryWithSingleValue

testMetadataTables

testScalarSubQuery

exclusiveCleanDb

testTableModifyInsert

testTableModifyInsertMultiValues

testTableModifyInsertWithSubQuery

testTableModifyUpdate

testTableModifyDelete

testColumnNullability

pushBindParameters