Why a SOQL Query Returns Incorrect Results in CRM?

Question:

A SOQL Query uses a filter that is unique and indexed. It may return incorrect results in the Sandbox.

Example:

SELECT Id,External_ID_vod__c,Name from Address_vod__c where Account_vod__r.External_ID_vod__c = '123456'

No results are returned even though there are actual results matching there.

Answer:

This is a Salesforce-known issue. It is due to an index on the custom field which gets corrupted during a Sandbox refresh.

Remove and Recreate Unique properties of the custom field External.

Product Support Portal