[
https://issues.apache.org/jira/browse/CALCITE-5799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhen Chen resolved CALCITE-5799.
--------------------------------
Resolution: Won't Fix
> unnest(a) is wrong if a is structKind.PEEK_FIELDS_NO_EXPAND
> ------------------------------------------------------------
>
> Key: CALCITE-5799
> URL: https://issues.apache.org/jira/browse/CALCITE-5799
> Project: Calcite
> Issue Type: Bug
> Reporter: Haojin Wang
> Priority: Critical
>
> when I validate sql "select * from MyTable,UNNEST(N2.D)", throw
> "org.apache.calcite.runtime.CalciteContextException: From line 0, column 0 to
> line 1, column 31: Column 'N2.N2' not found in table 'MYTABLE'" I think this
> is weird.
>
> myTable(
> * a: BIGINT,
> * n1: STRUCT<
> * n11: STRUCT<b: BIGINT>,
> * n12: STRUCT<c: BIGINT>
> * >,
> * n2: STRUCT<d: Array>,
> * e: BIGINT)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)