Dawid Wysakowicz created FLINK-35696:
----------------------------------------
Summary: 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
Fix For: 1.20.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)
