Test Result : LimitPushdownSuite

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

All Tests

Test nameDurationStatus
Union: limit to each side18 msPassed
Union: limit to each side with constant-foldable limit expressions8 msPassed
Union: limit to each side with the new limit number9 msPassed
Union: limit to each sides if children having larger limit values18 msPassed
Union: no limit to both sides if children having smaller limit values13 msPassed
full outer join where both sides are limited11 msPassed
full outer join where neither side is limited and both sides have same statistics15 msPassed
full outer join where neither side is limited and left side has larger statistics9 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 join16 msPassed
left outer join and left sides are limited13 msPassed
left outer join and right sides are limited14 msPassed
right outer join11 msPassed
right outer join and left sides are limited11 msPassed
right outer join and right sides are limited9 msPassed