[DRILL-8066] Cannot convert non-finite floating point literals

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.20.0
• Assignee: James Turton
• Reporter: James Turton
• Created: 03/Dec/21 12:36
• Updated: 03/Jan/22 13:56
• Resolved: 03/Jan/22 13:56

Description

Drill can process floating point values like -Infinity, +Infinity and NaN but it fails to correctly convert queries containing these values as constants during planning.  E.g. this query produces a NumberFormatException.

 

select cast('-Infinity' as float);