public function testUnion3()
{
$sql = "SELECT x FROM ((SELECT y FROM z WHERE (y > 2) ) UNION ALL (SELECT a FROM z WHERE (y < 2))) as f ";
$parser = new PHPSQLParser();
$p = $parser->parse($sql, true);
$expected = getExpectedValue(dirname(__FILE__), 'union3.serialized');
$this->assertEquals($expected, $p, 'complicated mysql union');
}