From ec6ac6654ed7eb678bb0b8f58fe3e7d9b932e297 Mon Sep 17 00:00:00 2001
From: Raimonds Simanovskis <raimonds.simanovskis@gmail.com>
Date: Thu, 21 Oct 2010 11:22:48 +0300
Subject: generate correct select if only offset is present (in Oracle)

---
 lib/arel/visitors/oracle.rb | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

(limited to 'lib/arel/visitors/oracle.rb')

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
 
-- 
cgit v1.2.3