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]])
Attachments
Issue Links
- Is contained by
-
CALCITE-3138 RelStructuredTypeFlattener doesn't restructure ROW type fields
-
- Closed
-