[CALCITE-3186] IN expressions in UPDATE statements throws Exceptions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 1.20.0
• Fix Version/s: 1.22.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Pressenna
• Created: 09/Jul/19 11:34
• Updated: 28/May/21 10:09
• Resolved: 03/Oct/19 22:34

Description

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.

Issue Links

• depends upon: CALCITE-3219 Allow finer control over which expressions get expanded in SqlToRelConverter
• is caused by: CALCITE-2427 Sub-queries not supported in DML statements
• links to: GitHub Pull Request #1341