You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
JSqlParser failed to parse Teradata "UPDATE" statement with "FROM" clause #891
Describe the bug
JSqlParser failed to parse Teradata "UPDATE" statement with "FROM" clause.
To Reproduce
Steps to reproduce the behavior:
SQL: update a from db1.table1 a, db2.tabl2 b set a.column1 = b.column1 where a.column2 = b.column2;
Exception:
Exception in thread "main" net.sf.jsqlparser.JSQLParserException
at net.sf.jsqlparser.parser.CCJSqlParserManager.parse(CCJSqlParserManager.java:25)
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "FROM" "FROM"
at line 1, column 10.
Was expecting one of:
","
"ACTION"
"ANY"
"AS"
...
"XML"
"ZONE"
<K_DATETIMELITERAL>
<K_DATE_LITERAL>
<S_CHAR_LITERAL>
<S_IDENTIFIER>
<S_QUOTED_IDENTIFIER>
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:21726)
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:21573)
at net.sf.jsqlparser.parser.CCJSqlParser.Update(CCJSqlParser.java:850)
at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:132)
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:75)
at net.sf.jsqlparser.parser.CCJSqlParserManager.parse(CCJSqlParserManager.java:23)
changed the title [-]JSqlParser failed to parse Teradata "UPDATA" statement with "FROM" clause[/-][+]JSqlParser failed to parse Teradata "UPDATE" statement with "FROM" clause[/+]on Nov 3, 2019
Activity
[-]JSqlParser failed to parse Teradata "UPDATA" statement with "FROM" clause[/-][+]JSqlParser failed to parse Teradata "UPDATE" statement with "FROM" clause[/+]