Test Result : LimitPushdownSuite

0 failures (±0)
16 tests (±0)
Took 0.51 sec.

All Tests

Test nameDurationStatus
Union: limit to each side35 msPassed
Union: limit to each side with constant-foldable limit expressions38 msPassed
Union: limit to each side with the new limit number33 msPassed
Union: limit to each sides if children having larger limit values94 msPassed
Union: no limit to both sides if children having smaller limit values65 msPassed
full outer join where both sides are limited14 msPassed
full outer join where neither side is limited and both sides have same statistics27 msPassed
full outer join where neither side is limited and left side has larger statistics16 msPassed
full outer join where neither side is limited and right side has larger statistics11 msPassed
larger limits are not pushed on top of smaller ones in right outer join28 msPassed
left outer join61 msPassed
left outer join and left sides are limited17 msPassed
left outer join and right sides are limited18 msPassed
right outer join17 msPassed
right outer join and left sides are limited27 msPassed
right outer join and right sides are limited18 msPassed