[
https://issues.apache.org/jira/browse/CALCITE-5128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17531958#comment-17531958
]
Julian Hyde commented on CALCITE-5128:
--------------------------------------
It seems to be a bug in DataGrip. Postgres doesn't support qualified names in
SET either. From [Postgres
UPDATE|https://www.postgresql.org/docs/current/sql-update.html]:
{quote}Do not include the table's name in the specification of a target column
— for example, {{UPDATE table_name SET table_name.col = 1}} is invalid.
{quote}
> Support qualified names in UPDATE
> ---------------------------------
>
> 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)
