[
https://issues.apache.org/jira/browse/DRILL-6817?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16727114#comment-16727114
]
Bridget Bevens commented on DRILL-6817:
---------------------------------------
Added a note about the change in behavior here: I added the note to this page
with a very simple example: https://drill.apache.org/docs/data-type-conversion/
> Update to_number function to be consistent with CAST function
> -------------------------------------------------------------
>
> Key: DRILL-6817
> URL: https://issues.apache.org/jira/browse/DRILL-6817
> Project: Apache Drill
> Issue Type: Improvement
> Reporter: Bohdan Kazydub
> Assignee: Bohdan Kazydub
> Priority: Major
> Labels: doc-complete
> Fix For: 1.15.0
>
>
> {{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.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
