Hi Amit, The contributing section of the website [1] should have everything you need to get started.
* Create a test case reproducing the problem possibly in SqlToRelConverterTest. * (Optional) Identify the cause of the regression (using git bisect or other means) and ask the author for help. * Workout a solution. * Submit a PR and wait for the review. Best, Stamatis [1] https://calcite.apache.org/develop/#contributing On Mon, Aug 5, 2019 at 7:49 PM Amit Chavan <[email protected]> wrote: > Thanks, Chunwei. > > Is there anything you need me to do for this ticket? I have sent the UT > earlier. I can also work on the fix if needed. I will need some help to get > started. If there is any work you guys have for a newbie on the project > please send it my way. > > On Sun, Aug 4, 2019 at 8:20 PM Chunwei Lei (JIRA) <[email protected]> wrote: > > > 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) > > >
