-
Type:
Bug
-
Status: Resolved
-
Priority:
Major
-
Resolution: Invalid
-
Affects Version/s: 1.20.0
-
Fix Version/s: None
-
Component/s: None
-
Labels:
The patch to get correlated sub-queries working in UPDATE statements had this side-effect.
CREATE TABLE t1 (id1 INT, val1 TEXT); CREATE TABLE t2 (id2 INT, val2 TEXT); UPDATE t1 SET val1 = 't2' WHERE id1 IN (1, 2, 3); -- or UPDATE t1 SET val1 = 't2' WHERE id1 IN (SELECT id2 FROM t2);
These seem to raise exceptions now.
- depends upon
-
CALCITE-3219 Allow finer control over which expressions get expanded in SqlToRelConverter
-
- Closed
-
- is caused by
-
CALCITE-2427 Sub-queries not supported in DML statements
-
- Closed
-
- links to