If either of the two predicates in ORed condition returns rows, you should get atleast that many rows in result sets.

Paste the exact sql you are running in sqlprompt here. The one you pasted above seems not correct.