0.2sec org.apache.calcite.test.DruidAdapter2IT > testInterleaveBetweenAggregateAndGroupOrderByOnMetrics() java.lang.AssertionError: Expected: "store_state=CA; brand_name=King; A=21.4632\nstore_state=OR; brand_name=Symphony; A=32.176\nstore_state=CA; brand_name=Toretti; A=32.2465\nstore_state=WA; brand_name=King; A=34.6104\nstore_state=OR; brand_name=Toretti; A=36.3" but: was "store_state=OR; brand_name=ADJ; A=83.8764\nstore_state=WA; brand_name=Akron; A=85.8402\nstore_state=OR; brand_name=American; A=86.7898\nstore_state=WA; brand_name=ADJ; A=97.6488\nstore_state=CA; brand_name=ADJ; A=98.0076" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.test.CalciteAssert.lambda$checkResult$6(CalciteAssert.java:430) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:559) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$returns$1(CalciteAssert.java:1453) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1392) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1451) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1441) at org.apache.calcite.test.CalciteAssert$AssertQuery.returnsOrdered(CalciteAssert.java:1467) at org.apache.calcite.test.DruidAdapter2IT.testInterleaveBetweenAggregateAndGroupOrderByOnMetrics(DruidAdapter2IT.java:2013) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1, sql=select "store_state", "brand_name", "A" from ( select sum("store_sales")-sum("store_cost") as a, "store_state", "brand_name" from "foodmart" group by "store_state", "brand_name" ) subq order by "A" limit 5 at app//org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:409) at app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:575) ... 6 more

0.4sec org.apache.calcite.test.DruidAdapterIT > testInterleaveBetweenAggregateAndGroupOrderByOnMetrics() java.lang.AssertionError: Expected: "store_state=CA; brand_name=King; A=21.4632\nstore_state=OR; brand_name=Symphony; A=32.176\nstore_state=CA; brand_name=Toretti; A=32.2465\nstore_state=WA; brand_name=King; A=34.6104\nstore_state=OR; brand_name=Toretti; A=36.3" but: was "store_state=OR; brand_name=ADJ; A=83.8764\nstore_state=WA; brand_name=Akron; A=85.8402\nstore_state=OR; brand_name=American; A=86.7898\nstore_state=WA; brand_name=ADJ; A=97.6488\nstore_state=CA; brand_name=ADJ; A=98.0076" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.test.CalciteAssert.lambda$checkResult$6(CalciteAssert.java:430) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:559) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$returns$1(CalciteAssert.java:1453) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1392) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1451) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1441) at org.apache.calcite.test.CalciteAssert$AssertQuery.returnsOrdered(CalciteAssert.java:1467) at org.apache.calcite.test.DruidAdapterIT.testInterleaveBetweenAggregateAndGroupOrderByOnMetrics(DruidAdapterIT.java:2323) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1, sql=select "store_state", "brand_name", "A" from ( select sum("store_sales")-sum("store_cost") as a, "store_state", "brand_name" from "foodmart" group by "store_state", "brand_name" ) subq order by "A" limit 5 at app//org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:409) at app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:575) ... 6 more

Execution failed for task ':druid:test': org.gradle.api.tasks.VerificationException: 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@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/