I have seen several Sierra/Spotlight questions posted but none are what I am experiencing.
I am not receiving any errors when re-indexing. My migration to Sierra from El Capitan went without a glitch. However Spotlight does not return accurate results. Files I know exist do not show up.
My first and second thought was there is a corrupt mdstore, Rebuilt mdstore multiple times to no avail.
Observation 1 - mdfind in terminal works as expected. Finding all the files expected. However Spotlight does not.
Observation 2 - In Finder when using the first available search box the results are wrong and identical to spotlight results
Observation 3 - In Finder when using secondary search boxes (click + sign to open up additional search boxes) and clearing the first search box then all files are found as expected identical to mdfind.
So now I only use mdfind or finder with detailed search boxes and all is ok
Is this a bug in Spotlight and not an mdstore issue?
Sound like a bug to me