0.0sec org.apache.calcite.test.DruidAdapter2IT > testFilterClauseSameAsOuterFilterGone() java.sql.SQLException: Error while executing SQL "select sum("store_sales") filter (where "store_city" = 'Seattle') from "foodmart" where "store_city" = 'Seattle'": Error while applying rule DruidAggregateProjectRule, args [rel#108828:BindableAggregate.BINDABLE.[](input=RelSubset#108818,group={},EXPR$0=SUM($0) FILTER $1), rel#108819:BindableProject.BINDABLE.[](input=RelSubset#108792,exprs=[$90, IS TRUE(=($62, 'Seattle'))]), rel#108791:DruidQuery.BINDABLE.[](table=[foodmart, foodmart],intervals=[1900-01-09T00:00:00.000Z/2992-01-10T00:00:00.000Z],filter==($62, 'Seattle'))] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:163) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:227) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:534) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$queryContains$10(CalciteAssert.java:1788) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1474) at org.apache.calcite.test.CalciteAssert$AssertQuery.queryContains(CalciteAssert.java:1787) at org.apache.calcite.test.DruidAdapter2IT.testFilterClauseSameAsOuterFilterGone(DruidAdapter2IT.java:2200) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=0 at org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:324) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:566) ... 4 more Caused by: java.lang.RuntimeException: Error while applying rule DruidAggregateProjectRule, args [rel#108828:BindableAggregate.BINDABLE.[](input=RelSubset#108818,group={},EXPR$0=SUM($0) FILTER $1), rel#108819:BindableProject.BINDABLE.[](input=RelSubset#108792,exprs=[$90, IS TRUE(=($62, 'Seattle'))]), rel#108791:DruidQuery.BINDABLE.[](table=[foodmart, foodmart],intervals=[1900-01-09T00:00:00.000Z/2992-01-10T00:00:00.000Z],filter==($62, 'Seattle'))] at org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:262) at org.apache.calcite.plan.volcano.IterativeRuleDriver.drive(IterativeRuleDriver.java:61) at org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:529) at org.apache.calcite.tools.Programs.lambda$standard$3(Programs.java:274) at org.apache.calcite.tools.Programs$SequenceProgram.run(Programs.java:334) at org.apache.calcite.prepare.Prepare.optimize(Prepare.java:172) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:306) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:215) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:648) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:514) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:484) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:235) at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:562) at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:675) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:156) ... 6 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: [CIRCULAR REFERENCE RuntimeException] Next exception 3: java.lang.NullPointerException: value must not be null, kind: IS_NOT_NULL at java.util.Objects.requireNonNull(Objects.java:290) at org.apache.calcite.rex.RexSimplify$SargCollector.accept1(RexSimplify.java:2695) at org.apache.calcite.rex.RexSimplify$SargCollector.accept_(RexSimplify.java:2623) at org.apache

0.0sec org.apache.calcite.test.DruidAdapterIT > testFilterClauseSameAsOuterFilterGone() java.sql.SQLException: Error while executing SQL "select sum("store_sales") filter (where "store_city" = 'Seattle') from "foodmart" where "store_city" = 'Seattle'": Error while applying rule DruidAggregateProjectRule, args [rel#133899:BindableAggregate.BINDABLE.[](input=RelSubset#133889,group={},EXPR$0=SUM($0) FILTER $1), rel#133890:BindableProject.BINDABLE.[](input=RelSubset#133874,exprs=[$90, IS TRUE(=($62, 'Seattle'))]), rel#133873:DruidQuery.BINDABLE.[](table=[foodmart, foodmart],intervals=[1900-01-09T00:00:00.000Z/2992-01-10T00:00:00.000Z],filter==($62, 'Seattle'))] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:163) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:227) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:534) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$queryContains$10(CalciteAssert.java:1788) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1474) at org.apache.calcite.test.CalciteAssert$AssertQuery.queryContains(CalciteAssert.java:1787) at org.apache.calcite.test.DruidAdapterIT.testFilterClauseSameAsOuterFilterGone(DruidAdapterIT.java:2509) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=0 at org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:324) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:566) ... 4 more Caused by: java.lang.RuntimeException: Error while applying rule DruidAggregateProjectRule, args [rel#133899:BindableAggregate.BINDABLE.[](input=RelSubset#133889,group={},EXPR$0=SUM($0) FILTER $1), rel#133890:BindableProject.BINDABLE.[](input=RelSubset#133874,exprs=[$90, IS TRUE(=($62, 'Seattle'))]), rel#133873:DruidQuery.BINDABLE.[](table=[foodmart, foodmart],intervals=[1900-01-09T00:00:00.000Z/2992-01-10T00:00:00.000Z],filter==($62, 'Seattle'))] at org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:262) at org.apache.calcite.plan.volcano.IterativeRuleDriver.drive(IterativeRuleDriver.java:61) at org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:529) at org.apache.calcite.tools.Programs.lambda$standard$3(Programs.java:274) at org.apache.calcite.tools.Programs$SequenceProgram.run(Programs.java:334) at org.apache.calcite.prepare.Prepare.optimize(Prepare.java:172) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:306) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:215) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:648) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:514) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:484) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:235) at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:562) at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:675) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:156) ... 6 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: [CIRCULAR REFERENCE RuntimeException] Next exception 3: java.lang.NullPointerException: value must not be null, kind: IS_NOT_NULL at java.util.Objects.requireNonNull(Objects.java:290) at org.apache.calcite.rex.RexSimplify$SargCollector.accept1(RexSimplify.java:2695) at org.apache.calcite.rex.RexSimplify$SargCollector.accept_(RexSimplify.java:2623) at org.apache.ca

0.0sec org.apache.calcite.test.DruidAdapter2IT > testOrCombinationOfExpAndSimpleFilter() java.sql.SQLException: Error while executing SQL "SELECT COUNT(*) FROM "foodmart" where ("city" || "state_province") = 'SpokaneWA' OR ("state_province" = 'CA' AND "city" IS NOT NULL)": value must not be null, kind: IS_NOT_NULL at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:163) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:227) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:534) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$queryContains$10(CalciteAssert.java:1788) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1474) at org.apache.calcite.test.CalciteAssert$AssertQuery.queryContains(CalciteAssert.java:1787) at org.apache.calcite.test.DruidAdapter2IT.testOrCombinationOfExpAndSimpleFilter(DruidAdapter2IT.java:2922) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=0 at org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:324) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:566) ... 4 more Caused by: java.lang.NullPointerException: value must not be null, kind: IS_NOT_NULL at java.util.Objects.requireNonNull(Objects.java:290) at org.apache.calcite.rex.RexSimplify$SargCollector.accept1(RexSimplify.java:2695) at org.apache.calcite.rex.RexSimplify$SargCollector.accept_(RexSimplify.java:2623) at org.apache.calcite.rex.RexSimplify$SargCollector.accept(RexSimplify.java:2604) at org.apache.calcite.rex.RexSimplify$SargCollector.access$400(RexSimplify.java:2593) at org.apache.calcite.rex.RexSimplify.lambda$simplifyAnd$2(RexSimplify.java:1323) at java.util.ArrayList.forEach(ArrayList.java:1259) at org.apache.calcite.rex.RexSimplify.simplifyAnd(RexSimplify.java:1323) at org.apache.calcite.rex.RexSimplify.simplify(RexSimplify.java:277) at org.apache.calcite.rex.RexSimplify.simplifyList(RexSimplify.java:512) at org.apache.calcite.rex.RexSimplify.simplifyOr(RexSimplify.java:1772) at org.apache.calcite.rex.RexSimplify.simplify(RexSimplify.java:279) at org.apache.calcite.rex.RexSimplify.simplifyUnknownAs(RexSimplify.java:246) at org.apache.calcite.rex.RexSimplify.simplifyUnknownAsFalse(RexSimplify.java:235) at org.apache.calcite.rex.RexSimplify.simplifyFilterPredicates(RexSimplify.java:2561) at org.apache.calcite.tools.RelBuilder.filter(RelBuilder.java:1255) at org.apache.calcite.tools.RelBuilder.filter(RelBuilder.java:1242) at org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimmer.java:601) at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:532) at org.apache.calcite.sql2rel.RelFieldTrimmer.dispatchTrimFields(RelFieldTrimmer.java:284) at org.apache.calcite.sql2rel.RelFieldTrimmer.trimChild(RelFieldTrimmer.java:226) at org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimmer.java:1020) at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:532) at org.apache.calcite.sql2rel.RelFieldTrimmer.dispatchTrimFields(RelFieldTrimmer.java:284) at org.apache.calcite.sql2rel.RelFieldTrimmer.trim(RelFieldTrimmer.java:171) at org.apache.calcite.sql2rel.SqlToRelConverter.trimUnusedFields(SqlToRelConverter.java:543) at org.apache.calcite.prepare.Prepare.trimUnusedFields(Prepare.java:377) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:291) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:215) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:648) at org.apache.calcite.prepare.Calc

0.0sec org.apache.calcite.test.DruidAdapterIT > testWhereGroupBy() java.sql.SQLException: Error while executing SQL "select "wikipedia"."countryName" as "c0", sum("wikipedia"."count") as "m1", sum("wikipedia"."deleted") as "m2", sum("wikipedia"."delta") as "m3" from "wiki" as "wikipedia" where ("wikipedia"."countryName" in ('Colombia', 'France', 'Germany', 'India', 'Italy', 'Russia', 'United Kingdom', 'United States') or "wikipedia"."countryName" is null) group by "wikipedia"."countryName"": value must not be null, kind: IS_NULL at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:163) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:227) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:534) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$queryContains$10(CalciteAssert.java:1788) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1474) at org.apache.calcite.test.CalciteAssert$AssertQuery.queryContains(CalciteAssert.java:1787) at org.apache.calcite.test.DruidAdapterIT.testWhereGroupBy(DruidAdapterIT.java:1412) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=0 at org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:324) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:566) ... 4 more Caused by: java.lang.NullPointerException: value must not be null, kind: IS_NULL at java.util.Objects.requireNonNull(Objects.java:290) at org.apache.calcite.rex.RexSimplify$SargCollector.accept1(RexSimplify.java:2695) at org.apache.calcite.rex.RexSimplify$SargCollector.accept_(RexSimplify.java:2623) at org.apache.calcite.rex.RexSimplify$SargCollector.accept(RexSimplify.java:2604) at org.apache.calcite.rex.RexSimplify$SargCollector.access$400(RexSimplify.java:2593) at org.apache.calcite.rex.RexSimplify.lambda$simplifyOrs$6(RexSimplify.java:1797) at java.util.ArrayList.forEach(ArrayList.java:1259) at org.apache.calcite.rex.RexSimplify.simplifyOrs(RexSimplify.java:1797) at org.apache.calcite.rex.RexSimplify.simplifyOr(RexSimplify.java:1774) at org.apache.calcite.rex.RexSimplify.simplify(RexSimplify.java:279) at org.apache.calcite.rex.RexSimplify.simplifyUnknownAs(RexSimplify.java:246) at org.apache.calcite.rex.RexSimplify.simplifyUnknownAsFalse(RexSimplify.java:235) at org.apache.calcite.rex.RexSimplify.simplifyFilterPredicates(RexSimplify.java:2561) at org.apache.calcite.tools.RelBuilder.filter(RelBuilder.java:1255) at org.apache.calcite.tools.RelBuilder.filter(RelBuilder.java:1242) at org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimmer.java:601) at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:532) at org.apache.calcite.sql2rel.RelFieldTrimmer.dispatchTrimFields(RelFieldTrimmer.java:284) at org.apache.calcite.sql2rel.RelFieldTrimmer.trimChild(RelFieldTrimmer.java:226) at org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimmer.java:473) at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:532) at org.apache.calcite.sql2rel.RelFieldTrimmer.dispatchTrimFields(RelFieldTrimmer.java:284) at org.apache.calcite.sql2rel.RelFieldTrimmer.trimChild(RelFieldTrimmer.java:226) at org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimmer.java:1020) at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:532) at org.apache.calcite.sql2rel.RelFieldTrimmer.dispatchTrimFields(RelFieldTrimmer.java:284) at org.apache.calcite.sql2rel.RelFieldTrimmer.trim(RelFieldTrimmer.java:171) at org.apache.calcite.sql2rel.SqlToRelConverter.trimUnusedFields(S

0.0sec org.apache.calcite.test.DruidAdapterIT > testOrCombinationOfExpAndSimpleFilter() java.sql.SQLException: Error while executing SQL "SELECT COUNT(*) FROM "foodmart" where ("city" || "state_province") = 'SpokaneWA' OR ("state_province" = 'CA' AND "city" IS NOT NULL)": value must not be null, kind: IS_NOT_NULL at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:163) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:227) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:534) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$queryContains$10(CalciteAssert.java:1788) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1474) at org.apache.calcite.test.CalciteAssert$AssertQuery.queryContains(CalciteAssert.java:1787) at org.apache.calcite.test.DruidAdapterIT.testOrCombinationOfExpAndSimpleFilter(DruidAdapterIT.java:3479) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=0 at org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:324) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:566) ... 4 more Caused by: java.lang.NullPointerException: value must not be null, kind: IS_NOT_NULL at java.util.Objects.requireNonNull(Objects.java:290) at org.apache.calcite.rex.RexSimplify$SargCollector.accept1(RexSimplify.java:2695) at org.apache.calcite.rex.RexSimplify$SargCollector.accept_(RexSimplify.java:2623) at org.apache.calcite.rex.RexSimplify$SargCollector.accept(RexSimplify.java:2604) at org.apache.calcite.rex.RexSimplify$SargCollector.access$400(RexSimplify.java:2593) at org.apache.calcite.rex.RexSimplify.lambda$simplifyAnd$2(RexSimplify.java:1323) at java.util.ArrayList.forEach(ArrayList.java:1259) at org.apache.calcite.rex.RexSimplify.simplifyAnd(RexSimplify.java:1323) at org.apache.calcite.rex.RexSimplify.simplify(RexSimplify.java:277) at org.apache.calcite.rex.RexSimplify.simplifyList(RexSimplify.java:512) at org.apache.calcite.rex.RexSimplify.simplifyOr(RexSimplify.java:1772) at org.apache.calcite.rex.RexSimplify.simplify(RexSimplify.java:279) at org.apache.calcite.rex.RexSimplify.simplifyUnknownAs(RexSimplify.java:246) at org.apache.calcite.rex.RexSimplify.simplifyUnknownAsFalse(RexSimplify.java:235) at org.apache.calcite.rex.RexSimplify.simplifyFilterPredicates(RexSimplify.java:2561) at org.apache.calcite.tools.RelBuilder.filter(RelBuilder.java:1255) at org.apache.calcite.tools.RelBuilder.filter(RelBuilder.java:1242) at org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimmer.java:601) at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:532) at org.apache.calcite.sql2rel.RelFieldTrimmer.dispatchTrimFields(RelFieldTrimmer.java:284) at org.apache.calcite.sql2rel.RelFieldTrimmer.trimChild(RelFieldTrimmer.java:226) at org.apache.calcite.sql2rel.RelFieldTrimmer.trimFields(RelFieldTrimmer.java:1020) at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:532) at org.apache.calcite.sql2rel.RelFieldTrimmer.dispatchTrimFields(RelFieldTrimmer.java:284) at org.apache.calcite.sql2rel.RelFieldTrimmer.trim(RelFieldTrimmer.java:171) at org.apache.calcite.sql2rel.SqlToRelConverter.trimUnusedFields(SqlToRelConverter.java:543) at org.apache.calcite.prepare.Prepare.trimUnusedFields(Prepare.java:377) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:291) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:215) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:648) at org.apache.calcite.prepare.Calcite

Execution failed for task ':druid:test': There were failing tests. See the report at: file:///home/runner/work/calcite/calcite/calcite/druid/build/reports/tests/test/index.html

Execution failed for task ':druid:test'. > There were failing tests. See the report at: file:///home/runner/work/calcite/calcite/calcite/druid/build/reports/tests/test/index.html

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v1, actions/checkout@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/