[CALCITE-5137] EnumerableUncollect throws NPE if input has ((List) null)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.31.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Dmitry Sysolyatin
• Reporter: Dmitry Sysolyatin
• Created: 07/May/22 19:19
• Updated: 03/Aug/22 16:21
• Resolved: 17/May/22 02:07

Description

EnumerableUncollect throws NPE when an input has element = ((List) null)

Example:

SELECT * FROM UNNEST(CAST(null AS INTEGER ARRAY))

In a real situation, it can appear if to use left join. For example:

SELECT ARRAY(SELECT * FROM UNNEST(t.x)) FROM (VALUES(1)) LEFT JOIN (SELECT ARRAY[1] as x, 2 as y) t ON t.y = 1

Issue Links

• links to: GitHub Pull Request #2793