#1629: Query returns an empty result set when joining on a table with SoftDelete
enabled
------------------------------------+---------------------------------------
Reporter: poppinphresh | Owner: jwage
Type: defect | Status: new
Priority: minor | Milestone: Unknown
Component: Behaviors | Version: 1.0.3
Keywords: Soft Delete, Left join | Has_test: 0
Mystatus: Pending Core Response | Has_patch: 0
------------------------------------+---------------------------------------
A query with joins will return an empty result set when the joined table
has SoftDelete enabled and all of the rows are set to TRUE.
The problem is very similar to ticket [http://trac.doctrine-
project.org/ticket/1529 #1529]
My DQL Query: $q = Doctrine_Query::create()->from('Post
p')->leftJoin('p.Comment c')->where('p.id = ?', 9)->execute();
Which outputs this sql: SELECT p.body AS p__body, p.author AS p__author,
p.deleted AS p.deleted, c.comment AS c__comment FROM post p LEFT JOIN
comment c ON p.id = c.post_id WHERE p.id = p AND (p.deleted = FALSE OR
p.deleted IS NULL) AND (c.deleted = FALSE OR c.deleted IS NULL)
--
Ticket URL: <http://trac.doctrine-project.org/ticket/1629>
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
-~----------~----~----~----~------~----~------~--~---
