On Wednesday 05 February 2003 02:07, aah at volunteermatch dot org wrote:
Description:
Multiple IS NULL tests in a WHERE clause appear to be broken
when testing NOT NULL date fields. Queries work fine against
varchar and int, probably(?) others.
How-To-Repeat:
Description:
Multiple IS NULL tests in a WHERE clause appear to be broken
when testing NOT NULL date fields. Queries work fine against
varchar and int, probably(?) others.
How-To-Repeat:
create temporary table test (a date not null, b date not null);
insert