Repository navigation
[BUG] JSQLParser 4.7-SNAPSHOT(+4.6) PostgreSQL(+others) Enum error on ReferentialAction.Type.valueOf() when delete/update keyword is lowercase #1779
Description
Activity
Thanks, I will fix that tomorrow.
Thank you again, there were quite a number of similar problematic calls to other
Enum.
I have refactored all of them intoEnum.from(...)with an implementation like:public static Type from(String name) { return Enum.valueOf(Type.class, name.toUpperCase()); }
- added 2 commits that reference this issue
on May 3, 2023 - added a commit that references this issue
on Jun 15, 2023 - added a commit that references this issue
on Jun 27, 2023
Failing SQL Feature:
Parsing CreateTable statement fails if the "delete/update" keyword in outline foreign key constraint is lowercase.
Technically not supported but in practice everything except this works in either case.
SQL Example:
CREATE TABLE DATABASES
(
NAME VARCHAR(50) NOT NULL,
OWNER VARCHAR(50) NOT NULL,
PRIMARY KEY (NAME),
FOREIGN KEY(OWNER) REFERENCES USERS (USERNAME) ON delete CASCADE
);
Software Information:
Problem
CCJSqlParser.java lines 17281, 17302, 20970, 20991 in 4.7-SNAPSHOT:
fkIndex.setReferentialAction(ReferentialAction.Type.valueOf(tk.image), action);
Lines 20900 and 20921 are affected as well:
alterExp.setReferentialAction(ReferentialAction.Type.valueOf(tk.image), action);
Solution
changing tk.image to tk.image.toUpperCase() should work