DDC-1573: Simple relation hydratation not working properly #2210

Closed
doctrinebot opened this Issue Dec 29, 2011 · 5 comments

2 participants

@doctrinebot

Jira issue originally created by user jeremy.c:

    I'm not sure if i'm in the right place but i'm talking about this : https://github.com/doctrine/doctrine2

The following code trigger a lot more queries than it should and than it used to :

--- code ---

$qb = $em->createQueryBuilder()
->select('t, c, p')
->from('Task', 't')
->leftJoin('t.children', 'c')
->leftJoin('t.parent', 'p')
->orderBy('t.root, t.lft')
;

foreach( $qb->getQuery()->getResult() as $task)
{
$task->getChildren()->count();
}


edit: The code doesn't seems to be very nice in this editor, here is a pastbin version : http://pastebin.com/LCRfBCcV

With doctrine 2.1.2, only one query is needed.

Since doctrine 2.1.3, i almost have one query per loop iteration. It's the same with all next versions.

I'm using a NestedSet extension and Symfony 2.0.8, if i force doctrine version to 2.1.2 it works again with one query (with doctrine-common 2.1.4 and doctrine-dbal 2.1.5) so i think the problem is clearly introduced by doctrine itself (2.1.3).

I hope i was clear enough.

@doctrinebot

Comment created by @beberlei:

Duplicate of DDC-1526

@doctrinebot

Issue was closed with resolution "Duplicate"

@doctrinebot

Comment created by @beberlei:

Can you disable the nested set extension? the other ticket uses it too and i want to rule out that its the extensions fault.

@doctrinebot

Comment created by jeremy.c:

I just tried without the nested set extension but it still triggers the same amount of unecessary queries.

@beberlei beberlei was assigned by doctrinebot Dec 6, 2015
@doctrinebot doctrinebot closed this Dec 6, 2015
@doctrinebot doctrinebot added the Bug label Dec 7, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment