Niels Pardon created CALCITE-6576:
-------------------------------------
Summary: SqlParser does not support using UPDATE table alias with
column identifiers in SET
Key: CALCITE-6576
URL: https://issues.apache.org/jira/browse/CALCITE-6576
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.37.0
Reporter: Niels Pardon
Assignee: Niels Pardon
The Apache Calcite SQL parser does allow to assign a table alias within an
UPDATE statement but the table alias can currently not be used with the column
identifiers within the SET section.
The following can be parsed successfully:
{code:sql}
UPDATE mytable AS t SET ID=1;
UPDATE mytable t SET ID=1;
{code}
But the parser fails as soon as the table alias is used with the column
identifier in the SET section:
{code:sql}
UPDATE mytable AS t SET t.ID=1;
UPDATE mytable t SET t.ID=1;
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
