[CALCITE-2963] IndexOutOfBoundsException in RelStructuredTypeFlattener when accessing nested fields - ASF JIRA

XML

Word

Printable

JSON

When accessing nested field in a STRUCTURED SqlType, sometimes RelStructuredTypeFlattener will crash with java.lang.IndexOutOfBoundsException

The test case is in SqlToRelConverterTest.java

@Test
public void testNestedColumnCrash()

{ final String sql = "select mailing_address.zip from sales.emp_address where home_address.city = 'abc'"; sql(sql).ok(); }

The root cause is that when generate new RelNode for old RelNode, we did not consider whether the flattened field list needs null indicator.

Is contained by

CALCITE-3138 RelStructuredTypeFlattener doesn't restructure ROW type fields

relates to

CALCITE-2900 RelStructuredTypeFlattener generates wrong types on nested columns