Chunwei Lei created CALCITE-3229:
------------------------------------
Summary: 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
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)
