[ 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)