AbstractTestJoinQueries

ElementMissed InstructionsCov.Missed BranchesCov.MissedCxtyMissedLinesMissedMethods
Total2,777 of 2,7770%18 of 180%176176761761167167
testJoinWithMultipleInSubqueryClauses()1790%40%33282811
testJoinWithScalarSubqueryToBeExecutedAsPostJoinFilter()1660%n/a11242411
testShuffledStatsWithInnerJoin()1500%60%44323211
testJoinWithInSubqueryToBeExecutedAsPostJoinFilter()1190%20%22171711
testJoinWithMultipleScalarSubqueryClauses()1140%n/a11171711
testJoinWithScalarSubqueryToBeExecutedAsPostJoinFilterWithEmptyInnerTable()1080%n/a11111111
testRowNumberJoin()880%n/a11121211
testNonEqualityLeftJoin()870%n/a11242411
testNonEqualityRightJoin()790%n/a11222211
testNonEqualityJoin()700%n/a11232311
testLimitWithJoin()650%n/a11171711
testJoinsWithTrueJoinCondition()650%n/a11171711
testLateralJoin()650%n/a11171711
testJoinCriteriaCoercion()620%n/a11151511
testSemiJoin()590%n/a11191911
testNonEqualityFullJoin()530%n/a11141411
testOuterJoinWithComplexCorrelatedSubquery()520%n/a11101011
testJoinsWithNullsInternal(Session)460%n/a11101011
testJoinWithNonDeterministicLessThan()430%20%22101011
testOuterJoinWithCommonExpression()380%n/a116611
testJoinWithLessThanInJoinClause()340%n/a11101011
testJoinWithGreaterThanInJoinClause()340%n/a11101011
testNonDeterministicJoinPredicatePushdown()320%40%336611
getTableRowCount(String)280%n/a115511
testJoinUsingSymbolsFromJustOneSideOfJoin()250%n/a117711
testSemiJoinWithGroupBy()250%n/a119911
testJoinsWithNullInferencing()240%n/a117711
testInnerJoinWithEmptyBuildSide()210%n/a117711
testJoinWithComplexExpressions3()200%n/a117711
testImplicitCrossJoin()190%n/a117711
testJoinWithExpressionsThatMayReturnNull()170%n/a115511
testSimpleFullJoin()170%n/a115511
testJoinWithNormalization()160%n/a116611
testLeftJoinWithEmptyInnerTable()160%n/a116611
testRightJoinWithEmptyInnerTable()160%n/a116611
testExecuteUsingComplexJoinCriteria()160%n/a116611
testExecuteUsingWithSubqueryInJoin()160%n/a116611
testSemiJoinNullHandling()140%n/a115511
testJoinWithMultipleLessThanPredicatesDifferentOrders()130%n/a115511
testJoinWithLessThanOnDatesInJoinClause()130%n/a114411
testOuterJoinWithExpression()130%n/a115511
testSimpleRightJoin()130%n/a115511
testCrossJoinWithNulls()130%n/a114411
testFullJoinWithEmptyBuildSide()130%n/a115511
noJoinReordering()130%n/a114411
testSimpleLeftJoin()110%n/a114411
testRightJoinWithEmptyBuildSide()110%n/a115511
testLeftJoinWithEmptyBuildSide()110%n/a115511
testNonEqualityJoinWithTryInFilter()90%n/a113311
testFullJoinNormalizedToLeft()90%n/a113311
testFullJoinNormalizedToRight()90%n/a113311
testAntiJoinNullHandling()90%n/a113311
testJoinsWithNulls()90%n/a113311
testOuterJoinWithNullsOnProbe()80%n/a113311
optimizeJoinForEmptyBuildRuntime()80%n/a113311
inferNullsFromJoinFiltersWithUseFunctionMetadata()80%n/a113311
testJoinWithRangePredicatesInJoinClause()70%n/a113311
testSimpleJoin()70%n/a113311
testRightJoinNormalizedToInner()70%n/a113311
testCrossJoinUnion()70%n/a113311
testBuildFilteredLeftJoin()60%n/a112211
testProbeFilteredLeftJoin()60%n/a112211
testBuildFilteredRightJoin()60%n/a112211
testProbeFilteredRightJoin()60%n/a112211
testInnerJoinWithEmptyProbeSide()60%n/a113311
testRightJoinWithEmptyProbeSide()60%n/a113311
testRowFieldAccessorInJoin()50%n/a112211
testJoinUsing()50%n/a112211
testWildcardFromJoin()50%n/a112211
testQualifiedWildcardFromJoin()50%n/a112211
testNonEqualityJoinWithScalarRequiringSessionParameter()50%n/a112211
testJoinUsingMultipleFields()50%n/a112211
testColocatedJoinWithLocalUnion()50%n/a112211
testJoinWithScalarSubqueryInOnClause()50%n/a112211
testFullJoinWithRightConstantEquality()50%n/a112211
testFullJoinWithLeftConstantEquality()50%n/a112211
testSimpleFullJoinWithLeftConstantEquality()50%n/a112211
testSimpleFullJoinWithRightConstantEquality()50%n/a112211
testJoinWithStatefulFilterFunction()50%n/a112211
testJoinUnaliasedSubqueries()50%n/a112211
testWithSelfJoin()50%n/a112211
testInSubqueryWithCrossJoin()50%n/a112211
testCrossJoinsWithWhereClause()50%n/a112211
testCrossJoinUnnestWithUnion()50%n/a112211
lambda$testOuterJoinWithComplexCorrelatedSubquery$0(String)50%n/a111111
testJoinWithMultiFieldGroupBy()40%n/a112211
testDistinctJoin()40%n/a112211
testJoinCoercion()40%n/a112211
testJoinCoercionOnEqualityComparison()40%n/a112211
testJoinWithRightConstantEquality()40%n/a112211
testJoinWithLeftConstantEquality()40%n/a112211
testSimpleJoinWithLeftConstantEquality()40%n/a112211
testSimpleJoinWithRightConstantEquality()40%n/a112211
testJoinDoubleClauseWithLeftOverlap()40%n/a112211
testJoinDoubleClauseWithRightOverlap()40%n/a112211
testJoinWithAlias()40%n/a112211
testJoinWithConstantExpression()40%n/a112211
testJoinWithConstantTrueExpressionWithCoercion()40%n/a112211
testJoinWithCanonicalizedConstantTrueExpressionWithCoercion()40%n/a112211
testJoinWithConstantPredicatePushDown()40%n/a112211
testJoinWithInferredFalseJoinClause()40%n/a112211
testJoinWithReversedComparison()40%n/a112211
testJoinWithComplexExpressions()40%n/a112211
testJoinWithComplexExpressions2()40%n/a112211
testSelfJoin()40%n/a112211
testJoinAggregations()40%n/a112211
testJoinOnMultipleFields()40%n/a112211
testJoinWithNonJoinExpression()40%n/a112211
testJoinWithNullValues()40%n/a112211
testLeftFilteredJoin()40%n/a112211
testRightFilteredJoin()40%n/a112211
testJoinWithFullyPushedDownJoinClause()40%n/a112211
testJoinPredicateMoveAround()40%n/a112211
testLeftJoinNormalizedToInner()40%n/a112211
testLeftJoinWithRightConstantEquality()40%n/a112211
testLeftJoinWithLeftConstantEquality()40%n/a112211
testSimpleLeftJoinWithLeftConstantEquality()40%n/a112211
testSimpleLeftJoinWithRightConstantEquality()40%n/a112211
testDoubleFilteredLeftJoinWithRightConstantEquality()40%n/a112211
testDoubleFilteredLeftJoinWithLeftConstantEquality()40%n/a112211
testLeftJoinDoubleClauseWithLeftOverlap()40%n/a112211
testLeftJoinDoubleClauseWithRightOverlap()40%n/a112211
testLeftJoinPredicateMoveAround()40%n/a112211
testLeftJoinEqualityInference()40%n/a112211
testLeftJoinWithNullValues()40%n/a112211
testRightJoinWithRightConstantEquality()40%n/a112211
testRightJoinWithLeftConstantEquality()40%n/a112211
testDoubleFilteredRightJoinWithRightConstantEquality()40%n/a112211
testDoubleFilteredRightJoinWithLeftConstantEquality()40%n/a112211
testSimpleRightJoinWithLeftConstantEquality()40%n/a112211
testSimpleRightJoinWithRightConstantEquality()40%n/a112211
testRightJoinDoubleClauseWithLeftOverlap()40%n/a112211
testRightJoinDoubleClauseWithRightOverlap()40%n/a112211
testRightJoinPredicateMoveAround()40%n/a112211
testRightJoinEqualityInference()40%n/a112211
testRightJoinWithNullValues()40%n/a112211
testJoinWithGroupByAsProbe()40%n/a112211
testJoinEffectivePredicateWithNoRanges()40%n/a112211
testJoinProjectionPushDown()40%n/a112211
testUnionWithJoin()40%n/a112211
testUnionWithAggregationAndJoin()40%n/a112211
testUnionWithJoinOnNonTranslatableSymbols()40%n/a112211
testRandCrossJoins()40%n/a112211
testCrossJoins()40%n/a112211
testCrossJoinEmptyProbePage()40%n/a112211
testCrossJoinEmptyBuildPage()40%n/a112211
testSimpleCrossJoins()40%n/a112211
testCrossJoinsDifferentDataTypes()40%n/a112211
testJoinOnConstantExpression()40%n/a112211
testJoinConstantPropagation()40%n/a112211
testAntiJoin()40%n/a112211
testSemiJoinLimitPushDown()40%n/a112211
testSemiJoinUnionNullHandling()40%n/a112211
testSemiJoinAggregationNullHandling()40%n/a112211
testSemiJoinUnionAggregationNullHandling()40%n/a112211
testSemiJoinAggregationUnionNullHandling()40%n/a112211
testJoinPredicatePushdown()40%n/a112211
testLeftJoinAsInnerPredicatePushdown()40%n/a112211
testPlainLeftJoinPredicatePushdown()40%n/a112211
testLeftJoinPredicatePushdownWithSelfEquality()40%n/a112211
testLeftJoinPredicatePushdownWithNullConstant()40%n/a112211
testRightJoinAsInnerPredicatePushdown()40%n/a112211
testPlainRightJoinPredicatePushdown()40%n/a112211
testRightJoinPredicatePushdownWithSelfEquality()40%n/a112211
testPredicatePushdownJoinEqualityGroups()40%n/a112211
testSemiJoinPredicateMoveAround()40%n/a112211
AbstractTestJoinQueries()30%n/a111111