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
Statement stmt = CCJSqlParserUtil.parse(
"update TEST " +
"set cd = '3' " +
"where (cd, bcd) in (('1', ' '), ('2', ' '))")
;
An error occurs as follows:
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," ","
at line 3, column 12.
Was expecting one of:
"&"
"&&"
")"
"::"
"<<"
">>"
"AND"
"COLLATE"
"^"
"|"
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:20583)
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:20433)
at net.sf.jsqlparser.parser.CCJSqlParser.AndExpression(CCJSqlParser.java:6724)
at net.sf.jsqlparser.parser.CCJSqlParser.OrExpression(CCJSqlParser.java:6687)
at net.sf.jsqlparser.parser.CCJSqlParser.Expression(CCJSqlParser.java:6658)
at net.sf.jsqlparser.parser.CCJSqlParser.WhereClause(CCJSqlParser.java:5675)
at net.sf.jsqlparser.parser.CCJSqlParser.Update(CCJSqlParser.java:943)
at net.sf.jsqlparser.parser.CCJSqlParser.SingleStatement(CCJSqlParser.java:127)
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:70)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:36)
... 24 more
Caused by:
The text was updated successfully, but these errors were encountered:
Query operating on Oracle 12c
Statement stmt = CCJSqlParserUtil.parse(
"update TEST " +
"set cd = '3' " +
"where (cd, bcd) in (('1', ' '), ('2', ' '))")
;
An error occurs as follows:
net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "," ","
at line 3, column 12.
Was expecting one of:
Caused by:
The text was updated successfully, but these errors were encountered: