From b688214ce038d6697be370ff8a7037908b1ee9dc 2015-05-30 08:23:03
From: Jean-Philippe Lang <jp_lang@yahoo.fr>
Date: 2015-05-30 08:23:03
Subject: [PATCH] Column 'address' in where clause may be ambiguous (#19485).

git-svn-id: http://svn.redmine.org/redmine/trunk@14284 e93f8b46-1217-0410-a6f0-8f06a7374b81

---

diff --git a/app/models/user.rb b/app/models/user.rb
index cdaebcf..7061015 100644
--- a/app/models/user.rb
+++ b/app/models/user.rb
@@ -130,7 +130,7 @@ class User < Principal
   scope :having_mail, lambda {|arg|
     addresses = Array.wrap(arg).map {|a| a.to_s.downcase}
     if addresses.any?
-      joins(:email_addresses).where("LOWER(address) IN (?)", addresses).uniq
+      joins(:email_addresses).where("LOWER(#{EmailAddress.table_name}.address) IN (?)", addresses).uniq
     else
       none
     end