[ https://issues.apache.org/jira/browse/CALCITE-6123?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stamatis Zampetakis updated CALCITE-6123: ----------------------------------------- Summary: DruidAdapterIT#testInterleaveBetweenAggregateAndGroupOrderByOnMetrics fails (was: DruidAdapter2IT is failing ) > DruidAdapterIT#testInterleaveBetweenAggregateAndGroupOrderByOnMetrics fails > --------------------------------------------------------------------------- > > Key: CALCITE-6123 > URL: https://issues.apache.org/jira/browse/CALCITE-6123 > Project: Calcite > Issue Type: Bug > Components: tests > Affects Versions: 1.36.0 > Reporter: Benchao Li > Assignee: Stamatis Zampetakis > Priority: Major > Labels: pull-request-available > Attachments: image-2023-11-19-15-17-53-699.png > > > The test that is failing is > testInterleaveBetweenAggregateAndGroupOrderByOnMetrics and the error is shown > below: > {noformat} > FAILURE 0.6sec, 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:453) > at > org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:582) > at > org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$returns$1(CalciteAssert.java:1495) > at > org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1434) > at > org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1493) > at > org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1483) > at > org.apache.calcite.test.CalciteAssert$AssertQuery.returnsOrdered(CalciteAssert.java:1509) > at > org.apache.calcite.test.DruidAdapterIT.testInterleaveBetweenAggregateAndGroupOrderByOnMetrics(DruidAdapterIT.java:2336) > 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:389) > at > app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:598) > ... 6 more > {noformat} > > The test is all failing after > [https://github.com/apache/calcite/commit/55034513b463c938035e5d2436949bbf734b84b6], > I'm not sure whether it's related. > See following jobs: > * [https://github.com/apache/calcite/actions/runs/6886169664/job/18731435605] > * [https://github.com/apache/calcite/actions/runs/6885301555/job/18729238762] > * [https://github.com/apache/calcite/actions/runs/6871630651/job/18688793776] > * [https://github.com/apache/calcite/actions/runs/6860287671/job/18653876601] -- This message was sent by Atlassian Jira (v8.20.10#820010)