Aggregating values in select(), always joins a record, even if there is no relation

 

// logical example
// result: working as expected
$q = Doctrine_Query::create()
->from('Accounts a')
->leftJoin('a.Data d')
->execute()
;

// this time the same query but with a ambigious select clause
// result: working as expected, 
$q = Doctrine_Query::create()
->select('a.*, d.*')
->from('Accounts a')
->leftJoin('a.Data d')
->execute()
;

// same query, but there should not be a Data row because of the bogus WITH condition
// result: working as expected
$q = Doctrine_Query::create()
->select('a.*, d.*')
->from('Accounts a')
->leftJoin('a.Data d with d.type = "blabla"')
->execute()
;

// same query, but with an aggregated column
// result: working as expected, again, no Data row
$q = Doctrine_Query::create()
->select('a.*, d.*, d.surname as test')
->from('Accounts a')
->leftJoin('a.Data d with d.type = "blabla"')
->execute()
;

// same query, but with an aggregated functional expression
// result: FAILS. `test` is joined as an empty column in the Accounts record, AND the Data record, which results in an empty Data record 
// you can imagine saving the Accounts object to save an empty Data record in return
$q = Doctrine_Query::create()
->select('a.*, d.*, concat_ws(" ", d.firstname, d.surname) as test')
->from('Accounts a')
->leftJoin('a.Data d with d.type = "blabla"')
->execute()
;

// a expression that doesnt concatenates doesnt join an empty Data record, but does aggregate a empty `test` column on Accounts
$q = Doctrine_Query::create()
->select('a.*, d.*, trim(d.firstname) as test')
->from('Accounts a')
->leftJoin('a.Data d with d.type = "blabla"')
->execute()
;

<?php

class Doctrine_AggregateFunctionalExpressios_TestCase extends Doctrine_UnitTestCase 
{
	private function baseQueryForAllMethods() {
		return Doctrine_Query::create()
		->from('User u')
		->where('u.id = ?', 4)
		;
	}
    public function testAggregateColumnInParentModel()
    {
		$res = $this->baseQueryForAllMethods()
		->select('u.*, concat(u.name, u.loginname) as aggregatedColumn, p.*')
		->leftJoin('u.Phonenumber p')		
		->fetchOne()
		;
		$this->assertTrue(isset($res->aggregatedColumn));
		$this->assertFalse(isset($res->Phonenumber->aggregatedColumn));
	}	
    public function testAggregateColumnInJoinedModel()
    {
		$res = $this->baseQueryForAllMethods()
		->select('u.*, p.*, concat(p.phonenumber, p.entity_id) as aggregatedColumn')
		->leftJoin('u.Phonenumber p')		
		->fetchOne()
		;
		$this->assertTrue(isset($res->Phonenumber->aggregatedColumn));
		$this->assertFalse(isset($res->aggregatedColumn));
	}
    public function testAggregateColumnInJoinedModelWithFailingWhereClause()
    {
		$res = $this->baseQueryForAllMethods()
		->select('u.*, p.*, concat(p.phonenumber, p.entity_id) as aggregatedColumn')
		->leftJoin('u.Phonenumber p WITH p.id = ?', 100)		
		->fetchOne()
		;
		$this->assertFalse(isset($res->Phonenumber->aggregatedColumn));		
		$this->assertFalse(isset($res->aggregatedColumn));				
	}
}