I think that total failure was the only right answer

If the WHERE clause used IN or EXISTS that two rows returned from the subquery would not cause a failure or any warning, but certainly if it is a boolean operator expecting a singleton, then it would fail.