colagy wang created CALCITE-6404:
------------------------------------
Summary: 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
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)
