[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wang Weidong updated CALCITE-3466: ---------------------------------- Description: While convert RelNode to SqlNode, the "group by" statement in subquery was dropped unexpectedly. For example, original sql is: {code:sql} select a, avg(c1) from (select a,sum(d),b as c1 from t_testProjectMerge group by b,a) as t group by a {code} RelNode converted by SqlNode is {code:txt} _LogicalAggregate(group=[{0}], EXPR$1=[AVG($1)]) LogicalProject(A=[$1], C1=[$0]) LogicalAggregate(group=[{0, 1}], EXPR$1=[SUM($2)]) LogicalProject(B=[$1], A=[$0], D=[$3]) EnumerableTableScan(table=[[T_TESTPROJECTMERGE]]) {code} _ was: While convert RelNode to SqlNode, the "group by" statement in subquery was dropped unexpectedly. For example, original sql is: {code:sql} select a, avg(c1) from (select a,sum(d),b as c1 from t_testProjectMerge group by b,a) as t group by a {code} RelNode converted by SqlNode is {code:text} _LogicalAggregate(group=[{0}], EXPR$1=[AVG($1)]) LogicalProject(A=[$1], C1=[$0]) LogicalAggregate(group=[{0, 1}], EXPR$1=[SUM($2)]) LogicalProject(B=[$1], A=[$0], D=[$3]) EnumerableTableScan(table=[[T_TESTPROJECTMERGE]]) {code} _ > JDBC adapter dropped group by statement in subquery > --------------------------------------------------- > > Key: CALCITE-3466 > URL: https://issues.apache.org/jira/browse/CALCITE-3466 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.21.0, 1.22.0 > Reporter: Wang Weidong > Priority: Major > Fix For: 1.22.0 > > > While convert RelNode to SqlNode, the "group by" statement in subquery was > dropped unexpectedly. For example, > original sql is: > {code:sql} > select a, avg(c1) from (select a,sum(d),b as c1 from t_testProjectMerge group > by b,a) as t group by a > {code} > RelNode converted by SqlNode is > {code:txt} > _LogicalAggregate(group=[{0}], EXPR$1=[AVG($1)]) > LogicalProject(A=[$1], C1=[$0]) > LogicalAggregate(group=[{0, 1}], EXPR$1=[SUM($2)]) > LogicalProject(B=[$1], A=[$0], D=[$3]) > EnumerableTableScan(table=[[T_TESTPROJECTMERGE]]) > {code} > _ -- This message was sent by Atlassian Jira (v8.3.4#803005)