diff options
| author | Raimonds Simanovskis <raimonds.simanovskis@gmail.com> | 2010-10-21 11:22:48 +0300 |
|---|---|---|
| committer | Raimonds Simanovskis <raimonds.simanovskis@gmail.com> | 2010-10-21 11:22:48 +0300 |
| commit | ec6ac6654ed7eb678bb0b8f58fe3e7d9b932e297 (patch) | |
| tree | 93774c0a73e521476d0ecab1de9e09d7d7606a8e /lib/arel/visitors/oracle.rb | |
| parent | c66f025a8ebfd1d75ac6c5082df5cb4176f3a7bf (diff) | |
| download | rails-ec6ac6654ed7eb678bb0b8f58fe3e7d9b932e297.tar.gz rails-ec6ac6654ed7eb678bb0b8f58fe3e7d9b932e297.tar.bz2 rails-ec6ac6654ed7eb678bb0b8f58fe3e7d9b932e297.zip | |
generate correct select if only offset is present (in Oracle)
Diffstat (limited to 'lib/arel/visitors/oracle.rb')
| -rw-r--r-- | lib/arel/visitors/oracle.rb | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/lib/arel/visitors/oracle.rb b/lib/arel/visitors/oracle.rb index c691ce294e..212c18ada4 100644 --- a/lib/arel/visitors/oracle.rb +++ b/lib/arel/visitors/oracle.rb @@ -40,6 +40,20 @@ module Arel return "SELECT * FROM (#{super(o)}) WHERE ROWNUM <= #{limit}" end + if o.offset + o = o.dup + offset = o.offset + o.offset = nil + sql = super(o) + return <<-eosql + SELECT * FROM ( + SELECT raw_sql_.*, rownum raw_rnum_ + FROM (#{sql}) raw_sql_ + ) + WHERE #{visit offset} + eosql + end + super end |