Sql parser for PostgreSQL 一些问题

[spance]

version 1.0.26-SNAPSHOT

目前的sql parser在处理一些pg特有语法时抛出异常 com.alibaba.druid.sql.parser.ParserException: syntax error...。

public class PGSelectTest30 extends PGTest {

    String[] pgSQLs = new String[]{
            /**
             * Chapter 12. Full Text Search
             * tsvector @@ tsquery
             * tsquery @@ tsvector
             * text @@ tsquery
             * text @@ text
            */
            "SELECT 'a fat cat sat on a mat'::tsvector @@ 'cat & rat'::tsquery",
            /**
             * 9.7. Pattern Matching: ilike
            */
            "select * from dual where name ilike '%mi%'",
            /**
             * 9.7.2. SIMILAR TO Regular Expressions
            */
            "select 'abc' SIMILAR TO '%(b|d)%'",
            /**
             * 9.7.3. POSIX Regular Expressions
            */
            "select 'thomas' ~ '.*thomas.*'",
            "select 'thomas' ~* '.*Thomas.*'",
            "select 'thomas' !~ '.*Thomas.*'",
            "select 'thomas' !~* '.*vadim.*'",
            /**
             * 9.9. Date/Time Functions and Operators
            */
            "select date '2001-09-28' + integer '7'",
            /**
             * array operators
             *
            */
            "select '{1,2,3}'::int[] && '{1,2,3}'::int[]",
            "select '{1,2,3}'::int[] @> '{1,2,3}'::int[]",
            "select '{1,2,3}'::int[] @< '{1,2,3}'::int[]",
            /**
             * others
             * polygon '((0,0),(1,1))' ~= polygon '((1,1),(0,0))'
             * circle '((0,0),1)' <-> circle '((5,0),1)'
             * ltree <@ ltree
             * ltree ~ lquery
             * ltree ? lquery[]
             * ltree[] ?@> ltree
             * .....
            */
    };

    public void test_0() throws Exception {
        for (String sql : pgSQLs) {
            PGSQLStatementParser parser = new PGSQLStatementParser(sql);
            List<SQLStatement> statementList = parser.parseStatementList();
            SQLStatement stmt = statementList.get(0);
            Assert.assertNotNull(stmt);
        }
    }
}

[wenshao]

PG的语法有点诡异哈

[wenshao]

已经全部支持，谢谢反馈