DDC-1115: "orderby" doesn't work with "setMaxResults" and "setFirstResult" for sql server 2008 #1397

New Issue

admin · 2026-01-22T13:13:06+01:00

admin commented

2026-01-22 13:13:06 +01:00

Originally created by @doctrinebot on GitHub (Apr 14, 2011).

Jira issue originally created by user minxuan.guo:

Working for a project use doctrine 2.0.3 and sql server 2008, I have a problem when I use "orderBy" "setFirstResult" and "setMaxResults" together.

my PHP code:

    $qb = $em->createQueryBuilder()
           ->from('Entities\Individu', 'i');
    $qb->setFirstResult(201);
    $qb->setMaxResults(400);
    $qb->orderBy('{color:red}i.numImmatriculation{color}');
    $qb->select('i.numImmatriculation');

then doctrine2 generate a requet for me:

WITH outer_tbl AS (
SELECT ROW_NUMBER() OVER (
ORDER BY {color:red}i0_.NumImmatriculation{color} ASC
)
AS "doctrine_rownum", *
FROM (
SELECT i0_.NumImmatriculation AS {color:red}NumImmatriculation0 {color}
FROM Individu i0_
)
AS inner_tbl
)
SELECT * FROM outer_tbl WHERE "doctrine_rownum" BETWEEN 201 AND 400

This request doesn't work, because sql server don't understand {color:red}i0_.NumImmatriculation{color} in line 3 which should be replaced by {color:red}NumImmatriculation0 {color}

Originally created by @doctrinebot on GitHub (Apr 14, 2011). Jira issue originally created by user minxuan.guo: Working for a project use doctrine 2.0.3 and sql server 2008, I have a problem when I use "orderBy" "setFirstResult" and "setMaxResults" together. **my PHP code:** ``` $qb = $em->createQueryBuilder() ->from('Entities\Individu', 'i'); $qb->setFirstResult(201); $qb->setMaxResults(400); $qb->orderBy('{color:red}i.numImmatriculation{color}'); $qb->select('i.numImmatriculation'); ``` **then doctrine2 generate a requet for me:** WITH outer_tbl AS ( SELECT ROW_NUMBER() OVER ( ORDER BY {color:red}i0_.NumImmatriculation{color} ASC ) AS "doctrine_rownum", \* FROM ( SELECT i0_.NumImmatriculation AS {color:red}NumImmatriculation0 {color} FROM Individu i0_ ) AS inner_tbl ) SELECT \* FROM outer_tbl WHERE "doctrine_rownum" BETWEEN 201 AND 400 **This request doesn't work, because sql server don't understand {color:red}i0_.NumImmatriculation{color} in line 3 which should be replaced by {color:red}NumImmatriculation0 {color}**

admin added the Bug label 2026-01-22 13:13:06 +01:00

admin closed this issue

2026-01-22 13:13:06 +01:00

admin commented

2026-01-22 13:13:08 +01:00

@doctrinebot commented on GitHub (Apr 17, 2011):

Comment created by @beberlei:

Assigned to Juozas.

@doctrinebot commented on GitHub (Apr 17, 2011): Comment created by @beberlei: Assigned to Juozas.

admin commented

2026-01-22 13:13:08 +01:00

@doctrinebot commented on GitHub (Apr 28, 2011):

Comment created by aarondm:

This has also been reported here:
http://www.doctrine-project.org/jira/browse/DBAL-82

Hope this gets looked at! Thanks

@doctrinebot commented on GitHub (Apr 28, 2011): Comment created by aarondm: This has also been reported here: http://www.doctrine-project.org/jira/browse/[DBAL-82](http://www.doctrine-project.org/jira/browse/DBAL-82) Hope this gets looked at! Thanks

admin commented

2026-01-22 13:13:08 +01:00

@doctrinebot commented on GitHub (Aug 18, 2011):

Comment created by juokaz:

Duplicate of DBAL-82

@doctrinebot commented on GitHub (Aug 18, 2011): Comment created by juokaz: Duplicate of [DBAL-82](http://www.doctrine-project.org/jira/browse/DBAL-82)

admin commented

2026-01-22 13:13:10 +01:00

@doctrinebot commented on GitHub (Aug 18, 2011):

Issue was closed with resolution "Duplicate"

@doctrinebot commented on GitHub (Aug 18, 2011): Issue was closed with resolution "Duplicate"

admin referenced this issue

2026-01-22 16:04:22 +01:00

[PR #1397] Add Expr::concat support for multiple arguments #9455

Sign in to join this conversation.