function test_default()
{
$query = new SQL_Query('table');
$query->addOrder(array('col', true));
$query->resetOrder();
$this->assertEquals(array(), $query->getOrder());
}
function test_collateAndDesc()
{
$query = new SQL_Query('table');
// add a collate clause
// this should become: ORDER BY col COLLATE collate_name ASC, col2
$query->addOrder(array('col', false, 'col1'));
$query->addOrder('col2');
$this->assertEquals(array(array('col', false, 'col1'), array('col2', false)), $query->getOrder());
}
