public function testSelectOverride() { $query = new SelectQuery(); $query->select(array('foo'))->from('users', 'u')->groupBy('name')->having('total_scores > 10'); $query->setSelect(array('name', new Raw('sum(scores) AS total_scores'))); $selected = $query->getSelect(); is(2, count($selected)); $this->assertSqlStrings($query, [[new MySQLDriver(), "SELECT name, sum(scores) AS total_scores FROM users AS u GROUP BY name HAVING total_scores > 10"]]); // should be the same $query->setSelect('name', new Raw('sum(scores) AS total_scores')); $this->assertSqlStrings($query, [[new MySQLDriver(), "SELECT name, sum(scores) AS total_scores FROM users AS u GROUP BY name HAVING total_scores > 10"]]); }