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)

---
 test/visitors/test_oracle.rb | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'test')

diff --git a/test/visitors/test_oracle.rb b/test/visitors/test_oracle.rb
index db277088f1..d2a73ea8c5 100644
--- a/test/visitors/test_oracle.rb
+++ b/test/visitors/test_oracle.rb
@@ -105,6 +105,22 @@ module Arel
             sql.must_equal sql2
           end
         end
+
+        describe 'only offset' do
+          it 'creates a select from subquery with rownum condition' do
+            stmt = Nodes::SelectStatement.new
+            stmt.offset = Nodes::Offset.new(10)
+            sql = @visitor.accept stmt
+            sql.must_be_like %{
+              SELECT * FROM (
+                SELECT raw_sql_.*, rownum raw_rnum_
+                FROM (SELECT ) raw_sql_
+              )
+              WHERE raw_rnum_ > 10
+            }
+          end
+        end
+
       end
     end
   end
-- 
cgit v1.2.3