Test Result : LeftSemiPushdownSuite

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

All Tests

Test nameDurationStatus
Aggregate: LeftAnti join no pushdown9 msPassed
Aggregate: LeftSemi join partial pushdown16 msPassed
Aggregate: LeftSemiAnti join no pushdown due to non-deterministic aggr expressions5 msPassed
Aggregate: LeftSemiAnti join non-correlated scalar subq aggr exprs15 msPassed
Aggregate: LeftSemiAnti join pushdown12 msPassed
LeftAnti no pushdown - join condition refers both leg - join type Cross5 msPassed
LeftAnti no pushdown - join condition refers both leg - join type Inner4 msPassed
LeftAnti no pushdown - join condition refers both leg - join type LeftOuter4 msPassed
LeftAnti no pushdown - join condition refers both leg - join type RightOuter4 msPassed
LeftAnti no pushdown - join condition refers left leg - join type for RightOuter4 msPassed
LeftAnti no pushdown - join condition refers none of the leg - join type Cross5 msPassed
LeftAnti no pushdown - join condition refers none of the leg - join type Inner5 msPassed
LeftAnti no pushdown - join condition refers none of the leg - join type LeftOuter4 msPassed
LeftAnti no pushdown - join condition refers none of the leg - join type RightOuter5 msPassed
LeftAnti no pushdown - join condition refers right leg - join type for LeftOuter3 msPassed
LeftAnti no pushdown when child join type is FullOuter5 msPassed
LeftAnti pushdown empty join cond join type Cross join cond None3 msPassed
LeftAnti pushdown empty join cond join type Cross join cond Some(('d = 'e))5 msPassed
LeftAnti pushdown empty join cond join type Inner join cond None3 msPassed
LeftAnti pushdown empty join cond join type Inner join cond Some(('d = 'e))4 msPassed
LeftAnti pushdown empty join cond join type LeftOuter join cond None3 msPassed
LeftAnti pushdown empty join cond join type LeftOuter join cond Some(('d = 'e))4 msPassed
LeftAnti pushdown empty join cond join type RightOuter join cond None3 msPassed
LeftAnti pushdown empty join cond join type RightOuter join cond Some(('d = 'e))4 msPassed
LeftAnti pushdown to left of join type: Cross join condition None4 msPassed
LeftAnti pushdown to left of join type: Cross join condition Some(('d = 'e))4 msPassed
LeftAnti pushdown to left of join type: Inner join condition None5 msPassed
LeftAnti pushdown to left of join type: Inner join condition Some(('d = 'e))4 msPassed
LeftAnti pushdown to left of join type: LeftOuter join condition None4 msPassed
LeftAnti pushdown to left of join type: LeftOuter join condition Some(('d = 'e))4 msPassed
LeftAnti pushdown to right of join type: Cross join condition None5 msPassed
LeftAnti pushdown to right of join type: Cross join condition Some(('e = 'd))4 msPassed
LeftAnti pushdown to right of join type: Inner join condition None6 msPassed
LeftAnti pushdown to right of join type: Inner join condition Some(('e = 'd))4 msPassed
LeftAnti pushdown to right of join type: RightOuter join condition None5 msPassed
LeftAnti pushdown to right of join type: RightOuter join condition Some(('e = 'd))4 msPassed
LeftSemi no pushdown - join condition refers both leg - join type Cross4 msPassed
LeftSemi no pushdown - join condition refers both leg - join type Inner6 msPassed
LeftSemi no pushdown - join condition refers both leg - join type LeftOuter8 msPassed
LeftSemi no pushdown - join condition refers both leg - join type RightOuter5 msPassed
LeftSemi no pushdown - join condition refers left leg - join type for RightOuter5 msPassed
LeftSemi no pushdown - join condition refers none of the leg - join type Cross4 msPassed
LeftSemi no pushdown - join condition refers none of the leg - join type Inner5 msPassed
LeftSemi no pushdown - join condition refers none of the leg - join type LeftOuter4 msPassed
LeftSemi no pushdown - join condition refers none of the leg - join type RightOuter4 msPassed
LeftSemi no pushdown - join condition refers right leg - join type for LeftOuter4 msPassed
LeftSemi no pushdown when child join type is FullOuter5 msPassed
LeftSemi pushdown empty join cond join type Cross join cond None3 msPassed
LeftSemi pushdown empty join cond join type Cross join cond Some(('d = 'e))4 msPassed
LeftSemi pushdown empty join cond join type Inner join cond None3 msPassed
LeftSemi pushdown empty join cond join type Inner join cond Some(('d = 'e))6 msPassed
LeftSemi pushdown empty join cond join type LeftOuter join cond None3 msPassed
LeftSemi pushdown empty join cond join type LeftOuter join cond Some(('d = 'e))5 msPassed
LeftSemi pushdown empty join cond join type RightOuter join cond None3 msPassed
LeftSemi pushdown empty join cond join type RightOuter join cond Some(('d = 'e))4 msPassed
LeftSemi pushdown to left of join type: Cross join condition None4 msPassed
LeftSemi pushdown to left of join type: Cross join condition Some(('d = 'e))4 msPassed
LeftSemi pushdown to left of join type: Inner join condition None4 msPassed
LeftSemi pushdown to left of join type: Inner join condition Some(('d = 'e))7 msPassed
LeftSemi pushdown to left of join type: LeftOuter join condition None4 msPassed
LeftSemi pushdown to left of join type: LeftOuter join condition Some(('d = 'e))5 msPassed
LeftSemi pushdown to right of join type: Cross join condition None6 msPassed
LeftSemi pushdown to right of join type: Cross join condition Some(('e = 'd))5 msPassed
LeftSemi pushdown to right of join type: Inner join condition None5 msPassed
LeftSemi pushdown to right of join type: Inner join condition Some(('e = 'd))5 msPassed
LeftSemi pushdown to right of join type: RightOuter join condition None4 msPassed
LeftSemi pushdown to right of join type: RightOuter join condition Some(('e = 'd))5 msPassed
LeftSemiAnti join over Window19 msPassed
LeftSemiAnti join over aggregate - no pushdown9 msPassed
Project: LeftSemiAnti join no pushdown - correlated scalar subq in projection list39 msPassed
Project: LeftSemiAnti join no pushdown because of non-deterministic proj exprs7 msPassed
Project: LeftSemiAnti join non correlated scalar subq12 msPassed
Project: LeftSemiAnti join pushdown12 msPassed
Unary: LeftAnti join pushdown - no pushdown7 msPassed
Unary: LeftSemi join pushdown - partial pushdown9 msPassed
Unary: LeftSemiAnti join pushdown10 msPassed
Unary: LeftSemiAnti join pushdown - empty join condition7 msPassed
Unary: LeftSemiAnti join pushdown - no pushdown8 msPassed
Union: LeftSemiAnti join no pushdown in self join scenario6 msPassed
Union: LeftSemiAnti join pushdown16 msPassed
Window: LeftAnti no pushdown24 msPassed
Window: LeftSemi partial pushdown21 msPassed