DDC-624: Partial object query that leaves out an association to avoid loading it fetches the association anyway. #770

Open
opened 2026-01-22 12:49:50 +01:00 by admin · 0 comments
Owner

Originally created by @doctrinebot on GitHub (Jun 3, 2010).

Originally assigned to: @guilhermeblanco on GitHub.

Jira issue originally created by user romanb:

Assuming:

Customer Cart

where Cart is the owning side.

Since the association from Customer to Cart can not be lazy, it would make sense to leave out the association in a query to avoid loading the carts like this:

select partial c.{id,name, ... anything except cart} from Customer c"

But this is ignored and the carts of all customers are fetched anyway. Query::HINT_FORCE_PARTIAL_LOAD is an alternative solution, however it has the disadvantage that it disables lazy-loading for all queried objects. If partial querying would honor associations this would allow more fine-grained control.

Originally created by @doctrinebot on GitHub (Jun 3, 2010). Originally assigned to: @guilhermeblanco on GitHub. Jira issue originally created by user romanb: Assuming: Customer <onetoone> Cart where Cart is the owning side. Since the association from Customer to Cart can not be lazy, it would make sense to leave out the association in a query to avoid loading the carts like this: ``` select partial c.{id,name, ... anything except cart} from Customer c" ``` But this is ignored and the carts of all customers are fetched anyway. Query::HINT_FORCE_PARTIAL_LOAD is an alternative solution, however it has the disadvantage that it disables lazy-loading for **all** queried objects. If partial querying would honor associations this would allow more fine-grained control.
admin added the BugDuplicate labels 2026-01-22 12:49:50 +01:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#770