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

XML

Word

Printable

JSON

Details

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

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.

Attachments

Issue Links

is related to

CALCITE-1518 Converting SELECT table.nested.field FROM (...) to RelNode throws ArrayIndexOutOfBoundsException

Closed

links to

GitHub Pull Request #2088

Activity

People

Assignee:: Danny Chen

Reporter:: Danny Chen

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 28/Jul/20 08:17

Updated:: 27/Oct/22 04:54

Resolved:: 29/Jul/20 03:24

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

40m