Expected behaviour in a query filtering by parent null field

Question

What should I spect when the account is null in the below code?

SELECT Id, name, Account__c
FROM AccountChildren
WHERE Account__r.someField = true

I am having issues debugging the query and I would like to know what it is supposed to happen

Answer 1

As Pranay mentioned in the comments you will not see an error. You can easily test this by creating an Opportunity and not assigning an Account. Then run the following query in the Developer console:

SELECT Id, name, AccountId
FROM Opportunity
WHERE Account.Name ='test'