[
https://issues.apache.org/jira/browse/CALCITE-5799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17739338#comment-17739338
]
Jiajun Xie commented on CALCITE-5799:
-------------------------------------
Maybe CALCITE-5126 can solve the issue.
[~pyro] , can you use calcite >= 1.32 to reproduce the it?
> 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)
