[
https://issues.apache.org/jira/browse/CALCITE-6404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17845070#comment-17845070
]
Mihai Budiu commented on CALCITE-6404:
--------------------------------------
According to the reference grammar
https://calcite.apache.org/docs/reference.html Calcite should support UPDATE
statement.
The syntax of your statement looks wrong according to the grammar, I don't
think there should be a FROM clause in an UPDATE statement.
> update support subquery
> -----------------------
>
> Key: CALCITE-6404
> URL: https://issues.apache.org/jira/browse/CALCITE-6404
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.37.0
> Reporter: colagy wang
> Priority: Critical
>
> calcite have not support this sql yet, can support this?
> {code:java}
> UPDATE "cubeappdata"."UD_1_QNBB6_ptfwfyybmfyb"
> SET sys_sort = subquery.rownum * 100000 FROM (SELECT id, ROW_NUMBER() OVER
> (ORDER BY create_time) AS rownum FROM
> "cubeappdata"."UD_1_QNBB6_ptfwfyybmfyb") AS subquery
> WHERE "cubeappdata"."UD_1_QNBB6_ptfwfyybmfyb".id = subquery.id;
> {code}
> I had using subquery in update sql, but it did not working.
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
