bug: failing to deserialize f64 correctly

ClickHouse / clickhouse-rs

Official pure Rust typed client for ClickHouse DB

https://clickhouse.com

Apache License 2.0

315 stars 87 forks source link

Open densumesh opened 3 months ago

densumesh commented 3 months ago

Hi!

We are trying to return an f64 back from clickhouse and seems to be returning garbage data. Any advice?

Our query is

But we are getting back data like this

When the actual data returned should be:

Thanks for the help!

densumesh commented 3 months ago

We fixed this by turning the middle select into a CTE: