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"]]);
}
