I am using Postgres and I have a strange problem. When I run a select query in datagrip, the result is different from the query when I ran through psql client.
Result from Datagrip
Result from Psql
If you look at has_not_tampered column, the result set is different.
Note that I have connected through same credentials and queried same table from both clients. No changes done in between.
I have run "Synchronize" and "Invalidate Cache and Restart" couple of times, but still the data is not refreshed.
Appreciate anyone who can point me in right direction.