bug: failing to deserialize f64 correctly

[densumesh]

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]

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