[jira] [Created] (CALCITE-2468) Index Out-of-Bound Exception when trying to infer operand type from struct return type

["Rong Rong (JIRA)" <ji...@apache.org>]

Rong Rong created CALCITE-2468:
----------------------------------

             Summary: Index Out-of-Bound Exception when trying to infer operand type from struct return type
                 Key: CALCITE-2468
                 URL: https://issues.apache.org/jira/browse/CALCITE-2468
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.17.0
            Reporter: Rong Rong
            Assignee: Julian Hyde


IOOBE was thrown when trying to acquire {{SqlOperandTypeInference}} using {{RETURN_TYPE}} at:
https://github.com/apache/calcite/blob/branch-1.17/core/src/main/java/org/apache/calcite/sql/type/InferTypes.java#L68

The follow SQLs demonstrates how to trigger the exception over a simple Schema:

{code:yaml}
- table1:
  - structType1:
    - intField
  - structType2:
    - intField
    - bigintField
{code}

- Exception SQL:
{code:sql}
SELECT structType1 AS myStructType FROM table1
{code}

- Correct SQL:
{code:sql}
SELECT structType1 FROM table1
{code}
{code:sql}
SELECT structType2 AS myStructType FROM table1
{code}

I will pasted an e2e SQL + DDL reproduction test asap.




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)