Commit graph

3 commits

Author SHA1 Message Date
Alvar Penning
34ac3867a9 PostgreSQL: get_sla_ok_percent to return decimal
The final division within the get_sla_ok_percent SQL function in its
PostgreSQL implementation silently truncated decimal places. An explicit
decimal cast resulted for this equation resulted in a decimal value.

To both verify and catch this in the future, a test with odd numbers was
added. This already succeeded for MySQL, but needed the modified schema
for PostgreSQL.

Closes #648.
2024-03-20 13:16:24 +01:00
Yonas Habteab
fa6c23d634 Make json keys and DB columns consistent 2022-06-24 16:00:11 +02:00
Julian Brost
5ea82188dc SLA reporting: tests for the SQL stored function 2022-05-13 12:04:47 +02:00