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

New Issue

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

admin commented

2026-01-22 13:13:01 +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:01 +01:00

admin referenced this issue

2026-01-22 14:50:36 +01:00

DDC-3982: [GH-1547] [RFC] fixes result cache setting query caching #4859

admin referenced this issue

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

[PR #1394] Fix result cache setting query caching #9451

admin referenced this issue

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

[PR #1547] [RFC] fixes result cache setting query caching #9604

Sign in to join this conversation.