[CALCITE-3082] NPE in SqlUtil#getSelectListItem

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.20.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Laurent Goujon
• Reporter: Laurent Goujon
• Created: 21/May/19 18:13
• Updated: 24/Jun/19 15:02
• Resolved: 30/May/19 20:12

Description

Queries similar to SELECT 1 UNION SELECT 2, 3 causes validator to throws a NullPointerException instance instead of a proper error message about the column count mismatch.

SqlUtil#getSelectListItem is used by Set operators to get select items if the types of operands don't match. Unfortunately the method may throw an NPE exception if one of the operand doesn't have a FROM clause.

Issue Links

• links to: GitHub Pull Request #1225