Andreas Piening06/08/2022, 8:41 PM
and run the following query:
I receive floating point values with 1-2 digits after the decimal point as expected. However, the same query in
SELECT path, type, ROUND((blocks_available * blocks_size * 10e-10), 2) AS free_gb, ROUND ((blocks_available * 1.0 / blocks * 1.0) * 100, 2) AS free_perc FROM mounts WHERE path = '/';
gives me strange values like
for the column
. Same is true when I do this query on the console with
. There is something wrong with parsing floating point results I guess.