SQL Queries are not returning the same results as ArcGIS Queries, when these queries are run on versioned data.
Edits to versioned data are written directly to the supporting delta (A&D) tables of the versioned objects. ArcSDE clients, such as ArcMap and ArcCatalog, use the combination of the entries in the business table and the delta tables to return results of queries.
Native SQL is not aware of these delta tables, so DBMS SQL queries query only the business tables of the versioned objects.
Only if all the edits are fully compressed to the business table will the same results be returned. See Related Information section for instructions on how to compress a versioned database to state 0.
The above information also applies when using either 2-Way or Full Model 1-Way replicas.
For Simple Model 1-Way replica, the data in the child replica geodatabase is assumed to be non-versioned; therefore, synchronized changes are placed directly into the business tables.
Get help from ArcGIS experts
Download the Esri Support App