[ https://issues.apache.org/jira/browse/CALCITE-2221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shuyi Chen updated CALCITE-2221: -------------------------------- Description: 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($2, 1).EMPNO], EXPR$0$1=[ITEM($2, 1).ENAME], EXPR$0$2=[ITEM($2, 1).DETAIL]) LogicalTableScan(table=[[CATALOG, SALES, DEPT_NESTED]]) was: 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]]) > 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 > Priority: Major > > 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($2, 1).EMPNO], EXPR$0$1=[ITEM($2, 1).ENAME], > EXPR$0$2=[ITEM($2, 1).DETAIL]) > LogicalTableScan(table=[[CATALOG, SALES, DEPT_NESTED]]) -- This message was sent by Atlassian JIRA (v7.6.3#76005)