Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-560

[GH-344] Fix Limit with order by on SQL Server 2008 R2

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Invalid
    • Affects Version/s: None
    • Fix Version/s: 2.5
    • Component/s: None
    • Security Level: All
    • Labels:
      None

      Description

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

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

      Message:

      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.

        Activity

        Doctrine Bot created issue -
        Fabio B. Silva made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 2.5 [ 10523 ]
        Resolution Invalid [ 6 ]

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            Doctrine Bot
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: