From d86e20ccbea226bb6e42da508bc040fd03ab473f Mon Sep 17 00:00:00 2001
From: Tamir Duberstein <tamird@squareup.com>
Date: Mon, 23 Feb 2015 09:58:22 -0800
Subject: Special limited delete handling in MSSQL

Refernce:
https://technet.microsoft.com/en-us/library/ms175486%28v=sql.105%29.aspx
---
 test/visitors/test_mssql.rb | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'test/visitors')

diff --git a/test/visitors/test_mssql.rb b/test/visitors/test_mssql.rb
index 7574aeb0a2..fe228bce4b 100644
--- a/test/visitors/test_mssql.rb
+++ b/test/visitors/test_mssql.rb
@@ -45,6 +45,15 @@ module Arel
         connection.verify
       end
 
+      it 'should use TOP for limited deletes' do
+        stmt = Nodes::DeleteStatement.new
+        stmt.relation = @table
+        stmt.limit = Nodes::Limit.new(10)
+        sql = compile(stmt)
+
+        sql.must_be_like "DELETE TOP (10) FROM \"users\""
+      end
+
       it 'should go over query ORDER BY if .order()' do
         stmt = Nodes::SelectStatement.new
         stmt.limit = Nodes::Limit.new(10)
-- 
cgit v1.2.3