1. When I do Spatial join between two Polygon feature classes with below parameters, then i get 8 number of records as result:
Target Features - Polygon feature class-1
Join Features - Polygon feature class-2
Output feature class- .gdb path with file name
Join Operation - 'Join one to one'
Keep all target features - unchecked
Match Option - 'Are Identical to'
Search radius - blank
2. When I do Select By Location Operation with below parameters, then i get 10 number of records as result:
Ideally I should get same result, since Relationship I am using is 'Are Identical to'.
Please through some light here.
Looks like you have found a possible bug in Arcpro and how the different tools reconcile the relation Are Identical to. I would say you should edit your question and include the test data as a zip file for people to test to see if others can replicate the issue and discount if it is a hardware issue.
I cannot upload the data since it's client data. However, I had tried on multiple machines, and I got same issue.
Well fake some data that creates the same problem and share? If it turns out that your fake data does not recreate the problem it would suggest an issue with your data/data source. Also its good practise to state which version of Arcpro you are using.