Can someone help me understand why this query is returning 1 less record than expected when a Date custom field (Due_Date__c) is included in the SELECT clause? As you can see in the screenshot, it's returning 180 of 181 records. It is not sending a nextRecordsUrl for a queryMore, and with only 181 records, there's not really a reason it would. It's just returning one less record than it says it will.
SELECT Id, Due_Date__c FROM Case WHERE MHHE_Mobile_Sync_Flag__c = true
If I remove the Due_Date__c field, I get 181 of 181 returned, as expected:
Is there any logical reason this would happen?