Test Result : LimitPushdownSuite

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

All Tests

Test nameDurationStatus
Union: limit to each side11 msPassed
Union: limit to each side with constant-foldable limit expressions6 msPassed
Union: limit to each side with the new limit number6 msPassed
Union: limit to each sides if children having larger limit values10 msPassed
Union: no limit to both sides if children having smaller limit values9 msPassed
full outer join where both sides are limited7 msPassed
full outer join where neither side is limited and both sides have same statistics0.19 secPassed
full outer join where neither side is limited and left side has larger statistics7 msPassed
full outer join where neither side is limited and right side has larger statistics7 msPassed
larger limits are not pushed on top of smaller ones in right outer join10 msPassed
left outer join8 msPassed
left outer join and left sides are limited7 msPassed
left outer join and right sides are limited9 msPassed
right outer join8 msPassed
right outer join and left sides are limited9 msPassed
right outer join and right sides are limited9 msPassed