Package org.apache.calcite.test

Class TableFunctionTest

java.lang.Object

org.apache.calcite.test.TableFunctionTest

public class TableFunctionTest
extends java.lang.Object

Tests for user-defined table functions.

See Also:

UdfTest, Smalls

Constructor Summary

Constructors

Constructor	Description
TableFunctionTest()

Method Summary

Modifier and Type	Method	Description
private java.sql.Connection	getConnectionWithMultiplyFunction()
void	testCrossApply()
void	testInlineViewLateralTableFunction()	Test case for [CALCITE-2382] Sub-query lateral joined to table function.
void	testMultipleScannableTableFunctionWithNamedParameters()	As testScannableTableFunction() but with named parameters.
void	testScannableTableFunction()	Tests a table function that implements ScannableTable and returns a single column.
void	testScannableTableFunctionWithNamedParameters()	As testScannableTableFunction() but with named parameters.
void	testTableFunction()	Tests a table function with literal arguments.
void	testTableFunctionCursorInputs()	Tests a table function that takes cursor input.
void	testTableFunctionCursorsInputs()	Tests a table function that takes multiple cursor inputs.
void	testTableFunctionDynamicStructure()	Tests a table function that returns different row type based on actual call arguments.
void	testTableFunctionNonNullableMustBeLiterals()	Tests that non-nullable arguments of a table function must be provided as literals.
void	testUserDefinedTableFunction()
void	testUserDefinedTableFunction2()
void	testUserDefinedTableFunction3()
void	testUserDefinedTableFunction4()
void	testUserDefinedTableFunction5()
void	testUserDefinedTableFunction6()
void	testUserDefinedTableFunction7()
void	testUserDefinedTableFunction8()
private CalciteAssert.AssertThat	with()

Methods inherited from class java.lang.Object

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

Constructor Detail

TableFunctionTest

public TableFunctionTest()

Method Detail

with

private CalciteAssert.AssertThat with()

testTableFunction

public void testTableFunction()
                       throws java.sql.SQLException

Tests a table function with literal arguments.

Throws:

java.sql.SQLException

testScannableTableFunction

public void testScannableTableFunction()
                                throws java.sql.SQLException,
                                       java.lang.ClassNotFoundException

Tests a table function that implements ScannableTable and returns a single column.

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException

testScannableTableFunctionWithNamedParameters

public void testScannableTableFunctionWithNamedParameters()
                                                   throws java.sql.SQLException,
                                                          java.lang.ClassNotFoundException

As testScannableTableFunction() but with named parameters.

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException

testMultipleScannableTableFunctionWithNamedParameters

public void testMultipleScannableTableFunctionWithNamedParameters()
                                                           throws java.sql.SQLException,
                                                                  java.lang.ClassNotFoundException

As testScannableTableFunction() but with named parameters.

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException

testTableFunctionDynamicStructure

public void testTableFunctionDynamicStructure()
                                       throws java.sql.SQLException,
                                              java.lang.ClassNotFoundException

Tests a table function that returns different row type based on actual call arguments.

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException

testTableFunctionNonNullableMustBeLiterals

public void testTableFunctionNonNullableMustBeLiterals()
                                                throws java.sql.SQLException,
                                                       java.lang.ClassNotFoundException

Tests that non-nullable arguments of a table function must be provided as literals.

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException

getConnectionWithMultiplyFunction

private java.sql.Connection getConnectionWithMultiplyFunction()
                                                       throws java.lang.ClassNotFoundException,
                                                              java.sql.SQLException

Throws:

java.lang.ClassNotFoundException

java.sql.SQLException

testTableFunctionCursorInputs

public void testTableFunctionCursorInputs()
                                   throws java.sql.SQLException,
                                          java.lang.ClassNotFoundException

Tests a table function that takes cursor input.

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException

testTableFunctionCursorsInputs

public void testTableFunctionCursorsInputs()
                                    throws java.sql.SQLException,
                                           java.lang.ClassNotFoundException

Tests a table function that takes multiple cursor inputs.

Throws:

java.sql.SQLException

java.lang.ClassNotFoundException

testUserDefinedTableFunction

public void testUserDefinedTableFunction()

testUserDefinedTableFunction2

public void testUserDefinedTableFunction2()

testUserDefinedTableFunction3

public void testUserDefinedTableFunction3()

testUserDefinedTableFunction4

public void testUserDefinedTableFunction4()

testUserDefinedTableFunction5

public void testUserDefinedTableFunction5()

testUserDefinedTableFunction6

public void testUserDefinedTableFunction6()

testUserDefinedTableFunction7

public void testUserDefinedTableFunction7()

testUserDefinedTableFunction8

public void testUserDefinedTableFunction8()

testCrossApply

public void testCrossApply()

testInlineViewLateralTableFunction

public void testInlineViewLateralTableFunction()
                                        throws java.sql.SQLException

Test case for [CALCITE-2382] Sub-query lateral joined to table function.

Throws:

java.sql.SQLException