Julian Hyde created CALCITE-2244:
------------------------------------
Summary: CTEs in DML: "WITH ... INSERT / UPDATE / DELETE / MERGE"
Key: CALCITE-2244
URL: https://issues.apache.org/jira/browse/CALCITE-2244
Project: Calcite
Issue Type: Bug
Reporter: Julian Hyde
Assignee: Julian Hyde
Support common-table expressions (CTEs) in DML. In other words, allow INSERT,
UPDATE, DELETE, MERGE statements to be prefixed by a WITH clause that defines
"temporary views".
E.g. {code}WITH TokyoEmps AS
SELECT *
FROM Emps
WHERE office = 'Tokyo'
DELETE FROM Tokyo Emps{code}
The effect should be pretty much the same as if {{TokyoEmps}} were a view.
This is not standard SQL. As of SQL 2014, only a {{<query expression>}} can
have a {{<with clause>}}.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
