Thread: Bug?

Bug?

From
Tom Werges
Date:
When I execute the following query:

"select p.id, s.name from phys p, phys_spec s where p.r_phys_spec = s.id and
p.r_phys_spec > 0"

.... it returns nothing. However if I add " AND p.id=585" to the end of that
query, it returns _one result_.

How is that possible? Add an extra condition and get back more results? The
second query logically must return a set equal to or smaller than the second.

Am I missing something? What does a person generally do in a situation like
this?

Background : v 6.4.2, downloaded and compiled like 4 days ago, on Red Hat 5.2
w/ gcc 2.7.2.

TIA
tom