Can anyone confirm this: in a SOQL Where clause, when comparing an ID field to a 15-character string variable, the comparison works.
I didn't expect it to work, but it does and I am surprised. I can't find any documentation to confirm it. I thought 18-character ID was always in effect, and comparing 18-char ID to 15-char string would fail.
Example (Country__c is a lookup field):
String tmpID = 'a1he0000000EkAi'; Account acct = [select ID from Account where Country__c = :tmpID];