[CALCITE-2232] Assertion error on AggregatePullUpConstantsRule while adjusting Aggregate indices

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.16.0
• Fix Version/s: 1.17.0
• Component/s: core
• Assignee: Jesús Camacho Rodríguez
• Reporter: Jesús Camacho Rodríguez
• Created: 30/Mar/18 01:11
• Updated: 27/Feb/24 22:23
• Resolved: 30/Mar/18 01:20

Description

Executing the following query:

select ename, sal
from (select '1', ename, sal from emp where ename = 'John') subq
group by ename, sal;

results in the following error:

java.lang.AssertionError: Cannot add expression of different type to set:
set type is RecordType(VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary" NOT NULL ENAME, INTEGER NOT NULL SAL) NOT NULL
expression type is RecordType(INTEGER NOT NULL ENAME, INTEGER NOT NULL SAL) NOT NULL
set is rel#21:LogicalAggregate(input=HepRelVertex#20,group={1, 5})
expression is LogicalProject#24