test/visitors/test_oracle.rb in arel-3.0.3 vs test/visitors/test_oracle.rb in arel-4.0.0.beta1
- old
+ new
@@ -100,12 +100,11 @@
sql = @visitor.accept stmt
sql.must_be_like %{
SELECT * FROM (
SELECT raw_sql_.*, rownum raw_rnum_
FROM (SELECT) raw_sql_
- WHERE rownum <= 20
)
- WHERE raw_rnum_ > 10
+ WHERE raw_rnum_ >= 11 and rownum <= 10
}
end
it 'is idempotent with different subquery' do
stmt = Nodes::SelectStatement.new