What happens when an item satisfies only one of the conditions linked with OR?

The query selects it since items need to satisfy at least one condition.