You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Haojin Wang (Jira)" <ji...@apache.org> on 2023/06/26 10:11:00 UTC

[jira] [Created] (CALCITE-5799) unnest(a) is wrong if a is structKind.PEEK_FIELDS_NO_EXPAND

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)