Grafana displays +1 value to long sting, that contains of numbers

Faced the issue trying to filter out values by id.
unit_id is a varchar

SELECT DISTINCT unit_id FROM table1 WHERE unit_id = ‘23846924472030377’

returns 23846924472030377

When trying the request in Grafana (create panel, table view) same request

returns 23846924472030378

Tried aslo in grafana panel, with postgre data source (see screenshot)
select ‘23846924472030377’

retuned 23846924472030378

select cast(23846924472030377 as text)
also returns 23846924472030378

Why does it happen? Any ideas for workaround?

This topic was automatically closed after 365 days. New replies are no longer allowed.