Evgeny Stanilovsky created CALCITE-5667: -------------------------------------------
Summary: Unexpected result with aggregate inside subquery Key: CALCITE-5667 URL: https://issues.apache.org/jira/browse/CALCITE-5667 Project: Calcite Issue Type: Bug Components: core Affects Versions: 1.34.0 Reporter: Evgeny Stanilovsky {noformat} CREATE TABLE TBL1(ID INT PRIMARY KEY, VAL int); insert into TBL1 values (1, 1), (2, 2); select (select(sum(VAL))) from TBL1; <-- await 3 as a result {noformat} but obtain : {noformat} 1 2 {noformat} appropriate Quidem test for _blank.iq_ {noformat} select (select(sum(I))) from bar;{noformat} explain shows : {noformat} EnumerableCalc(expr#0..2=[{inputs}], EXPR$0=[$t2]) EnumerableCorrelate(correlation=[$cor0], joinType=[left], requiredColumns=[{0}]) EnumerableTableScan(table=[[BLANK, BAR]]) EnumerableAggregate(group=[{}], EXPR$0=[SUM($0)]) EnumerableCalc(expr#0=[{inputs}], expr#1=[$cor0], expr#2=[$t1.I], $f0=[$t2]) EnumerableValues(tuples=[[{ 0 }]]){noformat} -- This message was sent by Atlassian Jira (v8.20.10#820010)