[ https://issues.apache.org/jira/browse/CALCITE-5128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17531539#comment-17531539 ]
Jiajun Xie commented on CALCITE-5128: ------------------------------------- I think the reason is that target column only support SimpleIdentifier. {code:java} UPDATE pz.Moon t SET ^t.^name = ? WHERE t.obj_id = ? AND t.image IS NULL AND t.mass = ? AND t.name LIKE ? ESCAPE '#' AND t.parent_id = ? {code} > SQL parser doesn't seem to understand UPDATE statements with fqns > ----------------------------------------------------------------- > > Key: CALCITE-5128 > URL: https://issues.apache.org/jira/browse/CALCITE-5128 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.30.0 > Reporter: Mike Hearn > Priority: Major > > The following SQL fails to parse: > {{UPDATE pz.Moon t SET t.name = ? WHERE t.obj_id = ? AND t.image IS NULL AND > t.mass = ? AND t.name LIKE ? ESCAPE '#' AND t.parent_id = ?}} > This sort of query is generated by DataGrip to update cells. The error is: > {{Caused by: org.apache.calcite.sql.parser.impl.ParseException: Encountered > "." at line 1, column 23.}} > {{Was expecting:}} > {{ "=" ...}} > {{ }} > {{ at > org.apache.calcite.sql.parser.impl.SqlParserImpl.generateParseException(SqlParserImpl.java:37112)}} > {{ at > org.apache.calcite.sql.parser.impl.SqlParserImpl.jj_consume_token(SqlParserImpl.java:36926)}} > {{ at > org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlUpdate(SqlParserImpl.java:7285)}} > {{ at > org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmt(SqlParserImpl.java:3806)}} > {{ at > org.apache.calcite.sql.parser.impl.SqlParserImpl.SqlStmtEof(SqlParserImpl.java:3828)}} > {{ at > org.apache.calcite.sql.parser.impl.SqlParserImpl.parseSqlStmtEof(SqlParserImpl.java:201)}} > {{ at > org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:158)}} > {{ ... 35 more}} > -- This message was sent by Atlassian Jira (v8.20.7#820007)