DDC-125: Include Query Hints in DQL Query Cache #156

Closed
opened 2026-01-22 12:28:57 +01:00 by admin · 2 comments
Owner

Originally created by @doctrinebot on GitHub (Nov 6, 2009).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user @beberlei:

The \Doctrine\ORM\Query has a TODO comment on possible inclusion of the query hints for the DQL Query Parsing Cache.

I have a use case for a custom SQL walker for switching the SELECT part of a query with SELECT count(*) FROM to be able to use Query objects in a paginator. However this would break the query cache since both queries would match the same query cache string.

Originally created by @doctrinebot on GitHub (Nov 6, 2009). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user @beberlei: The \Doctrine\ORM\Query has a TODO comment on possible inclusion of the query hints for the DQL Query Parsing Cache. I have a use case for a custom SQL walker for switching the SELECT part of a query with SELECT count(*) FROM to be able to use Query objects in a paginator. However this would break the query cache since both queries would match the same query cache string.
admin added the Improvement label 2026-01-22 12:28:57 +01:00
admin closed this issue 2026-01-22 12:28:58 +01:00
Author
Owner

@doctrinebot commented on GitHub (Feb 10, 2010):

Comment created by @beberlei:

Fixed, updated ResultCache to use hints also, aswell as fixed a dependency problem in AbstractQuery using getDql() instead of getSql()

@doctrinebot commented on GitHub (Feb 10, 2010): Comment created by @beberlei: Fixed, updated ResultCache to use hints also, aswell as fixed a dependency problem in AbstractQuery using getDql() instead of getSql()
Author
Owner

@doctrinebot commented on GitHub (Feb 10, 2010):

Issue was closed with resolution "Fixed"

@doctrinebot commented on GitHub (Feb 10, 2010): Issue was closed with resolution "Fixed"
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#156