InfluxQL - MIN subquery truncates decimal part

Welcome & Getting Started
,
1

I’ve got a simple subquery that calculates the latest free space % on a disk for the given time window

SELECT
  last("available_space") / last("total_space") AS "Free Space %"
FROM "rp"."volume_space"
WHERE time >= now() - 1h
GROUP BY
   "server"
  ,"volume"

The source values are integers, the result of division is a decimal number (between 0 and 1)
So far so good, the returned value look like those:
sever | volume | Free Space %
Server1 | C | 0.5622
Server1 | D | 0.2608
Server2 | C | 0.8465
Server2 | D | 0.9100

now, I need to get the worst case per server, just the “Free Space %” and “server”.
so I just add a simple min over the previous result

SELECT
  min("Free Space %") AS "Least Free Space %"
FROM (
SELECT
  last("available_space") / last("total_space") AS "Free Space %"
FROM "rp"."volume_space"
WHERE time >= now() - 1h
GROUP BY
   "server"
  ,"volume"
)
GROUP BY
  "server"

Now all the returned value are 0

source:
Server1 | C | 0.5622
Server1 | D | 0.2608
Server2 | C | 0.8465
Server2 | D | 0.9100
expected result
Server1 | 0.2608
Server2 | 0.8465
actual result
Server1 | 0
Server2 | 0

to avoid having just zeroes, I’ve multiplied the first result by 100, so I get numbers in a range 0-100 (instead of 0-1). what I can say is that the decimal part gets truncated.
26.08 becomes just 26

is this the standard behavior?
Am I missing something?

2

Hello @Giovanni_Luisotto,
Can you please try to multiply by 100.00?
I’m not sure if that’s standard behavior. It could be worth while to submit an issue:

1 Like
3

Can’t believe I missed that…
Still, it feels strange as decimal * integer produces an integer result. I’ll open an issue about it.

1 Like