Haojin Wang created CALCITE-5799:
------------------------------------
Summary: 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
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)
