Pager brakes joins with "with" keyword

Jonathan H. Wage added a comment - 17/Sep/09 11:31 PM What version of 1.1 are you using?

Ivo Võsa added a comment - 18/Sep/09 5:59 AM Sandbox 1.1.3 and I also did 'svn co http://svn.doctrine-project.org/branches/1.1/ '

Ivo Võsa added a comment - 18/Sep/09 6:24 AM As i did some debuging yesterday i'll post results: debug_print_backtace(); done at Doctrine_query::_buildSqlFromPart() #0 Doctrine_Query->_buildSqlFromPart() called at [/home/iff/Desktop/Doctrine-1.1.3-Sandbox/lib/Doctrine/Query.php:1233] #1 Doctrine_Query->getSqlQuery() called at [/home/iff/Desktop/Doctrine-1.1.3-Sandbox/lib/Doctrine/Query.php:1959] #2 Doctrine_Query->getCountQuery() called at [/home/iff/Desktop/Doctrine-1.1.3-Sandbox/lib/Doctrine/Query.php:2055] #3 Doctrine_Query->count(Array ()) called at [/home/iff/Desktop/Doctrine-1.1.3-Sandbox/lib/Doctrine/Pager.php:109] #4 Doctrine_Pager->_initialize(Array ()) called at [/home/iff/Desktop/Doctrine-1.1.3-Sandbox/lib/Doctrine/Pager.php:571] #5 Doctrine_Pager->execute() called at [/home/iff/Desktop/Doctrine-1.1.3-Sandbox/test.php:23] #0 Doctrine_Query->_buildSqlFromPart(1) called at [/home/iff/Desktop/Doctrine-1.1.3-Sandbox/lib/Doctrine/Query.php:1973] #1 Doctrine_Query->getCountQuery() called at [/home/iff/Desktop/Doctrine-1.1.3-Sandbox/lib/Doctrine/Query.php:2055] #2 Doctrine_Query->count(Array ()) called at [/home/iff/Desktop/Doctrine-1.1.3-Sandbox/lib/Doctrine/Pager.php:109] #3 Doctrine_Pager->_initialize(Array ()) called at [/home/iff/Desktop/Doctrine-1.1.3-Sandbox/lib/Doctrine/Pager.php:571] #4 Doctrine_Pager->execute() called at [/home/iff/Desktop/Doctrine-1.1.3-Sandbox/test.php:23] #0 Doctrine_Query->_buildSqlFromPart() called at [/home/iff/Desktop/Doctrine-1.1.3-Sandbox/lib/Doctrine/Query.php:1233] #1 Doctrine_Query->getSqlQuery(Array ()) called at [/home/iff/Desktop/Doctrine-1.1.3-Sandbox/lib/Doctrine/Query/Abstract.php:1076] #2 Doctrine_Query_Abstract->_execute(Array ()) called at [/home/iff/Desktop/Doctrine-1.1.3-Sandbox/lib/Doctrine/Query/Abstract.php:1142] #3 Doctrine_Query_Abstract->execute(Array (), ) called at [/home/iff/Desktop/Doctrine-1.1.3-Sandbox/lib/Doctrine/Pager.php:574] #4 Doctrine_Pager->execute() called at [/home/iff/Desktop/Doctrine-1.1.3-Sandbox/test.php:23] That lead me to following interesting parts in the code. Doctrine_Query.php line 1959 public function getCountQuery() { // triggers dql parsing/processing $ this ->getSqlQuery(); // this is ugly Doctrine_Query.php line 1126 protected function _processPendingJoinConditions($alias) { $parts = array(); if ($alias !== null && isset($ this ->_pendingJoinConditions[$alias])) { $parser = new Doctrine_Query_JoinCondition($ this , $ this ->_tokenizer); foreach ($ this ->_pendingJoinConditions[$alias] as $joinCondition) { $parts[] = $parser->parse($joinCondition); } // FIX #1860 and #1876: Cannot unset them, otherwise query cannot be reused later //unset($ this ->_pendingJoinConditions[$alias]); } Doctrine_Query.php line 1033 protected function _buildSqlFromPart($ignorePending = false ) So the problem should be obvious now. But what is the solution? Adding bunch of $ignorePending parameters to functions or object properties, so that pager can set it, when it executes does not seem right.

Ivo Võsa added a comment - 18/Sep/09 6:35 AM P.S. And in case someone is having same problem. Quick "solution" to get it working is changing $q->from('User u') ->leftJoin('u.UserGroup g WITH g.status = ?', $status); to $q->from('User u') ->leftJoin('u.UserGroup g WITH g.status = ' . ( int )$status); it still produces query like "AND (u2.status = 0) AND (u2.status = 0)" but you won't get exception this way.

Nicholas Kasyanov added a comment - 22/Sep/09 10:54 AM http://www.doctrine-project.org/jira/browse/DC-48 I think it is same problem

Jonathan H. Wage added a comment - 24/Sep/09 8:28 PM This is fixed by http://trac.doctrine-project.org/changeset/6400