[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16881190#comment-16881190 ]
Pressenna commented on CALCITE-3186: ------------------------------------ It is hitting a needToImplement issue in {{org.apache.calcite.sql.validate.SqlValidatorImpl.getValidatedNodeType(SqlNode).}} I see if I can extend test coverage for it. > 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 > Priority: Major > > 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)