Description

ghost

opened on Dec 28, 2020

Using JSqlParser 3.2 I get an exception when parsing:

create domain TNOTIFICATION_ACTION as ENUM ('ADD', 'CHANGE', 'DEL')

Encountered unexpected token: "create" "CREATE"
    at line 1, column 1.

Activity

1. wumpz commented on Dec 30, 2020

   

   wumpz

   on Dec 30, 2020

   Member

   More actions

   Thats right, because this statement is not supported by JSqlParser.

   PRs are welcome.

   Reacted by Jan
2. AnEmortalKid commented on Feb 4, 2021

   

   AnEmortalKid

   on Feb 4, 2021

   Contributor

   More actions

   @wise-coders if you want a bit of hints on how you could add this, I did something similar for view here: #977
3. manticore-projects commented on May 17, 2023

   

   manticore-projects

   on May 17, 2023

   Contributor

   More actions

   Working around by using UnsupportedStatement, which can be assessed using Regular Expressions:

   sqlStr ="create domain TNOTIFICATION_ACTION as ENUM ('ADD', 'CHANGE', 'DEL')";
   Statement statement = TestUtils.assertSqlCanBeParsedAndDeparsed(sqlStr, true);
   assertTrue(statement instanceof UnsupportedStatement);
4. manticore-projects

   added a commit that references this issue on May 17, 2023

   feat: parse CREATE TRIGGER as UnsupportedStatement

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

   64b0331
5. manticore-projects

   closed this as completedin 41b6fceon Jun 1, 2023
6. manticore-projects

   closed this as completedin #1778on Jun 1, 2023
7. manticore-projects

   added a commit that references this issue on Jun 15, 2023

   Assorted Fixes #8 (#1807)

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

   a815f5f
8. manticore-projects

   added a commit that references this issue on Jun 27, 2023

   Backslash Quotation of Single-Quote `'\\''` (#1813)

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

   c79dfff

Issue actions