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?