Defect #13110

Double order by prevents documents from working in MSSQL

Added by Ryan Eberly over 9 years ago. Updated over 9 years ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:-% Done:


Target version:-
Resolution:Invalid Affected version:


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

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

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.

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 support Closed


#1 Updated by Daniel Felix over 9 years ago

  • Target version set to 2.3.0

This relates to #12713 and should be fixed before Redmine 2.3 release which introduce SQL Server support.

Can someone check this?

#2 Updated by Etienne Massip over 9 years ago

  • Status changed from New to Closed
  • Target version deleted (2.3.0)

2.2.2.stable does not support MSSQL, this is not related to trunk / 2.3.0 code.

#3 Updated by Etienne Massip over 9 years ago

  • Resolution set to Invalid

Also available in: Atom PDF