Class TableFunctionTest


  • public class TableFunctionTest
    extends java.lang.Object
    Tests for user-defined table functions.
    See Also:
    UdfTest, Smalls
    • Constructor Detail

      • TableFunctionTest

        public TableFunctionTest()
    • Method Detail

      • 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.sql.SQLException
        Throws:
        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()