diff options
author | Aaron Patterson <aaron.patterson@gmail.com> | 2012-02-17 10:12:13 -0800 |
---|---|---|
committer | Aaron Patterson <aaron.patterson@gmail.com> | 2012-02-17 10:12:13 -0800 |
commit | cbdc7e72ba48672f6c43627de1d081e61c6c10b0 (patch) | |
tree | c6dddba78f9fd5d5eb32b7fdfc3476c3c080e3f9 /lib/arel | |
parent | eebf5d77aad712fad27a3adf70cd0ab2e8246668 (diff) | |
parent | d1c9c46c96c016b6561018d8017261feea3912a7 (diff) | |
download | rails-cbdc7e72ba48672f6c43627de1d081e61c6c10b0.tar.gz rails-cbdc7e72ba48672f6c43627de1d081e61c6c10b0.tar.bz2 rails-cbdc7e72ba48672f6c43627de1d081e61c6c10b0.zip |
Merge pull request #100 from babinho/master
Fixing oracle issue with limit and offset if query is ordered
Diffstat (limited to 'lib/arel')
-rw-r--r-- | lib/arel/visitors/oracle.rb | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/lib/arel/visitors/oracle.rb b/lib/arel/visitors/oracle.rb index 375f7dbfe9..1441a20dbc 100644 --- a/lib/arel/visitors/oracle.rb +++ b/lib/arel/visitors/oracle.rb @@ -25,9 +25,8 @@ module Arel SELECT * FROM ( SELECT raw_sql_.*, rownum raw_rnum_ FROM (#{sql}) raw_sql_ - WHERE rownum <= #{offset.expr.to_i + limit} ) - WHERE #{visit offset} + WHERE raw_rnum_ between #{offset.expr.to_i + 1 } and #{offset.expr.to_i + limit} eosql end |