xibosignage / xibo

Xibo Digital Signage
https://xibosignage.com
GNU Affero General Public License v3.0
572 stars 164 forks source link

DataSet: Value discrepancy when storing large integers in number values #3404

Closed ifarzana closed 1 month ago

ifarzana commented 5 months ago

Description: When entering the number value "123456789" into a dataset column, it is displayed as "123457000" in the Data Entry table.

29d521b241b0263a5c3ff1d5fef63743cd875ac7

4addedbfd482dde7fa290cfdf84ddc371c3f8db5

This issue likely arises due to the limitations of floating-point arithmetic, which can lead to rounding errors, especially with very large integers.