[
https://issues.apache.org/jira/browse/CALCITE-6404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17845435#comment-17845435
]
Mihai Budiu commented on CALCITE-6404:
--------------------------------------
In this case you should probably update the title of this issue to reflect the
fact that unparse does not work correctly for update statements. Also, this
does not look like a critical bug, I would mark it as minor. Do you plan to
work on a fix?
> 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)
