Project

General

Profile

Actions

Defect #13110

closed

Double order by prevents documents from working in MSSQL

Added by Ryan Eberly almost 12 years ago. Updated almost 12 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Documents
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Invalid
Affected version:

Description

We are using FreeTDS with SQL Server 2012 (on windows server)

documents_controller.rb:
def show
@attachments = @document.attachments.find(:all, :order => "created_on DESC")
end

this results in the sql query having 'created_on' appear twice in the order by clause that activerecord generates- which is illegal in SQL Server. My fix was to remove the :order in the document_controller show function.

Environment:
Redmine version 2.2.2.stable
Ruby version 1.9.3 (i386-mingw32)
Rails version 3.2.11
Environment production
Database adapter SQLServer
Redmine plugins:
goodville_redmine 0.0.1
redmine_contacts 3.1.1-light
redmine_mylyn_connector 2.8.2.stable
redmine_plugin_views_revisions 0.0.1


Related issues

Related to Redmine - Feature #12713: Microsoft SQLServer supportClosedJean-Philippe Lang

Actions
Actions

Also available in: Atom PDF