public function testSelectDistinctIsSupported() { $q = new Doctrine_Query(); $q->distinct()->select('u.name')->from('User u'); $this->assertEqual($q->getSql(), "SELECT DISTINCT e.id AS e__id, e.name AS e__name FROM entity e WHERE (e.type = 0)"); }
/** * @access private * * @author Jannis Moßhammer <*****@*****.**> **/ protected function modifyImpl(Doctrine_Query &$o) { $o->setAliasDefs($this->mainAlias, $this->aliasDefs); $o->setDefaultJoinType($this->defaultJoinType); foreach ($this->fields as $field) { $o->addSelect($field); } $o->distinct($this->isDistinct()); $o->from($this->target . " " . $this->mainAlias); foreach ($this->staticWhereConditions as $cond) { if (isset($cond[1]) && $cond[1] != null) { $o->addWhere($cond[0], $cond[1]); } else { $o->addWhere($cond[0]); } } }