Shuyi Chen created CALCITE-2221:
-----------------------------------
Summary: RelRoot.project does not take into account flattened
record type
Key: CALCITE-2221
URL: https://issues.apache.org/jira/browse/CALCITE-2221
Project: Calcite
Issue Type: Task
Components: core
Reporter: Shuyi Chen
Assignee: Julian Hyde
To reproduce, simply run:
@Test public void testFlattenRecords() {
sql("select employees[1] from dept_nested").ok();
}
It will yield:
LogicalProject(EXPR$0=[$0])
LogicalProject(EXPR$0$0=[ITEM($6, 1).EMPNO], EXPR$0$1=[ITEM($6, 1).ENAME],
EXPR$0$2=[ITEM($6, 1).DETAIL])
LogicalProject(DEPTNO=[$0], NAME=[$1], TYPE=[$2.TYPE], DESC=[$2.DESC],
A=[$2.OTHERS.A], B=[$2.OTHERS.B], EMPLOYEES=[$3])
LogicalTableScan(table=[[CATALOG, SALES, DEPT_NESTED]])
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
