From 11dc44ac339199680704b52402fd53f2e3c0ee07 Mon Sep 17 00:00:00 2001 From: Pratik Naik 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') 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