Test Result : LeftSemiPushdownSuite

0 failures (±0)
82 tests (±0)
Took 1.8 sec.

All Tests

Test nameDurationStatus
Aggregate: LeftAnti join no pushdown25 msPassed
Aggregate: LeftSemi join partial pushdown58 msPassed
Aggregate: LeftSemiAnti join no pushdown due to non-deterministic aggr expressions13 msPassed
Aggregate: LeftSemiAnti join non-correlated scalar subq aggr exprs48 msPassed
Aggregate: LeftSemiAnti join pushdown29 msPassed
LeftAnti no pushdown - join condition refers both leg - join type Cross10 msPassed
LeftAnti no pushdown - join condition refers both leg - join type Inner10 msPassed
LeftAnti no pushdown - join condition refers both leg - join type LeftOuter34 msPassed
LeftAnti no pushdown - join condition refers both leg - join type RightOuter10 msPassed
LeftAnti no pushdown - join condition refers left leg - join type for RightOuter8 msPassed
LeftAnti no pushdown - join condition refers none of the leg - join type Cross9 msPassed
LeftAnti no pushdown - join condition refers none of the leg - join type Inner10 msPassed
LeftAnti no pushdown - join condition refers none of the leg - join type LeftOuter0.13 secPassed
LeftAnti no pushdown - join condition refers none of the leg - join type RightOuter9 msPassed
LeftAnti no pushdown - join condition refers right leg - join type for LeftOuter9 msPassed
LeftAnti no pushdown when child join type is FullOuter9 msPassed
LeftAnti pushdown empty join cond join type Cross join cond None6 msPassed
LeftAnti pushdown empty join cond join type Cross join cond Some(('d = 'e))9 msPassed
LeftAnti pushdown empty join cond join type Inner join cond None5 msPassed
LeftAnti pushdown empty join cond join type Inner join cond Some(('d = 'e))9 msPassed
LeftAnti pushdown empty join cond join type LeftOuter join cond None6 msPassed
LeftAnti pushdown empty join cond join type LeftOuter join cond Some(('d = 'e))10 msPassed
LeftAnti pushdown empty join cond join type RightOuter join cond None6 msPassed
LeftAnti pushdown empty join cond join type RightOuter join cond Some(('d = 'e))9 msPassed
LeftAnti pushdown to left of join type: Cross join condition None10 msPassed
LeftAnti pushdown to left of join type: Cross join condition Some(('d = 'e))10 msPassed
LeftAnti pushdown to left of join type: Inner join condition None11 msPassed
LeftAnti pushdown to left of join type: Inner join condition Some(('d = 'e))10 msPassed
LeftAnti pushdown to left of join type: LeftOuter join condition None10 msPassed
LeftAnti pushdown to left of join type: LeftOuter join condition Some(('d = 'e))9 msPassed
LeftAnti pushdown to right of join type: Cross join condition None9 msPassed
LeftAnti pushdown to right of join type: Cross join condition Some(('e = 'd))10 msPassed
LeftAnti pushdown to right of join type: Inner join condition None9 msPassed
LeftAnti pushdown to right of join type: Inner join condition Some(('e = 'd))10 msPassed
LeftAnti pushdown to right of join type: RightOuter join condition None8 msPassed
LeftAnti pushdown to right of join type: RightOuter join condition Some(('e = 'd))11 msPassed
LeftSemi no pushdown - join condition refers both leg - join type Cross10 msPassed
LeftSemi no pushdown - join condition refers both leg - join type Inner12 msPassed
LeftSemi no pushdown - join condition refers both leg - join type LeftOuter29 msPassed
LeftSemi no pushdown - join condition refers both leg - join type RightOuter11 msPassed
LeftSemi no pushdown - join condition refers left leg - join type for RightOuter10 msPassed
LeftSemi no pushdown - join condition refers none of the leg - join type Cross10 msPassed
LeftSemi no pushdown - join condition refers none of the leg - join type Inner0.14 secPassed
LeftSemi no pushdown - join condition refers none of the leg - join type LeftOuter6 msPassed
LeftSemi no pushdown - join condition refers none of the leg - join type RightOuter7 msPassed
LeftSemi no pushdown - join condition refers right leg - join type for LeftOuter16 msPassed
LeftSemi no pushdown when child join type is FullOuter11 msPassed
LeftSemi pushdown empty join cond join type Cross join cond None5 msPassed
LeftSemi pushdown empty join cond join type Cross join cond Some(('d = 'e))9 msPassed
LeftSemi pushdown empty join cond join type Inner join cond None7 msPassed
LeftSemi pushdown empty join cond join type Inner join cond Some(('d = 'e))12 msPassed
LeftSemi pushdown empty join cond join type LeftOuter join cond None5 msPassed
LeftSemi pushdown empty join cond join type LeftOuter join cond Some(('d = 'e))10 msPassed
LeftSemi pushdown empty join cond join type RightOuter join cond None5 msPassed
LeftSemi pushdown empty join cond join type RightOuter join cond Some(('d = 'e))10 msPassed
LeftSemi pushdown to left of join type: Cross join condition None10 msPassed
LeftSemi pushdown to left of join type: Cross join condition Some(('d = 'e))11 msPassed
LeftSemi pushdown to left of join type: Inner join condition None9 msPassed
LeftSemi pushdown to left of join type: Inner join condition Some(('d = 'e))31 msPassed
LeftSemi pushdown to left of join type: LeftOuter join condition None12 msPassed
LeftSemi pushdown to left of join type: LeftOuter join condition Some(('d = 'e))14 msPassed
LeftSemi pushdown to right of join type: Cross join condition None9 msPassed
LeftSemi pushdown to right of join type: Cross join condition Some(('e = 'd))11 msPassed
LeftSemi pushdown to right of join type: Inner join condition None10 msPassed
LeftSemi pushdown to right of join type: Inner join condition Some(('e = 'd))12 msPassed
LeftSemi pushdown to right of join type: RightOuter join condition None9 msPassed
LeftSemi pushdown to right of join type: RightOuter join condition Some(('e = 'd))10 msPassed
LeftSemiAnti join over Window54 msPassed
LeftSemiAnti join over aggregate - no pushdown24 msPassed
Project: LeftSemiAnti join no pushdown - correlated scalar subq in projection list81 msPassed
Project: LeftSemiAnti join no pushdown because of non-deterministic proj exprs30 msPassed
Project: LeftSemiAnti join non correlated scalar subq43 msPassed
Project: LeftSemiAnti join pushdown29 msPassed
Unary: LeftAnti join pushdown - no pushdown18 msPassed
Unary: LeftSemi join pushdown - partial pushdown0.14 secPassed
Unary: LeftSemiAnti join pushdown21 msPassed
Unary: LeftSemiAnti join pushdown - empty join condition12 msPassed
Unary: LeftSemiAnti join pushdown - no pushdown18 msPassed
Union: LeftSemiAnti join no pushdown in self join scenario61 msPassed
Union: LeftSemiAnti join pushdown0.1 secPassed
Window: LeftAnti no pushdown56 msPassed
Window: LeftSemi partial pushdown46 msPassed