Defect #22808
Malformed SQL query with SQLServer when grouping and sorting by fixed version
Status: | Closed | Start date: | ||
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | % Done: | 0% | ||
Category: | Issues filter | |||
Target version: | 3.1.6 | |||
Resolution: | Fixed | Affected version: | 3.2.1 |
Description
Hi guys,
I had the same problem of issue #19544, but my was with the fixed version column, in version 3.2.1 with SQL Server 2012, and this r14207 did not solve my problem.
making a debug in the code, I found that the part where it should make a flatten between two Array, the variable group_by_sort_order comes as String, so I did a treatment to make this String into Array, and solved my problem.
code modified in /app/models/issue_query.rb
# Returns the issues
# Valid options are :order, :offset, :limit, :include, :conditions
def issues(options={})
if group_by_sort_order.is_a?(String)
# convert String in Array
order_option = [group_by_sort_order.split(','), options[:order]].flatten.reject(&:blank?)
else
order_option = [group_by_sort_order, options[:order]].flatten.reject(&:blank?)
end
...
Associated revisions
Malformed SQL query with SQLServer when grouping and sorting by fixed version (#22808).
History
#1
Updated by Toshi MARUYAMA over 6 years ago
- Target version set to 3.1.6
#2
Updated by Toshi MARUYAMA over 6 years ago
- Description updated (diff)
#3
Updated by Jean-Philippe Lang about 6 years ago
- Subject changed from Malformed SQL query with SQLServer when grouping fixed versions to Malformed SQL query with SQLServer when grouping and sorting by fixed version
- Status changed from New to Resolved
- Assignee set to Jean-Philippe Lang
- Resolution set to Fixed
Fixed in r15416.
#4
Updated by Jean-Philippe Lang about 6 years ago
- Status changed from Resolved to Closed