[DBAL-560] [GH-344] Fix Limit with order by on SQL Server 2008 R2 Created: 17/Jul/13  Updated: 16/Nov/13  Resolved: 16/Nov/13

Status: Resolved
Project: Doctrine DBAL
Component/s: None
Affects Version/s: None
Fix Version/s: 2.5
Security Level: All

Type: Bug Priority: Major
Reporter: Doctrine Bot Assignee: Benjamin Eberlei
Resolution: Invalid Votes: 0
Labels: None


This issue is created automatically through a Github pull request on behalf of micheletedeschi:

Url: https://github.com/doctrine/dbal/pull/344


Fix Limit with order by on SQL Server 2008 R2

Found problem when using this bundle:

  • cedriclombardot/admingenerator-generator-bundle
  • jms/job-queue-bundle

This fix resolve the problem of wrong column name on ROW_NUMBER() OVER.

Tested on:

  • SQL Server 2008 R2
  • php_pdo_sqlsrv_54
  • Symfony 2.3.2
  • Doctrine 2.4.0 RC2

Now work paging and paging with order by.

Comment by Doctrine Bot [ 04/Oct/13 ]

A related Github Pull-Request [GH-344] was closed:

Comment by Fabio B. Silva [ 16/Nov/13 ]

Closed.. see https://github.com/doctrine/dbal/pull/344 for more details...

Generated at Sun Dec 21 09:59:00 UTC 2014 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.