Pressenna created CALCITE-3186: ---------------------------------- Summary: IN expressions in UPDATE statements throwing Exceptions Key: CALCITE-3186 URL: https://issues.apache.org/jira/browse/CALCITE-3186 Project: Calcite Issue Type: Bug Affects Versions: 1.20.0 Reporter: Pressenna
The patch to get correlated sub-queries working in UPDATE statements had this side-effect. {code:java} 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);{code} These seem to raise exceptions now. -- This message was sent by Atlassian JIRA (v7.6.3#76005)