Added an additional test since skip/limit can not be used in reverse order

1 files changed, 8 insertions, 0 deletions

diff --git a/test/visitors/test_informix.rb b/test/visitors/test_informix.rb
index db5e52b8a4..a8a52a0160 100644
--- a/test/visitors/test_informix.rb
+++ b/test/visitors/test_informix.rb
@@ -29,6 +29,14 @@ module Arel
         sql.must_be_like "SELECT SKIP 10"
       end
 
+      it 'uses SKIP before LIMIT' do
+        stmt = Nodes::SelectStatement.new
+        stmt.limit = Nodes::Limit.new(1)
+        stmt.offset = Nodes::Offset.new(1)
+        sql = @visitor.accept(stmt)
+        sql.must_be_like "SELECT SKIP 1 LIMIT 1"
+      end
+
     end
   end
 end