JSqlParser
JSqlParser copied to clipboard
CREATE TRIGGER sql queries do NOT get parsed nor validated.
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