I have attached a reproducer testcase for my problem. The problem is not in the planner itself but in the Sql to Rel conversion
https://issues.apache.org/jira/browse/CALCITE-3826 I am sorry I am not able to open Calcite with IntelliJ nor NetBeans. I can push the producer to a github repo if you prefer, it is a simpler JUnit based test case Hope this helps Enrico Il giorno mar 25 feb 2020 alle ore 14:50 Enrico Olivelli <[email protected]> ha scritto: > > Il giorno mar 25 feb 2020 alle ore 14:43 Vladimir Sitnikov > <[email protected]> ha scritto: > > > > >Does any ring bell ? > > > > Is it related to [CALCITE-3672] Support implicit type coercion for insert > > and update ? > > https://issues.apache.org/jira/browse/CALCITE-3672 > > https://github.com/apache/calcite/pull/1720 > > > Vladimir, Danny, > yes I think that that patch can be the trigger of the regression. > I see that tests do not deal with bind variables. > > I wonder if there is some way to disable the new behaviour > otherwise I feel this can be a real blocker for the release. > > > > > > > >I am now trying to install IntelliJ, but it won't be so immediate > > > > AFAIK it should be seamless, so please follow up if you run into issues. > > I am able to open the project, I just have to get used to IntelliJ, no > problem. > > Enrico > > > > > Vladimir
