[ https://issues.apache.org/jira/browse/CALCITE-3229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16907746#comment-16907746 ]
Chunwei Lei edited comment on CALCITE-3229 at 8/15/19 1:50 AM: --------------------------------------------------------------- Fixed in [7625938f1faa37fe34540d3a7a2257ec7eae5704|https://github.com/apache/calcite/commit/7625938f1faa37fe34540d3a7a2257ec7eae5704]. was (Author: chunwei lei): Fixed in [7625938f1faa37fe34540d3a7a2257ec7eae5704|7625938f1faa37fe34540d3a7a2257ec7eae5704]. > UnsupportedOperationException for UPDATE with IN query > ------------------------------------------------------ > > Key: CALCITE-3229 > URL: https://issues.apache.org/jira/browse/CALCITE-3229 > Project: Calcite > Issue Type: Bug > Reporter: Chunwei Lei > Assignee: Chunwei Lei > Priority: Major > Labels: pull-request-available > Fix For: 1.21.0 > > Time Spent: 1h 10m > Remaining Estimate: 0h > > Query 2- "UPDATE tblspace1.table1 set n1=1000" + "WHERE k1 in (SELECT fk FROM > tblspace1.table2 WHERE k2=?)" java.lang.UnsupportedOperationException: class > org.apache.calcite.sql.SqlBasicCall: `K1` IN (SELECT `table2`.`fk` AS `FK` > FROM `tblspace1`.`table2` AS `TABLE2` WHERE `table2`.`k2` = ?) at > org.apache.calcite.util.Util.needToImplement(Util.java:967) at > org.apache.calcite.sql.validate.SqlValidatorImpl.getValidatedNodeType(SqlValidatorImpl.java:1579) > at > org.apache.calcite.sql2rel.SqlToRelConverter.findSubQueries(SqlToRelConverter.java:1802) > at > org.apache.calcite.sql2rel.SqlToRelConverter.findSubQueries(SqlToRelConverter.java:1776) > at > org.apache.calcite.sql2rel.SqlToRelConverter.replaceSubQueries(SqlToRelConverter.java:1011) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertUpdate(SqlToRelConverter.java:3570) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:3172) > at > org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:563) > at org.apache.calcite.prepare.PlannerImpl.rel(PlannerImpl.java:254) > > From the thread > [https://lists.apache.org/thread.html/67cb614ddd123a9092fdf37ace279eb563838b045a5554ad0005f030@%3Cdev.calcite.apache.org%3E] -- This message was sent by Atlassian JIRA (v7.6.14#76016)