Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

json_parse: values mismatch between Velox/Presto #12371

Open
peterenescu opened this issue Feb 18, 2025 · 0 comments
Open

json_parse: values mismatch between Velox/Presto #12371

peterenescu opened this issue Feb 18, 2025 · 0 comments
Labels
bug Something isn't working fuzzer-found

Comments

@peterenescu
Copy link
Contributor

peterenescu commented Feb 18, 2025

Description

Value mismatch between Presto and Velox for function json_parse.

Reproduction

(Presto followed by Velox)

presto:di> select json_parse('{"1K\u20b7G*\u20bd)": 0.00011893594637513161, ">x`\u068f": 0.22971552493982017, "D\u2afa\u20bf1\u0429\u25a0\u0912\u25e9\u0469\u220a\u27d5h\u06fb\u2049\u04ab\u2179\u2022\u225c\u3056\u0930": 0.5025517863687128, "Y6\u04e3c": 0.6978196897543967, "Z\u0629": 0.8981520135421306, "\\\u04a3l\u03f8fV\u25ab\u2a1c\u2aa3\u2a6f\u27c1\u200e\u224f\u0436\u20b7\u25a2.\u209a": 0.3671785709448159, "\u06ccEb\u308djr\u2a47\u2018\u043fXGa\u2064V\u25d4\u0158=": 0.015072801383212209, "\u0905": 0.3609812443610281}');
                                                                                                                               _col0                                                                                                                                
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 {"1K₷G*₽)":1.1893594637513161E-4,">x`ڏ":0.22971552493982017,"D⫺₿1Щ■ऒ◩ѩ∊⟕hۻ⁉ҫⅹ•≜ざर":0.5025517863687128,"Y6ӣc":0.6978196897543967,"Zة":0.8981520135421306,"\\ңlϸfV▫⨜⪣⩯⟁‎≏ж₷▢.ₚ":0.3671785709448159,"یEbろjr⩇‘пXGa⁤V◔Ř=":0.015072801383212209,"अ":0.3609812443610281} 
(1 row)
presto:di> select json_parse(c0) from (values ('{"1K\u20b7G*\u20bd)": 0.00011893594637513161, ">x`\u068f": 0.22971552493982017, "D\u2afa\u20bf1\u0429\u25a0\u0912\u25e9\u0469\u220a\u27d5h\u06fb\u2049\u04ab\u2179\u2022\u225c\u3056\u0930": 0.5025517863687128, "Y6\u04e3c": 0.6978196897543967, "Z\u0629": 0.8981520135421306, "\\\u04a3l\u03f8fV\u25ab\u2a1c\u2aa3\u2a6f\u27c1\u200e\u224f\u0436\u20b7\u25a2.\u209a": 0.3671785709448159, "\u06ccEb\u308djr\u2a47\u2018\u043fXGa\u2064V\u25d4\u0158=": 0.015072801383212209, "\u0905": 0.3609812443610281}')) t(c0);
                                                                                                                                _col0                                                                                                                                
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 {"1K₷G*₽)":0.00011893594637513161,">x`ڏ":0.22971552493982017,"D⫺₿1Щ■ऒ◩ѩ∊⟕hۻ⁉ҫⅹ•≜ざर":0.5025517863687128,"Y6ӣc":0.6978196897543967,"Zة":0.8981520135421306,"\\ңlϸfV▫⨜⪣⩯⟁‎≏ж₷▢.ₚ":0.3671785709448159,"یEbろjr⩇‘пXGa⁤V◔Ř=":0.015072801383212209,"अ":0.3609812443610281} 
(1 row)
@peterenescu peterenescu added bug Something isn't working fuzzer Issues related the to Velox fuzzer test components. fuzzer-found labels Feb 18, 2025
@peterenescu peterenescu changed the title json_parse: keys mismatch between Velox/Presto json_parse: values mismatch between Velox/Presto Feb 18, 2025
@kagamiori kagamiori removed the fuzzer Issues related the to Velox fuzzer test components. label Feb 19, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working fuzzer-found
Projects
None yet
Development

No branches or pull requests

2 participants