[jira] [Updated] (HIVE-27885) Cast decimal from string with space without digits before dot returns NULL

[Naresh P R (Jira)]

     [ 
https://issues.apache.org/jira/browse/HIVE-27885?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Naresh P R updated HIVE-27885:
------------------------------
    Description: 
eg.,

select cast(".0000 " as decimal(8,4))
{code:java}
– Expected output
0.0000
– Actual output
NULL
{code}
select cast("0.0000 " as decimal(8,4))
{code:java}
– Actual output
0.0000
{code}

  was:
eg.,

select cast(".0000 " as decimal(8,4))

 
{code:java}
– Expected output
0.0000
– Actual output
NULL
{code}
select cast("0.0000 " as decimal(8,4))

 
{code:java}
– Actual output
0.0000
{code}
 


> Cast decimal from string with space without digits before dot returns NULL
> --------------------------------------------------------------------------
>
>                 Key: HIVE-27885
>                 URL: https://issues.apache.org/jira/browse/HIVE-27885
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Naresh P R
>            Assignee: Naresh P R
>            Priority: Major
>
> eg.,
> select cast(".0000 " as decimal(8,4))
> {code:java}
> – Expected output
> 0.0000
> – Actual output
> NULL
> {code}
> select cast("0.0000 " as decimal(8,4))
> {code:java}
> – Actual output
> 0.0000
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)