On ArcGIS Pro v2.6.2
When using "Select By Location" with the Input Features coming from a Polygon Feature Class in an Enterprise Geodatabase (an Oracle DB), and the Selecting Features coming from a Point Feature Class in a File Geodatabase, I'm experiencing unusual/inaccurate selection results. When I attempt the same thing with both the Input and Selecting Features coming from a File GDB my results are correct.
For example, I am attempting to select the total number of parks (Polygon FC in an Enterprise GDB) that intersect with a Point FC that I have saved locally in a FGDB. My attribute table is open and showing selected records when I click "Apply".
![Fariss_Agatone_0-1607458360330.png Fariss_Agatone_0-1607458360330.png](https://community.esri.com/t5/image/serverpage/image-id/1712i2F5C5ECDCB0EDF8A/image-size/medium?v=v2&px=400)
As shown in the screenshot, it appears that 362 of my records have been selected. This is correct - I have confirmed this count by using "Select By Location" on a copy of my Enterprise GDB data in a FGDB.
However, when I click "Show All Records" on my attribute table, the total number of selected records changes to 242. Of note - the total number of selected records in the table isn't actually changing - only the number showing at the bottom of the AT is changing.
![Fariss_Agatone_1-1607458558252.png Fariss_Agatone_1-1607458558252.png](https://community.esri.com/t5/image/serverpage/image-id/1715iCFFF361374C006F9/image-size/medium?v=v2&px=400)
Then, clicking back to "Show Selected Records" still shows 242. Of note - the total number of selected records in the table changes when I do this.
![Fariss_Agatone_2-1607458632326.png Fariss_Agatone_2-1607458632326.png](https://community.esri.com/t5/image/serverpage/image-id/1717iFD1B27E5EA7DEC7B/image-size/medium?v=v2&px=400)
I have tried this workflow with multiple FCs (both locally and EGDB), and believe the issue is that by Input Features are coming from the Enterprise GDB. I experience the same behavior with different counts in testing. The first result is always correct, but then clicking between selected features and showing all features will then alter the number. I didn't notice this issue before 2.6.2. Has this behavior been reported previously, or has anyone else had this problem?