Description

d2a-raudenaerde

opened on Jul 1, 2022

Issue body actions

I'm trying to parse a sql-script with multiple statements, and some statements are analyze sometable statements. These are not recognized by the parser?

See for the syntax:
https://www.postgresql.org/docs/current/sql-analyze.html

Simple test:

        CCJSqlParser parser = newParser("analyze table1");
        parser.withAllowComplexParsing(true);
        for (Statement st :parser.Statements().getStatements())
        {
            System.out.println(st);
        }

Activity

1. wumpz commented on Jul 7, 2022

   

   wumpz

   on Jul 7, 2022

   Member

   More actions

   Thats right. JSqlParser does not know this. PRs are welcome.
2. d2a-raudenaerde commented on Jul 8, 2022

   

   d2a-raudenaerde

   on Jul 8, 2022

   ContributorAuthor

   More actions

   Working on it :)
3. d2a-raudenaerde

   added a commit that references this issue on Jul 8, 2022

   Closes JSQLParser#1579. Added ANALYZE <table> support.

   This issue will close once commit a01a097 is merged into the 'master' branch.

   a01a097
4. wumpz

   closed this as completedin e5c8a89on Jul 14, 2022
5. yadedoo

   added a commit that references this issue on May 11, 2024

   Closes JSQLParser#1579. Added ANALYZE <table> support. (JSQLParser#1587)

   This issue will close once commit e5c8a89 is merged into the 'master' branch.

   e5c8a89

Issue actions