Closed
Description
Describe the bug
CREATE TRIGGER sql queries do NOT get parsed nor validated.
To Reproduce
Steps to reproduce the behavior:
- Example SQL: create trigger stud_marks before INSERT on Student for each row set Student.total = Student.subj1 + Student.subj2, Student.per = Student.total * 60 / 100;
- Parsing this SQL using JSqlParser with this statements
- Exception:
net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "create" "CREATE"
at line 1, column 1.
Was expecting one of:
"("
"ALTER"
"CALL"
"COMMENT"
"COMMIT"
"DECLARE"
"DELETE"
"DESCRIBE"
"DROP"
"EXEC"
"EXECUTE"
"EXPLAIN"
"GRANT"
"INSERT"
"MERGE"
"PURGE"
"RENAME"
"RESET"
"ROLLBACK"
"SAVEPOINT"
"SET"
"SHOW"
"TRUNCATE"
"UPDATE"
"UPSERT"
"USE"
"VALUES"
"WITH"
<K_SELECT>
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:190)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:38)
Expected behavior
Should parse the sql. If validated, no errors should exist.
System
- Database you are using: IBM DB2
- Java Version: Java 8
- JSqlParser version: 4.3
Metadata
Metadata
Assignees
Labels
No labels