[
https://issues.apache.org/jira/browse/CALCITE-6404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17845261#comment-17845261
]
colagy wang commented on CALCITE-6404:
--------------------------------------
[~mbudiu] Thank you for reply. The grammar was worked in calcite parser, but
not supported in the "unparse()" mothod of the "SqlUpdate" class.
> 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)
