Re: Problem with null dates in 7.2

Shouldn't you be using,

SELECT * FROM foo WHERE bar_date IS NULL?

"= null" got phased out, I believe.

David

"Jon" <xilj_74@hotmail.com> wrote in message
news:lMFa8.138677$a07.38860107@typhoon.southeast.rr.com...

I've just compiled 7.2 under HPUX 10.20 and upgraded my data from 7.1.3
(followed the upgrade guide verbatim). I now have a big problem trying to
select date types with null values. The following example gives 0

results,

although some do exist -

select * from foo where bar_date=null;

Under 7.1.3 the above query returns results .. I can insert a date and

then

update it to null, but the query just doesn't work! Everything else seems
to be working as expected.

I haven't seen this mentioned as a bug, did I miss something in the

release