Package org.apache.calcite.test

Class SqlOperatorTest.TesterImpl

java.lang.Object

org.apache.calcite.sql.test.AbstractSqlTester

org.apache.calcite.test.SqlOperatorTest.TesterImpl

All Implemented Interfaces:

AutoCloseable, SqlTester

Enclosing class:

SqlOperatorTest

protected static class SqlOperatorTest.TesterImpl
extends AbstractSqlTester

Implementation of SqlTester based on a JDBC connection.

Nested Class Summary

Nested classes/interfaces inherited from interface org.apache.calcite.sql.test.SqlTester

SqlTester.ParameterChecker, SqlTester.ResultChecker, SqlTester.TypeChecker, SqlTester.ValidatedNodeConsumer, SqlTester.ValidatedNodeFunction<R>, SqlTester.VmName

Field Summary

Fields

Modifier and Type	Field	Description
static final TryThreadLocal<RelDataTypeSystem>	THREAD_TYPE_SYSTEM	Assign a type system object to this thread-local, pass the name of the field as the CalciteConnectionProperty.TYPE_SYSTEM property, and any connection you make in the same thread will use your type system.

Constructor Summary

Constructors

Constructor	Description
TesterImpl()

Method Summary

Modifier and Type	Method	Description
void	assertExceptionIsThrown(SqlTestFactory factory, StringAndPos sap, @Nullable String expectedMsgPattern)	Checks that a query is valid, or, if invalid, throws the right message at the right location.
void	assertExceptionIsThrown(SqlTestFactory factory, StringAndPos sap, @Nullable String expectedMsgPattern, boolean runtime)
void	check(SqlTestFactory factory, String query, SqlTester.TypeChecker typeChecker, SqlTester.ParameterChecker parameterChecker, SqlTester.ResultChecker resultChecker)	Tests that a SQL query returns a result of expected type and value.
void	checkAggFails(SqlTestFactory factory, String expr, String[] inputValues, String expectedError, boolean runtime)	Tests that an aggregate expression fails at run time.
void	checkFails(SqlTestFactory factory, StringAndPos sap, String expectedError, boolean runtime)	Tests that a scalar SQL expression fails at run time.

Methods inherited from class org.apache.calcite.sql.test.AbstractSqlTester

assertConvertsTo, buildQuery, buildQuery2, buildQueryAgg, checkAgg, checkColumnType, checkParseEx, checkQueryFails, checkWinAgg, close, convertSqlToRel2, createFieldTrimmer, forEachQuery, getColumnType, getResultType, parseExpression, parseQuery, setFor, trimRelNode, validateAndApply, validateAndThen

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.apache.calcite.sql.test.SqlTester

check, checkFails, convertSqlToRel

Field Details

THREAD_TYPE_SYSTEM

public static final TryThreadLocal<RelDataTypeSystem> THREAD_TYPE_SYSTEM

Assign a type system object to this thread-local, pass the name of the field as the CalciteConnectionProperty.TYPE_SYSTEM property, and any connection you make in the same thread will use your type system.

Constructor Details

TesterImpl

public TesterImpl()

Method Details

check

public void check(SqlTestFactory factory,
 String query,
 SqlTester.TypeChecker typeChecker,
 SqlTester.ParameterChecker parameterChecker,
 SqlTester.ResultChecker resultChecker)

Description copied from interface: SqlTester

Tests that a SQL query returns a result of expected type and value. Checking of type and value are abstracted using SqlTester.TypeChecker and SqlTester.ResultChecker functors.

Specified by:

check in interface SqlTester

Overrides:

check in class AbstractSqlTester

Parameters:

factory - Factory

query - SQL query

typeChecker - Checks whether the result is the expected type

parameterChecker - Checks whether the parameters are of expected types

resultChecker - Checks whether the result has the expected value

checkFails

public void checkFails(SqlTestFactory factory,
 StringAndPos sap,
 String expectedError,
 boolean runtime)

Description copied from interface: SqlTester

Tests that a scalar SQL expression fails at run time.

Specified by:

checkFails in interface SqlTester

Overrides:

checkFails in class AbstractSqlTester

Parameters:

factory - Factory

sap - SQL scalar expression

expectedError - Pattern for expected error. If !runtime, must include an error location.

runtime - If true, must fail at runtime; if false, must fail at validate time

checkAggFails

public void checkAggFails(SqlTestFactory factory,
 String expr,
 String[] inputValues,
 String expectedError,
 boolean runtime)

Description copied from interface: SqlTester

Tests that an aggregate expression fails at run time.

Specified by:

checkAggFails in interface SqlTester

Overrides:

checkAggFails in class AbstractSqlTester

Parameters:

factory - Factory

expr - An aggregate expression

inputValues - Array of input values

expectedError - Pattern for expected error

runtime - If true, must fail at runtime; if false, must fail at validate time

assertExceptionIsThrown

public void assertExceptionIsThrown(SqlTestFactory factory,
 StringAndPos sap,
 @Nullable String expectedMsgPattern)

Description copied from interface: SqlTester

Checks that a query is valid, or, if invalid, throws the right message at the right location.

If expectedMsgPattern is null, the query must succeed.

If expectedMsgPattern is not null, the query must fail, and give an error location of (expectedLine, expectedColumn) through (expectedEndLine, expectedEndColumn).

Specified by:

assertExceptionIsThrown in interface SqlTester

Overrides:

assertExceptionIsThrown in class AbstractSqlTester

Parameters:

factory - Factory

sap - SQL statement

expectedMsgPattern - If this parameter is null the query must be

assertExceptionIsThrown

public void assertExceptionIsThrown(SqlTestFactory factory,
 StringAndPos sap,
 @Nullable String expectedMsgPattern,
 boolean runtime)