[
https://issues.apache.org/jira/browse/FLINK-35696?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dawid Wysakowicz closed FLINK-35696.
------------------------------------
Resolution: Fixed
Fixed in 3606302fd3e73f0da5701983fd8b21e3dd610bef
> JSON_VALUE/QUERY functions incorrectly map floating numbers
> -----------------------------------------------------------
>
> Key: FLINK-35696
> URL: https://issues.apache.org/jira/browse/FLINK-35696
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Runtime
> Affects Versions: 1.19.1
> Reporter: Dawid Wysakowicz
> Assignee: Dawid Wysakowicz
> Priority: Major
> Labels: pull-request-available
> Fix For: 2.0.0
>
>
> {code}
> SELECT JSON_VALUE('{"bigNumber":123456789.987654321}', '$.bigNumber')
> {code}
> produces
> {code}
> "1.2345678998765433E8"
> {code}
> which can not be mapped back. It gets rounded.
> The reason is we use {{double}} for floats in {{SqlJsonUtils}}. We should
> rather configure {{jackson}} to use {{BigDecimals}}. In order to do that we
> need to properly shade {{jayway}} though.
> I suggest we:
> 1. Add {{com.jayway.jsonpath:son-path}} to {{flink-shaded}}
> 2. We use the shaded library and pass a configured mapper which maps floats
> to {{BigDecimal}}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
