SELECT OrderAmount, OrderDate, Title , LastModifiedTime FROM SCOPE() WHERE CONTAINS(PATH,'"http://orders.contoso.com/OrdersList"') AND OrderDate='2012-10-01 07:15:00'
You expect the result of this query to return two documents as there are only two documents that have the value '2012-10-01 07:15:00' for the OrderDate field.
In this scenario, if you have the OrderDate managed property set to be used in scopes, then the results from this query will return a few other documents including the correct one from that date and time you are searching for.
If you do not have the managed property set to be used in scopes, you will see the correct results.
If the query with high restriction, such as the one shown in the symptom part of the document, returning correct result is what is the requirement, then do not set the managed property that is used in the WHERE clause of the query to be used in scopes.
Article ID: 2813380 - Last Review: Apr 26, 2013 - Revision: 1