Jesus Camacho Rodriguez created CALCITE-2232:
------------------------------------------------
Summary: Assertion error on AggregatePullUpConstantsRule
Key: CALCITE-2232
URL: https://issues.apache.org/jira/browse/CALCITE-2232
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.16.0
Reporter: Jesus Camacho Rodriguez
Assignee: Jesus Camacho Rodriguez
Fix For: 1.17.0
Executing the following query:
{code:sql}
select ename, sal
from (select '1', ename, sal from emp where ename = 'John') subq
group by ename, sal;
{code}
results in the following error:
{code}
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
{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
