calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chunwei Lei (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CALCITE-3229) UnsupportedOperationException for UPDATE with IN query
Date Mon, 05 Aug 2019 03:20:00 GMT
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)

Mime
View raw message