calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chunwei Lei (JIRA)" <>
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
             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( at org.apache.calcite.sql.validate.SqlValidatorImpl.getValidatedNodeType(
at org.apache.calcite.sql2rel.SqlToRelConverter.findSubQueries(
at org.apache.calcite.sql2rel.SqlToRelConverter.findSubQueries(
at org.apache.calcite.sql2rel.SqlToRelConverter.replaceSubQueries(
at org.apache.calcite.sql2rel.SqlToRelConverter.convertUpdate(
at org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive(
at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery( at


>From the thread []

This message was sent by Atlassian JIRA

View raw message