[CALCITE-6123] DruidAdapterIT#testInterleaveBetweenAggregateAndGroupOrderByOnMetrics fails - ASF JIRA

XML

Word

Printable

JSON

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: 1.36.0
Fix Version/s: 1.37.0
Component/s: tests
Labels:
- pull-request-available

Description

The test that is failing is testInterleaveBetweenAggregateAndGroupOrderByOnMetrics and the error is shown below:

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

The test is all failing after https://github.com/apache/calcite/commit/55034513b463c938035e5d2436949bbf734b84b6, I'm not sure whether it's related.

See following jobs: