Class SqlToRelConverterTest

    • Constructor Detail

      • SqlToRelConverterTest

        public SqlToRelConverterTest()
    • Method Detail

      • getDiffRepos

        protected DiffRepository getDiffRepos()
        Description copied from class: SqlToRelTestBase
        Returns the default diff repository for this test, or null if there is no repository.

        The default implementation returns null.

        Sub-classes that want to use a diff repository can override. Sub-sub-classes can override again, inheriting test cases and overriding selected test results.

        And individual test cases can override by providing a different tester object.

        Overrides:
        getDiffRepos in class SqlToRelTestBase
        Returns:
        Diff repository
      • check

        protected final void check​(java.lang.String sql,
                                   java.lang.String plan)
      • testDotLiteralAfterNestedRow

        public void testDotLiteralAfterNestedRow()
      • testDotLiteralAfterRow

        public void testDotLiteralAfterRow()
      • testIntegerLiteral

        public void testIntegerLiteral()
      • testIntervalLiteralYearToMonth

        public void testIntervalLiteralYearToMonth()
      • testIntervalLiteralHourToMinute

        public void testIntervalLiteralHourToMinute()
      • testAliasList

        public void testAliasList()
      • testAliasList2

        public void testAliasList2()
      • testJoinUsingDynamicTable

        public void testJoinUsingDynamicTable()
      • testMultiAnd

        public void testMultiAnd()
        Tests that AND(x, AND(y, z)) gets flattened to AND(x, y, z).
      • testJoinOn

        public void testJoinOn()
      • testConditionOffByOneReversed

        public void testConditionOffByOneReversed()
      • testJoinOnExpression

        public void testJoinOnExpression()
      • testJoinOnIn

        public void testJoinOnIn()
      • testJoinOnInSubQuery

        public void testJoinOnInSubQuery()
      • testJoinOnExists

        public void testJoinOnExists()
      • testJoinUsing

        public void testJoinUsing()
      • testJoinUsingCompound

        public void testJoinUsingCompound()
      • testJoinNatural

        public void testJoinNatural()
      • testJoinNaturalNoCommonColumn

        public void testJoinNaturalNoCommonColumn()
      • testJoinNaturalMultipleCommonColumn

        public void testJoinNaturalMultipleCommonColumn()
      • testJoinWithUnion

        public void testJoinWithUnion()
      • testGroup

        public void testGroup()
      • testGroupByAlias

        public void testGroupByAlias()
      • testGroupByAliasOfSubExpressionsInProject

        public void testGroupByAliasOfSubExpressionsInProject()
      • testGroupByAliasEqualToColumnName

        public void testGroupByAliasEqualToColumnName()
      • testGroupByOrdinal

        public void testGroupByOrdinal()
      • testGroupByContainsLiterals

        public void testGroupByContainsLiterals()
      • testAliasInHaving

        public void testAliasInHaving()
      • testGroupJustOneAgg

        public void testGroupJustOneAgg()
      • testGroupExpressionsInsideAndOut

        public void testGroupExpressionsInsideAndOut()
      • testAggregateNoGroup

        public void testAggregateNoGroup()
      • testGroupEmpty

        public void testGroupEmpty()
      • testSingletonGroupingSet

        public void testSingletonGroupingSet()
      • testGroupingSets

        public void testGroupingSets()
      • testGroupingSetsWithCube

        public void testGroupingSetsWithCube()
      • testGroupingSetsWithRollupCube

        public void testGroupingSetsWithRollupCube()
      • testGroupingSetsProduct

        public void testGroupingSetsProduct()
      • testGroupingFunctionWithGroupBy

        public void testGroupingFunctionWithGroupBy()
        When the GROUPING function occurs with GROUP BY (effectively just one grouping set), we can translate it directly to 1.
      • testGroupingFunction

        public void testGroupingFunction()
      • testGroupByWithDuplicates

        public void testGroupByWithDuplicates()
        GROUP BY with duplicates.

        From SQL spec:

        NOTE 190 — That is, a simple group by clause that is not primitive may be transformed into a primitive group by clause by deleting all parentheses, and deleting extra commas as necessary for correct syntax. If there are no grouping columns at all (for example, GROUP BY (), ()), this is transformed to the canonical form GROUP BY ().
      • testDuplicateGroupingSets

        public void testDuplicateGroupingSets()
        GROUP BY with duplicate (and heavily nested) GROUPING SETS.
      • testGroupingSetsCartesianProduct

        public void testGroupingSetsCartesianProduct()
      • testGroupingSetsCartesianProduct2

        public void testGroupingSetsCartesianProduct2()
      • testRollupSimple

        public void testRollupSimple()
      • testRollup

        public void testRollup()
      • testRollupTuples

        public void testRollupTuples()
      • testCube

        public void testCube()
      • testGroupingSetsWith

        public void testGroupingSetsWith()
      • testHaving

        public void testHaving()
      • testGroupBug281

        public void testGroupBug281()
      • testGroupBug281b

        public void testGroupBug281b()
      • testGroupByExpression

        public void testGroupByExpression()
      • testAggDistinct

        public void testAggDistinct()
      • testAggFilter

        public void testAggFilter()
      • testAggFilterWithIn

        public void testAggFilterWithIn()
      • testFakeStar

        public void testFakeStar()
      • testSelectDistinct

        public void testSelectDistinct()
      • testSelectStreamPartitionDistinct

        public void testSelectStreamPartitionDistinct()
        As testSelectOverDistinct() but for streaming queries.
      • testSelectDistinctGroup

        public void testSelectDistinctGroup()
      • testSelectDistinctDup

        public void testSelectDistinctDup()
        Tests that if the clause of SELECT DISTINCT contains duplicate expressions, they are only aggregated once.
      • testSelectWithoutFrom

        public void testSelectWithoutFrom()
      • testDuplicateColumnsInSubQuery

        public void testDuplicateColumnsInSubQuery()
        Tests referencing columns from a sub-query that has duplicate column names. I think the standard says that this is illegal. We roll with it, and rename the second column to "e0".
      • testOrder

        public void testOrder()
      • testOrderBasedRepeatFields

        public void testOrderBasedRepeatFields()
        Tests that if a column occurs twice in ORDER BY, only the first key is kept.
      • testOrderDescNullsLast

        public void testOrderDescNullsLast()
      • testOrderByOrdinalDesc

        public void testOrderByOrdinalDesc()
      • testOrderDistinct

        public void testOrderDistinct()
      • testOrderByNegativeOrdinal

        public void testOrderByNegativeOrdinal()
      • testOrderByOrdinalInExpr

        public void testOrderByOrdinalInExpr()
      • testOrderByIdenticalExpr

        public void testOrderByIdenticalExpr()
      • testOrderByAlias

        public void testOrderByAlias()
      • testOrderByAliasInExpr

        public void testOrderByAliasInExpr()
      • testOrderByAliasOverrides

        public void testOrderByAliasOverrides()
      • testOrderByAliasDoesNotOverride

        public void testOrderByAliasDoesNotOverride()
      • testOrderBySameExpr

        public void testOrderBySameExpr()
      • testOrderUnion

        public void testOrderUnion()
      • testOrderUnionOrdinal

        public void testOrderUnionOrdinal()
      • testOrderUnionExprs

        public void testOrderUnionExprs()
      • testOrderOffsetFetch

        public void testOrderOffsetFetch()
      • testOrderOffsetFetchWithDynamicParameter

        public void testOrderOffsetFetchWithDynamicParameter()
      • testOffsetFetch

        public void testOffsetFetch()
      • testOffsetFetchWithDynamicParameter

        public void testOffsetFetchWithDynamicParameter()
      • testOffset

        public void testOffset()
      • testOffsetWithDynamicParameter

        public void testOffsetWithDynamicParameter()
      • testFetch

        public void testFetch()
      • testFetchWithDynamicParameter

        public void testFetchWithDynamicParameter()
      • testOrderGroup

        public void testOrderGroup()
      • testCountNoGroup

        public void testCountNoGroup()
      • testWith

        public void testWith()
      • testWithUnionOrder

        public void testWithUnionOrder()
      • testWithUnion

        public void testWithUnion()
      • testWithAlias

        public void testWithAlias()
      • testWithInsideWhereExists

        public void testWithInsideWhereExists()
      • testWithInsideWhereExistsRex

        public void testWithInsideWhereExistsRex()
      • testWithInsideWhereExistsDecorrelate

        public void testWithInsideWhereExistsDecorrelate()
      • testWithInsideWhereExistsDecorrelateRex

        public void testWithInsideWhereExistsDecorrelateRex()
      • testWithInsideScalarSubQuery

        public void testWithInsideScalarSubQuery()
      • testWithInsideScalarSubQueryRex

        public void testWithInsideScalarSubQueryRex()
      • testTableSubset

        public void testTableSubset()
      • testTableExpression

        public void testTableExpression()
      • testTableExtend

        public void testTableExtend()
      • testTableExtendSubset

        public void testTableExtendSubset()
      • testTableExtendExpression

        public void testTableExtendExpression()
      • testModifiableViewExtend

        public void testModifiableViewExtend()
      • testModifiableViewExtendSubset

        public void testModifiableViewExtendSubset()
      • testModifiableViewExtendExpression

        public void testModifiableViewExtendExpression()
      • testSelectViewExtendedColumnCollision

        public void testSelectViewExtendedColumnCollision()
      • testSelectViewExtendedColumnCaseSensitiveCollision

        public void testSelectViewExtendedColumnCaseSensitiveCollision()
      • testSelectViewExtendedColumnExtendedCollision

        public void testSelectViewExtendedColumnExtendedCollision()
      • testSelectViewExtendedColumnCaseSensitiveExtendedCollision

        public void testSelectViewExtendedColumnCaseSensitiveExtendedCollision()
      • testSelectViewExtendedColumnUnderlyingCollision

        public void testSelectViewExtendedColumnUnderlyingCollision()
      • testSelectViewExtendedColumnCaseSensitiveUnderlyingCollision

        public void testSelectViewExtendedColumnCaseSensitiveUnderlyingCollision()
      • testUpdateExtendedColumnCollision

        public void testUpdateExtendedColumnCollision()
      • testUpdateExtendedColumnCaseSensitiveCollision

        public void testUpdateExtendedColumnCaseSensitiveCollision()
      • testUpdateExtendedColumnModifiableViewCollision

        public void testUpdateExtendedColumnModifiableViewCollision()
      • testUpdateExtendedColumnModifiableViewCaseSensitiveCollision

        public void testUpdateExtendedColumnModifiableViewCaseSensitiveCollision()
      • testUpdateExtendedColumnModifiableViewExtendedCollision

        public void testUpdateExtendedColumnModifiableViewExtendedCollision()
      • testUpdateExtendedColumnModifiableViewExtendedCaseSensitiveCollision

        public void testUpdateExtendedColumnModifiableViewExtendedCaseSensitiveCollision()
      • testUpdateExtendedColumnModifiableViewUnderlyingCollision

        public void testUpdateExtendedColumnModifiableViewUnderlyingCollision()
      • testSelectModifiableViewConstraint

        public void testSelectModifiableViewConstraint()
      • testModifiableViewDdlExtend

        public void testModifiableViewDdlExtend()
      • testExplicitTable

        public void testExplicitTable()
      • testCollectionTable

        public void testCollectionTable()
      • testCollectionTableWithLateral

        public void testCollectionTableWithLateral()
      • testCollectionTableWithLateral2

        public void testCollectionTableWithLateral2()
      • testSnapshotOnTemporalTable

        public void testSnapshotOnTemporalTable()
      • testJoinTemporalTableOnSpecificTime

        public void testJoinTemporalTableOnSpecificTime()
      • testJoinTemporalTableOnColumnReference

        public void testJoinTemporalTableOnColumnReference()
      • testCrossJoinTemporalTable1

        public void testCrossJoinTemporalTable1()
        Lateral join with temporal table, both snapshot's input scan and snapshot's period reference outer columns. Should not decorrelate join.
      • testCrossJoinTemporalTable2

        public void testCrossJoinTemporalTable2()
        Lateral join with temporal table, snapshot's input scan reference outer columns, but snapshot's period is static. Should be able to decorrelate join.
      • testCrossJoinTemporalTable3

        public void testCrossJoinTemporalTable3()
        Lateral join with temporal table, snapshot's period reference outer columns. Should not decorrelate join.
      • testSample

        public void testSample()
      • testSampleQuery

        public void testSampleQuery()
      • testSampleBernoulli

        public void testSampleBernoulli()
      • testSampleBernoulliQuery

        public void testSampleBernoulliQuery()
      • testSampleSystem

        public void testSampleSystem()
      • testSampleSystemQuery

        public void testSampleSystemQuery()
      • testCollectionTableWithCursorParam

        public void testCollectionTableWithCursorParam()
      • testUnnest

        public void testUnnest()
      • testUnnestSubQuery

        public void testUnnestSubQuery()
      • testUnnestArrayAggPlan

        public void testUnnestArrayAggPlan()
      • testUnnestArrayPlan

        public void testUnnestArrayPlan()
      • testUnnestArrayPlanAs

        public void testUnnestArrayPlanAs()
      • testArrayOfRecord

        public void testArrayOfRecord()
      • testFlattenRecords

        public void testFlattenRecords()
      • testUnnestArray

        public void testUnnestArray()
      • testUnnestWithOrdinality

        public void testUnnestWithOrdinality()
      • testMultisetSubQuery

        public void testMultisetSubQuery()
      • testMultiset

        public void testMultiset()
      • testMultisetOfColumns

        public void testMultisetOfColumns()
      • testMultisetOfColumnsRex

        public void testMultisetOfColumnsRex()
      • testCorrelationJoin

        public void testCorrelationJoin()
      • testCorrelationJoinRex

        public void testCorrelationJoinRex()
      • testExists

        public void testExists()
      • testExistsCorrelated

        public void testExistsCorrelated()
      • testNotExistsCorrelated

        public void testNotExistsCorrelated()
      • testExistsCorrelatedDecorrelate

        public void testExistsCorrelatedDecorrelate()
      • testExistsCorrelatedDecorrelateRex

        public void testExistsCorrelatedDecorrelateRex()
      • testExistsCorrelatedLimit

        public void testExistsCorrelatedLimit()
      • testExistsCorrelatedLimitDecorrelate

        public void testExistsCorrelatedLimitDecorrelate()
      • testExistsCorrelatedLimitDecorrelateRex

        public void testExistsCorrelatedLimitDecorrelateRex()
      • testInValueListShort

        public void testInValueListShort()
      • testInValueListLong

        public void testInValueListLong()
      • testInUncorrelatedSubQuery

        public void testInUncorrelatedSubQuery()
      • testInUncorrelatedSubQueryRex

        public void testInUncorrelatedSubQueryRex()
      • testCompositeInUncorrelatedSubQueryRex

        public void testCompositeInUncorrelatedSubQueryRex()
      • testNotInUncorrelatedSubQuery

        public void testNotInUncorrelatedSubQuery()
      • testAllValueList

        public void testAllValueList()
      • testSomeValueList

        public void testSomeValueList()
      • testSome

        public void testSome()
      • testSomeWithEquality

        public void testSomeWithEquality()
      • testNotInUncorrelatedSubQueryRex

        public void testNotInUncorrelatedSubQueryRex()
      • testNotCaseInThreeClause

        public void testNotCaseInThreeClause()
      • testNotCaseInMoreClause

        public void testNotCaseInMoreClause()
      • testNotCaseInWithoutElse

        public void testNotCaseInWithoutElse()
      • testWhereInCorrelated

        public void testWhereInCorrelated()
      • testInUncorrelatedSubQueryInSelect

        public void testInUncorrelatedSubQueryInSelect()
      • testInUncorrelatedSubQueryInSelectRex

        public void testInUncorrelatedSubQueryInSelectRex()
      • testInUncorrelatedSubQueryInHavingRex

        public void testInUncorrelatedSubQueryInHavingRex()
      • testUncorrelatedScalarSubQueryInOrderRex

        public void testUncorrelatedScalarSubQueryInOrderRex()
      • testUncorrelatedScalarSubQueryInGroupOrderRex

        public void testUncorrelatedScalarSubQueryInGroupOrderRex()
      • testUncorrelatedScalarSubQueryInAggregateRex

        public void testUncorrelatedScalarSubQueryInAggregateRex()
      • testNotInUncorrelatedSubQueryInSelect

        public void testNotInUncorrelatedSubQueryInSelect()
        Plan should be as testInUncorrelatedSubQueryInSelect(), but with an extra NOT. Both queries require 3-valued logic.
      • testNotInUncorrelatedSubQueryInSelectRex

        public void testNotInUncorrelatedSubQueryInSelectRex()
      • testNotInUncorrelatedSubQueryInSelectNotNull

        public void testNotInUncorrelatedSubQueryInSelectNotNull()
        Since 'deptno NOT IN (SELECT deptno FROM dept)' can not be null, we generate a simpler plan.
      • testNotInUncorrelatedSubQueryInSelectMayBeNull

        public void testNotInUncorrelatedSubQueryInSelectMayBeNull()
        Since 'deptno NOT IN (SELECT mgr FROM emp)' can be null, we need a more complex plan, including counts of null and not-null keys.
      • testNotInUncorrelatedSubQueryInSelectDeduceNotNull

        public void testNotInUncorrelatedSubQueryInSelectDeduceNotNull()
        Even though "mgr" allows nulls, we can deduce from the WHERE clause that it will never be null. Therefore we can generate a simpler plan.
      • testNotInUncorrelatedSubQueryInSelectNotNullRex

        public void testNotInUncorrelatedSubQueryInSelectNotNullRex()
      • testUnnestSelect

        public void testUnnestSelect()
      • testUnnestSelectRex

        public void testUnnestSelectRex()
      • testJoinUnnest

        public void testJoinUnnest()
      • testJoinUnnestRex

        public void testJoinUnnestRex()
      • testLateral

        public void testLateral()
      • testLateralDecorrelate

        public void testLateralDecorrelate()
      • testLateralDecorrelateRex

        public void testLateralDecorrelateRex()
      • testLateralDecorrelateThetaRex

        public void testLateralDecorrelateThetaRex()
      • testNestedCorrelations

        public void testNestedCorrelations()
      • testNestedCorrelationsDecorrelated

        public void testNestedCorrelationsDecorrelated()
      • testNestedCorrelationsDecorrelatedRex

        public void testNestedCorrelationsDecorrelatedRex()
      • testElement

        public void testElement()
      • testElementInValues

        public void testElementInValues()
      • testUnionAll

        public void testUnionAll()
      • testUnion

        public void testUnion()
      • testUnionValues

        public void testUnionValues()
      • testUnionSubQuery

        public void testUnionSubQuery()
      • testIsDistinctFrom

        public void testIsDistinctFrom()
      • testIsNotDistinctFrom

        public void testIsNotDistinctFrom()
      • testNotLike

        public void testNotLike()
      • testTumble

        public void testTumble()
      • testNotNotIn

        public void testNotNotIn()
      • testOverMultiple

        public void testOverMultiple()
      • testCase

        public void testCase()
        Test one of the custom conversions which is recognized by the class of the operator (in this case, SqlCaseOperator).
      • testCharLength

        public void testCharLength()
        Tests one of the custom conversions which is recognized by the identity of the operator (in this case, SqlStdOperatorTable.CHARACTER_LENGTH).
      • testOverAvg

        public void testOverAvg()
      • testOverAvg2

        public void testOverAvg2()
      • testOverCountStar

        public void testOverCountStar()
      • testOverOrderWindow

        public void testOverOrderWindow()
        Tests that a window containing only ORDER BY is implicitly CURRENT ROW.
      • testOverNullTreatmentWindow

        public void testOverNullTreatmentWindow()
        Tests that a window with specifying null treatment.
      • testOverOrderFollowingWindow

        public void testOverOrderFollowingWindow()
        Tests that a window with a FOLLOWING bound becomes BETWEEN CURRENT ROW AND FOLLOWING.
      • testTumbleTable

        public void testTumbleTable()
      • testTumbleTableRowtimeNotFirstColumn

        public void testTumbleTableRowtimeNotFirstColumn()
        As testTumbleTable() but on a table where "rowtime" is at position 1 not 0.
      • testHopTable

        public void testHopTable()
      • testSessionTable

        public void testSessionTable()
      • testInterval

        public void testInterval()
      • testStream

        public void testStream()
      • testStreamGroupBy

        public void testStreamGroupBy()
      • testStreamWindowedAggregation

        public void testStreamWindowedAggregation()
      • testExplainAsXml

        public void testExplainAsXml()
      • testOffset0

        public void testOffset0()
      • testGroupByCaseSubQuery

        public void testGroupByCaseSubQuery()
        Test group-by CASE expression involving a non-query IN
      • testAggCaseSubQuery

        public void testAggCaseSubQuery()
        Test aggregate function on a CASE expression involving a non-query IN
      • testAggScalarSubQuery

        public void testAggScalarSubQuery()
      • testCorrelatedSubQueryInAggregate

        public void testCorrelatedSubQueryInAggregate()
      • testInsert

        public void testInsert()
      • testInsertSubset

        public void testInsertSubset()
      • testInsertWithCustomInitializerExpressionFactory

        public void testInsertWithCustomInitializerExpressionFactory()
      • testInsertSubsetWithCustomInitializerExpressionFactory

        public void testInsertSubsetWithCustomInitializerExpressionFactory()
      • testInsertBind

        public void testInsertBind()
      • testInsertBindSubset

        public void testInsertBindSubset()
      • testInsertBindWithCustomInitializerExpressionFactory

        public void testInsertBindWithCustomInitializerExpressionFactory()
      • testInsertBindSubsetWithCustomInitializerExpressionFactory

        public void testInsertBindSubsetWithCustomInitializerExpressionFactory()
      • testInsertSubsetView

        public void testInsertSubsetView()
      • testInsertExtendedColumn

        public void testInsertExtendedColumn()
      • testInsertBindExtendedColumn

        public void testInsertBindExtendedColumn()
      • testInsertExtendedColumnModifiableView

        public void testInsertExtendedColumnModifiableView()
      • testInsertBindExtendedColumnModifiableView

        public void testInsertBindExtendedColumnModifiableView()
      • testDelete

        public void testDelete()
      • testDeleteWhere

        public void testDeleteWhere()
      • testDeleteBind

        public void testDeleteBind()
      • testDeleteBindExtendedColumn

        public void testDeleteBindExtendedColumn()
      • testDeleteBindModifiableView

        public void testDeleteBindModifiableView()
      • testDeleteBindExtendedColumnModifiableView

        public void testDeleteBindExtendedColumnModifiableView()
      • testUpdate

        public void testUpdate()
      • testUpdateSubQuery

        public void testUpdateSubQuery()
      • testUpdateSubQueryWithNotIn

        public void testUpdateSubQueryWithNotIn()
        Similar to testUpdateSubQueryWithIn() but with not in instead of in.
      • testUpdateWhere

        public void testUpdateWhere()
      • testUpdateModifiableView

        public void testUpdateModifiableView()
      • testUpdateExtendedColumn

        public void testUpdateExtendedColumn()
      • testUpdateExtendedColumnModifiableView

        public void testUpdateExtendedColumnModifiableView()
      • testUpdateBind

        public void testUpdateBind()
      • testUpdateBind2

        public void testUpdateBind2()
      • testUpdateBindExtendedColumn

        public void testUpdateBindExtendedColumn()
      • testUpdateBindExtendedColumnModifiableView

        public void testUpdateBindExtendedColumnModifiableView()
      • testMerge

        public void testMerge()
      • testSelectView

        public void testSelectView()
      • testInsertView

        public void testInsertView()
      • testInsertModifiableView

        public void testInsertModifiableView()
      • testInsertSubsetModifiableView

        public void testInsertSubsetModifiableView()
      • testInsertBindModifiableView

        public void testInsertBindModifiableView()
      • testInsertBindSubsetModifiableView

        public void testInsertBindSubsetModifiableView()
      • testInsertWithCustomColumnResolving

        public void testInsertWithCustomColumnResolving()
      • testInsertWithCustomColumnResolving2

        public void testInsertWithCustomColumnResolving2()
      • testInsertViewWithCustomColumnResolving

        public void testInsertViewWithCustomColumnResolving()
      • testUpdateWithCustomColumnResolving

        public void testUpdateWithCustomColumnResolving()
      • testSimplifyNotExistsAggregateSubQuery

        public void testSimplifyNotExistsAggregateSubQuery()
      • testSimplifyNotExistsValuesSubQuery

        public void testSimplifyNotExistsValuesSubQuery()
      • testCorrelationScalarAggAndFilterRex

        public void testCorrelationScalarAggAndFilterRex()
      • testCorrelationExistsAndFilterRex

        public void testCorrelationExistsAndFilterRex()
      • testCorrelationExistsAndFilterThetaRex

        public void testCorrelationExistsAndFilterThetaRex()
        A theta join condition, unlike the equi-join condition in testCorrelationExistsAndFilterRex(), requires a value generator.
      • testCorrelationAggregateGroupSets

        public void testCorrelationAggregateGroupSets()
        Test case for decorrelating sub-query that has aggregate with grouping sets.
      • testCustomColumnResolving

        public void testCustomColumnResolving()
      • testCustomColumnResolving2

        public void testCustomColumnResolving2()
      • testCustomColumnResolving3

        public void testCustomColumnResolving3()
      • testCustomColumnResolving4

        public void testCustomColumnResolving4()
      • testCustomColumnResolving5

        public void testCustomColumnResolving5()
      • testCustomColumnResolvingWithSelectStar

        public void testCustomColumnResolvingWithSelectStar()
      • testCustomColumnResolvingWithSelectFieldNameDotStar

        public void testCustomColumnResolvingWithSelectFieldNameDotStar()
      • testSelectStarFromDynamicTable

        public void testSelectStarFromDynamicTable()
                                            throws java.lang.Exception
        Test case for Dynamic Table / Dynamic Star support [CALCITE-1150]
        Throws:
        java.lang.Exception
      • testReferDynamicStarInSelectOB

        public void testReferDynamicStarInSelectOB()
                                            throws java.lang.Exception
        Test case for Dynamic Table / Dynamic Star support [CALCITE-1150]
        Throws:
        java.lang.Exception
      • testDynamicStarInTableJoin

        public void testDynamicStarInTableJoin()
                                        throws java.lang.Exception
        Test case for Dynamic Table / Dynamic Star support [CALCITE-1150]
        Throws:
        java.lang.Exception
      • testDynamicNestedColumn

        public void testDynamicNestedColumn()
      • testNestedStructFieldAccess

        public void testNestedStructFieldAccess()
      • testNestedStructPrimitiveFieldAccess

        public void testNestedStructPrimitiveFieldAccess()
      • testNestedPrimitiveFieldAccess

        public void testNestedPrimitiveFieldAccess()
      • testArrayElementNestedPrimitive

        public void testArrayElementNestedPrimitive()
      • testArrayElementDoublyNestedPrimitive

        public void testArrayElementDoublyNestedPrimitive()
      • testArrayElementDoublyNestedStruct

        public void testArrayElementDoublyNestedStruct()
      • testArrayElementThreeTimesNestedStruct

        public void testArrayElementThreeTimesNestedStruct()
      • testGroupingSetsWithNestedColumn

        public void testGroupingSetsWithNestedColumn()
        Similar to testGroupByNestedColumn(), but with grouping sets.
      • testGroupByCubeWithNestedColumn

        public void testGroupByCubeWithNestedColumn()
        Similar to testGroupByNestedColumn(), but with cube.
      • testDynamicSchemaUnnest

        public void testDynamicSchemaUnnest()
      • testStarDynamicSchemaUnnest

        public void testStarDynamicSchemaUnnest()
      • testStarDynamicSchemaUnnest2

        public void testStarDynamicSchemaUnnest2()
      • testStarDynamicSchemaUnnestNestedSubQuery

        public void testStarDynamicSchemaUnnestNestedSubQuery()
      • testReferDynamicStarInSelectWhereGB

        public void testReferDynamicStarInSelectWhereGB()
                                                 throws java.lang.Exception
        Test case for Dynamic Table / Dynamic Star support [CALCITE-1150]
        Throws:
        java.lang.Exception
      • testDynamicStarInJoinAndSubQ

        public void testDynamicStarInJoinAndSubQ()
                                          throws java.lang.Exception
        Test case for Dynamic Table / Dynamic Star support [CALCITE-1150]
        Throws:
        java.lang.Exception
      • testStarJoinStaticDynTable

        public void testStarJoinStaticDynTable()
                                        throws java.lang.Exception
        Test case for Dynamic Table / Dynamic Star support [CALCITE-1150]
        Throws:
        java.lang.Exception
      • testGrpByColFromStarInSubQuery

        public void testGrpByColFromStarInSubQuery()
                                            throws java.lang.Exception
        Test case for Dynamic Table / Dynamic Star support [CALCITE-1150]
        Throws:
        java.lang.Exception
      • testDynStarInExistSubQ

        public void testDynStarInExistSubQ()
                                    throws java.lang.Exception
        Test case for Dynamic Table / Dynamic Star support [CALCITE-1150]
        Throws:
        java.lang.Exception
      • testWindowAndGroupByWithDynamicStar

        public void testWindowAndGroupByWithDynamicStar()
      • testAnyValueAggregateFunctionGroupBy

        public void testAnyValueAggregateFunctionGroupBy()
                                                  throws java.lang.Exception
        Throws:
        java.lang.Exception
      • testLarge

        public void testLarge()
      • testUnionInFrom

        public void testUnionInFrom()
      • testMatchRecognize1

        public void testMatchRecognize1()
      • testMatchRecognizeMeasures1

        public void testMatchRecognizeMeasures1()
      • testMatchRecognizeMeasures3

        public void testMatchRecognizeMeasures3()
      • testMatchRecognizePatternSkip1

        public void testMatchRecognizePatternSkip1()
      • testMatchRecognizeSubset1

        public void testMatchRecognizeSubset1()
      • testMatchRecognizePrevLast

        public void testMatchRecognizePrevLast()
      • testMatchRecognizePrevDown

        public void testMatchRecognizePrevDown()
      • testPrevClassifier

        public void testPrevClassifier()
      • testMatchRecognizeIn

        public void testMatchRecognizeIn()
      • testJsonValueExpressionOperator

        public void testJsonValueExpressionOperator()
      • testJsonExists

        public void testJsonExists()
      • testJsonValue

        public void testJsonValue()
      • testJsonQuery

        public void testJsonQuery()
      • testJsonType

        public void testJsonType()
      • testJsonPretty

        public void testJsonPretty()
      • testJsonDepth

        public void testJsonDepth()
      • testJsonLength

        public void testJsonLength()
      • testJsonKeys

        public void testJsonKeys()
      • testJsonArray

        public void testJsonArray()
      • testJsonArrayAgg1

        public void testJsonArrayAgg1()
      • testJsonArrayAgg2

        public void testJsonArrayAgg2()
      • testJsonArrayAgg3

        public void testJsonArrayAgg3()
      • testJsonArrayAgg4

        public void testJsonArrayAgg4()
      • testJsonObject

        public void testJsonObject()
      • testJsonObjectAgg

        public void testJsonObjectAgg()
      • testJsonPredicate

        public void testJsonPredicate()
      • testWithinGroup1

        public void testWithinGroup1()
      • testWithinGroup2

        public void testWithinGroup2()
      • testWithinGroup3

        public void testWithinGroup3()
      • testOrderByRemoval1

        public void testOrderByRemoval1()
      • testOrderByRemoval2

        public void testOrderByRemoval2()
      • testOrderByRemoval3

        public void testOrderByRemoval3()
      • testLeftJoinLateral1

        public void testLeftJoinLateral1()
        Tests left join lateral with using
      • testLeftJoinLateral2

        public void testLeftJoinLateral2()
        Tests left join lateral with natural join
      • testLeftJoinLateral3

        public void testLeftJoinLateral3()
        Tests left join lateral with on condition
      • testLeftJoinLateral4

        public void testLeftJoinLateral4()
        Tests left join lateral with multiple columns from outer
      • testLeftJoinLateral5

        public void testLeftJoinLateral5()
        Tests left join lateral with correlate variable coming from one level up join scope
      • testCrossJoinLateral1

        public void testCrossJoinLateral1()
        Tests cross join lateral with multiple columns from outer
      • testCrossJoinLateral2

        public void testCrossJoinLateral2()
        Tests cross join lateral with correlate variable coming from one level up join scope
      • testProjectAggregatesIgnoreNullsAndNot

        public void testProjectAggregatesIgnoreNullsAndNot()