[ZBX-23536] Decimal precision inconsistency in Top hosts widget (PostgreSQL) Created: 2023 Oct 12  Updated: 2024 Apr 10  Resolved: 2023 Dec 05

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 6.0.23rc1, 6.4.8rc1, 7.0.0alpha7
Fix Version/s: None

Type: Problem report Priority: Major
Reporter: Eliza Sekace Assignee: Zabbix Development Team
Resolution: Won't fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: PNG File decimals_postgresql.png    
Team: Team A
Sprint: Sprint 105 (Oct 2023), Sprint 106 (Nov 2023), Sprint 107 (Dec 2023)

 Description   

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.

  1. create a host;
  2. add Zabbix trapper item to this host, item type - Numeric(unsigned);
  3. send any value to the item;
  4. create a top hosts widget;
  5. add a column with created item;
  6. add aggregation function 'avg' to this column;
  7. 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

 Comments   
Comment by Alexander Vladishev [ 2023 Dec 05 ]

This is expected behavior. Closed as Won't Fix.

Generated at Sun Apr 13 19:47:46 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.