[ https://issues.apache.org/jira/browse/CALCITE-2221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Igor Guzenko reassigned CALCITE-2221: ------------------------------------- Assignee: Igor Guzenko > 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: Igor Guzenko > 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 (v8.3.4#803005)