[DRILL-6817] Update to_number function to be consistent with CAST function

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.15.0
• Labels: doc-complete
• Assignee: Bohdan Kazydub
• Reporter: Bohdan Kazydub
• Reviewer: Vitalii Diravka
• Created: 30/Oct/18 11:30
• Updated: 02/Oct/19 18:38
• Resolved: 20/Nov/18 07:18

Description

In case when `drill.exec.functions.cast_empty_string_to_null` is enabled casting empty string ('') to numeric types will return NULL. If `to_number` is used to convert empty string to a number, UnsupportedOperationException will be thrown.

The aim is to make these functions (CASTs and `to_number`) work consistently as is done for date/time functions.

Issue Links

• is part of: DRILL-6768 Improve to_date, to_time and to_timestamp and corresponding cast functions to handle empty string when `drill.exec.functions.cast_empty_string_to_null` option is enabled