PHPSQLParser\Test\Parser\UnionTest::testUnion3 PHP Method

testUnion3() public method

public testUnion3 ( )
    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');
    }