Oracle "or" operator not behaving as anticipated

The following query is not returning the 3 results, I would anticipate. How come? I've had to use the "union all" to get around this behavior.





select mfcd_id


from acd_chemstruct


where


jc_equals(smiles,'Cc1ccccc1Br') = 1


or jc_equals(smiles,'Cc1cccc(Br)c1C') = 1


or jc_equals(smiles,'Brc1ccccc1C=C') = 1

This problem is fixed in 3.0.15 and will be fixed in 3.1.1.