[CALCITE-2468] Validator throws IndexOutOfBoundsException when trying to infer operand type from struct return type

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.17.0
• Fix Version/s: 1.18.0
• Component/s: core
• Assignee: Julian Hyde
• Reporter: Rong Rong
• Created: 16/Aug/18 02:32
• Updated: 19/Sep/19 19:18
• Resolved: 06/Dec/18 08:56

Description

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:

- table1:
  - structType1:
    - intField
  - structType2:
    - intField
    - bigintField

• Exception SQL:

  SELECT structType1 AS myStructType FROM table1
  

• Correct SQL:

  SELECT structType1 FROM table1
  

  SELECT structType2 AS myStructType FROM table1
  

E2E example can be found in:
https://github.com/apache/calcite/commit/d5fb1f9fc5d3f9583128d9ee35c4a23e8470d54d

Issue Links

• relates to: FLINK-10019 singleton row type objects returned from sub query cannot be chained with other operators