[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16895756#comment-16895756 ]
Pressenna commented on CALCITE-3186: ------------------------------------ [~danny0405], I created a PR with a test case and a fix for the immediate problem. > IN expressions in UPDATE statements throws 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 > Priority: Major > Labels: pull-request-available > Time Spent: 10m > Remaining Estimate: 0h > > 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.14#76016)