public function testReplaceClause()
{
$parser = new Parser('SELECT *, (SELECT 1) FROM film LIMIT 0, 10;');
$this->assertEquals('SELECT *, (SELECT 1) FROM film WHERE film_id > 0 LIMIT 0, 10', Query::replaceClause($parser->statements[0], $parser->list, 'WHERE film_id > 0'));
$parser = new Parser('select supplier.city, supplier.id from supplier ' . 'union select customer.city, customer.id from customer');
$this->assertEquals('select supplier.city, supplier.id from supplier ' . 'union select customer.city, customer.id from customer' . ' ORDER BY city ', Query::replaceClause($parser->statements[0], $parser->list, 'ORDER BY city'));
}