Inconsistent reading of records between Arcgis Pro and rdbms admin tool

yockee

I have data collected and stored in database.

Then I read the data from Arcgis Pro, PGAadmin and Navicat. Strangely, the 2 types of apps give out different readings.

First, in arcgis pro. I filtered the result using : orig_fid = 2827 or orig_fid = 6242. The result is as follows :

 

Second, using Navicat and PGAdmin. I run these very same queries on both apps :

select orig_fid, sts_survey,coalesce(sts_survey,'xyz') as sts_survey2
from ptt_survey.ptt_bnba_2026 where (orig_fid = 2827 or orig_fid = 6242)

The query has 2 different methods in pulling the data. One is using "sts_survey", the other one is using "coalesce(sts_survey,'xyz')"
The result is as follows :

Question:

1. Why are the reads not consistent ? PGAdmin / Navicat VS Arcgispro give out different results. PGAdmin / Navicat give out "NULL" and "done_", where as Arcgispro is always "done_".

The correct one is "done_".

2. How does Arcgispro read the records ? There is no versioning.

Thanks