[CALCITE-4145] Exception when query from UDF field with structured type

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.23.0, 1.24.0
• Fix Version/s: 1.25.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Danny Chen
• Reporter: Danny Chen
• Created: 28/Jul/20 08:17
• Updated: 27/Oct/22 04:54
• Resolved: 29/Jul/20 03:24

Description

Check this sql in SqlToRelConverterTest

@Test void testUdfWithStructuredReturnType() {
    final String sql = "SELECT deptno, tmp.r.not_null_field, tmp.r.nullable_field FROM\n"
        + "(SELECT deptno, ROW_FUNC() AS r from dept)tmp";
    sql(sql).ok();
  }

ArrayIndexOutOfBoundsException throws because the nested field got a -1 index when querying the field by simple name.

To solve the problem, for a nested field, return its parent field's monotonicity.

Issue Links

• is related to: CALCITE-1518 Converting SELECT table.nested.field FROM (...) to RelNode throws ArrayIndexOutOfBoundsException
• links to: GitHub Pull Request #2088