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.