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’
When trying the request in Grafana (create panel, table view) same request
Tried aslo in grafana panel, with postgre data source (see screenshot)
select cast(23846924472030377 as text)
also returns 23846924472030378
Why does it happen? Any ideas for workaround?