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 -
        Hide
        Doctrine Bot added a comment -

        A related Github Pull-Request [GH-344] was closed:
        https://github.com/doctrine/dbal/pull/344

        Show
        Doctrine Bot added a comment - A related Github Pull-Request [GH-344] was closed: https://github.com/doctrine/dbal/pull/344
        Hide
        Fabio B. Silva added a comment -

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

        Show
        Fabio B. Silva added a comment - Closed.. see https://github.com/doctrine/dbal/pull/344 for more details...
        Fabio B. Silva made changes -
        Field Original Value New Value
        Status Open [ 1 ] Resolved [ 5 ]
        Fix Version/s 2.5 [ 10523 ]
        Resolution Invalid [ 6 ]

        This list may be incomplete, as errors occurred whilst retrieving source from linked applications:

        • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DBAL-560, expand=changesets[0:20].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

          People

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

            Dates

            • Created:
              Updated:
              Resolved: