Defect #13110
closedDouble order by prevents documents from working in MSSQL
0%
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