If I have the table t defined as:
a--- 1 1 2
and I say:
select count(a=1) from t;
should it give me 1 or 2 as a result? I'm getting 2, and I'd think Ishould get 1....