diff options
| author | Toshi MARUYAMA <marutosijp2@yahoo.co.jp> | 2014-01-27 07:21:47 +0000 |
|---|---|---|
| committer | Toshi MARUYAMA <marutosijp2@yahoo.co.jp> | 2014-01-27 07:21:47 +0000 |
| commit | a711cbb44e7c277c0c4506e9b98abb9fe934db39 (patch) | |
| tree | ccf89d2bb93b3bb56277dbd91b75418c513ff88e /app/models/issue_custom_field.rb | |
| parent | 9e71d89cdb3500d1421f3d1b88656896a615cb2a (diff) | |
| download | redmine-a711cbb44e7c277c0c4506e9b98abb9fe934db39.tar.gz redmine-a711cbb44e7c277c0c4506e9b98abb9fe934db39.zip | |
back out from r12715 to r12720: #connection replacing
These revisions have performance regression on Rails 3.2.16.
git-svn-id: http://svn.redmine.org/redmine/trunk@12735 e93f8b46-1217-0410-a6f0-8f06a7374b81
Diffstat (limited to 'app/models/issue_custom_field.rb')
| -rw-r--r-- | app/models/issue_custom_field.rb | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/app/models/issue_custom_field.rb b/app/models/issue_custom_field.rb index a695eaea3..776bb4f0a 100644 --- a/app/models/issue_custom_field.rb +++ b/app/models/issue_custom_field.rb @@ -32,7 +32,7 @@ class IssueCustomField < CustomField sql = super id_column ||= id tracker_condition = "#{Issue.table_name}.tracker_id IN (SELECT tracker_id FROM #{table_name_prefix}custom_fields_trackers#{table_name_suffix} WHERE custom_field_id = #{id_column})" - project_condition = "EXISTS (SELECT 1 FROM #{CustomField.table_name} ifa WHERE ifa.is_for_all = #{ActiveRecord::Base.connection.quoted_true} AND ifa.id = #{id_column})" + + project_condition = "EXISTS (SELECT 1 FROM #{CustomField.table_name} ifa WHERE ifa.is_for_all = #{connection.quoted_true} AND ifa.id = #{id_column})" + " OR #{Issue.table_name}.project_id IN (SELECT project_id FROM #{table_name_prefix}custom_fields_projects#{table_name_suffix} WHERE custom_field_id = #{id_column})" "((#{sql}) AND (#{tracker_condition}) AND (#{project_condition}))" |