public function test_group_by()
{
$qb = new QueryBuilder();
$qb->addTable('first', 'T1');
$qb->addGroupByColumn('T1', 'foo');
$qb->addGroupByStatement('T2.bar');
$expectedSQL = '
SELECT FROM first AS T1 WHERE GROUP BY T1.foo, T2.bar
';
list($actual_sql, $actual_opts) = $qb->getSQL();
$this->assertEquals($this->cleanWS($expectedSQL), $this->cleanWS($actual_sql));
$this->assertEquals(array(), $actual_opts);
}
