[jira] [Created] (CALCITE-6757) Elasticsearch adapter returns wrong result when aggregating sub-query with aggregation

[xiong duan (Jira)]

xiong duan created CALCITE-6757:
-----------------------------------

             Summary: Elasticsearch adapter returns wrong result when 
aggregating sub-query with aggregation
                 Key: CALCITE-6757
                 URL: https://issues.apache.org/jira/browse/CALCITE-6757
             Project: Calcite
          Issue Type: Bug
    Affects Versions: 1.38.0
            Reporter: xiong duan


{code:java}
@Test void testAggregate() {
  CalciteAssert.that()
      .with(AggregationAndSortTest::createConnection)
      .query("select count(*) from (select cat5, sum(val1) from view group by 
cat5) as alias")
      .returnsUnordered("EXPR$0=1\n" +
          "EXPR$0=1\n" +
          "EXPR$0=1");
} {code}
The return result should be EXPR$0=3.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)