From 9a66463ff8464e5780923f0f9476524fdbc6d978 Mon Sep 17 00:00:00 2001 From: Jean-Philippe Lang Date: Fri, 4 Jan 2013 10:08:29 +0000 Subject: [PATCH] Prevent sqlserver adapter from breaking the sub-query (#12713). git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@11116 e93f8b46-1217-0410-a6f0-8f06a7374b81 --- app/models/issue_query.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/app/models/issue_query.rb b/app/models/issue_query.rb index b0e282f89..81e6e1cef 100644 --- a/app/models/issue_query.rb +++ b/app/models/issue_query.rb @@ -209,7 +209,7 @@ class IssueQuery < Query index = (index ? index + 1 : -1) # insert the column after estimated_hours or at the end @available_columns.insert index, QueryColumn.new(:spent_hours, - :sortable => "(SELECT COALESCE(SUM(hours), 0) FROM #{TimeEntry.table_name} WHERE #{TimeEntry.table_name}.issue_id = #{Issue.table_name}.id)", + :sortable => "COALESCE((SELECT SUM(hours) FROM #{TimeEntry.table_name} WHERE #{TimeEntry.table_name}.issue_id = #{Issue.table_name}.id), 0)", :default_order => 'desc', :caption => :label_spent_time ) -- 2.39.5