[
https://issues.apache.org/jira/browse/CALCITE-5128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17531539#comment-17531539
]
Jiajun Xie edited comment on CALCITE-5128 at 5/4/22 7:54 AM:
-------------------------------------------------------------
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}
[~mhearn] If you omit ` t.` it should be parsed successfully.
Do we still need to support complex identifiers?
was (Author: jiajunbernoulli):
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}
[~mhearn] If you omit ` t.` it should be parsed successfully.
Do we still need support complex identifiers?
> 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)
