#1521: Doctrine Query Cache not storing/rebuilding query with 3 part relation
properly
------------------------------+---------------------------------------------
Reporter: Jay.Klehr | Owner: romanb
Type: defect | Status: new
Priority: minor | Milestone: 1.0.4
Component: Query/Hydration | Version: 1.0.2
Resolution: | Keywords: query cache
Has_test: 0 | Mystatus: Pending Core Response
Has_patch: 0 |
------------------------------+---------------------------------------------
Comment (by desfrenes):
I have the same problem, with some "complex" (multiple joins, etc) queries
too such as this one:
{{{
#!php
<?php
$products = Doctrine_Query::create()
->from('Product p')
->leftJoin('p.Category c')
->leftJoin('p.References r')
->leftJoin('p.Brand b')
->leftJoin('p.Medias m')
->leftJoin('p.Flags f')
->leftJoin('f.Flag fl')
->leftJoin('r.Caracteristics car')
->leftJoin('car.Key k')
->where('c.id=?')
->orderBy($sort . ' ' . $dir)
->limit((int)$limit)
->offset((int)$start)
->fetchArray(array((int)$cat));
}}}
For now I just disabled the query cache.
--
Ticket URL: <http://trac.phpdoctrine.org/ticket/1521#comment:2>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"doctrine-svn" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.co.uk/group/doctrine-svn?hl=en-GB
-~----------~----~----~----~------~----~------~--~---