[
https://issues.apache.org/jira/browse/CALCITE-5799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17741501#comment-17741501
]
Haojin Wang commented on CALCITE-5799:
--------------------------------------
[~julianhyde] Excuse me, do you have time to look at this?
> 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)
