-
Problem report
-
Resolution: Won't fix
-
Major
-
None
-
6.0.23rc1, 6.4.8rc1, 7.0.0alpha7
-
None
-
Sprint 105 (Oct 2023), Sprint 106 (Nov 2023), Sprint 107 (Dec 2023)
Decimal place inconsistency occurs in the Top Hosts widget when using the 'avg' aggregation.
When using MySQL DB, 4 digits after comma are displayed, but with PostgreSQL, a lot more digits are displayed after comma.
Steps to reproduce:
Conditions : PostgreSQL database.
- create a host;
- add Zabbix trapper item to this host, item type - Numeric(unsigned);
- send any value to the item;
- create a top hosts widget;
- add a column with created item;
- add aggregation function 'avg' to this column;
- save the widget and observe that when you hover over the result in the top hosts widget, approximately 20 digits are shown after the decimal point in the hintbox:
Note: This issue cannot be reproduced, if MySQL database is used