#1584: Softdelete and Subquery issue with M2M relationship
------------------------------+---------------------------------------------
Reporter: Jay.Klehr | Owner: romanb
Type: defect | Status: new
Priority: major | Milestone: Unknown
Component: Query/Hydration | Version: 1.0.3
Resolution: | Keywords:
Has_test: 0 | Mystatus: Pending Core Response
Has_patch: 0 |
------------------------------+---------------------------------------------
Comment (by jwage):
I see a problem with your Subquery. Can you test if this has any affect on
the result?
{{{
Doctrine_Query::create()
->from('Group g')
->where('g.id NOT IN (SELECT g2.id FROM Group g2 INNER JOIN g2.Users u
WHERE u.id = ?)', $user_id)
->execute();
}}}
You were missing the final closing parenthesis.
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1584#comment:1>
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
-~----------~----~----~----~------~----~------~--~---
