mirror of
https://github.com/doctrine/orm.git
synced 2026-03-23 22:42:18 +01:00
DDC-1687: [GH-298] by sandermarechal: Pagination using SQL walkers #2122
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @doctrinebot on GitHub (Mar 6, 2012).
Originally assigned to: @beberlei on GitHub.
Jira issue originally created by user @beberlei:
This issue is created automatically through a Github pull request on behalf of sandermarechal:
Url: https://github.com/doctrine/doctrine2/pull/298
Message:
A CountSqlWalker and LimitSubquerySqlWalker have been implemented. By
default the Paginator will use these SQL walkers. When a query already
uses custom SQL walkers, the Paginator will fall back to the existing
TreeWalker implementations. Improvements:
Support for more complex DQL queries using named mixed results with
GROUP BY and HAVING. For example:
SELECT g, u, COUNT(u.id) AS userCount
FROM Entity\Group g LEFT JOIN g.users u
GROUP BY g.id
HAVING userCount > 0
Support for entities with composite primary keys in the CountSqlWalker
and LimitSubquerySqlWalker. Only the WhereInWalker still needs to be
updated for full composite primary key support. But someone smarter
than me needs to look at that and figure out how to build a WHERE IN
query that can select rows based on multiple columns.
@doctrinebot commented on GitHub (Mar 12, 2012):
Comment created by @beberlei:
Merged for 2.3
@doctrinebot commented on GitHub (Mar 12, 2012):
Issue was closed with resolution "Fixed"
@doctrinebot commented on GitHub (Sep 16, 2013):
Comment created by @doctrinebot:
A related Github Pull-Request [GH-298] was closed:
https://github.com/doctrine/common/pull/298