re: IS NULL problem with dates; confirmed on 3.23.x 4.09

2003-02-09 Thread Victoria Reznichenko
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:

IS NULL problem with dates; confirmed on 3.23.x 4.09

2003-02-05 Thread aah
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