From 11dc44ac339199680704b52402fd53f2e3c0ee07 Mon Sep 17 00:00:00 2001
From: Pratik Naik <pratiknaik@gmail.com>
Date: Sat, 30 Jan 2010 19:31:31 +0000
Subject: Fix the generated SQL when In predicate is supplied an empty Array
---
lib/arel/engines/sql/core_extensions/array.rb | 6 +++++-
1 file changed, 5 insertions(+), 1 deletion(-)
(limited to 'lib/arel/engines')
diff --git a/lib/arel/engines/sql/core_extensions/array.rb b/lib/arel/engines/sql/core_extensions/array.rb
index 80041cb5f3..72f579b7eb 100644
--- a/lib/arel/engines/sql/core_extensions/array.rb
+++ b/lib/arel/engines/sql/core_extensions/array.rb
@@ -2,7 +2,11 @@ module Arel
module Sql
module ArrayExtensions
def to_sql(formatter = nil)
- "(" + collect { |e| e.to_sql(formatter) }.join(', ') + ")"
+ if any?
+ "(" + collect { |e| e.to_sql(formatter) }.join(', ') + ")"
+ else
+ "(NULL)"
+ end
end
def inclusion_predicate_sql
--
cgit v1.2.3