subject:"HAVING Max\(x\) IS NULL always TRUE."

Re: HAVING Max(x) IS NULL always TRUE.

2002-08-15 Thread Mikhail Entaltsev

GROUP BY t1.id HAVING MaxData IS NULL; Mikhail. - Original Message - From: "Oleh Khoma" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 14, 2002 10:09 PM Subject: HAVING Max(x) IS NULL always TRUE. > >Description: > HAVING Max(x) IS

HAVING Max(x) IS NULL always TRUE.

2002-08-14 Thread Oleh Khoma

>Description: HAVING Max(x) IS NULL always TRUE. This has changed since 3.23.39, when if the x column had all Nulls, Max(x) IS NULL was TRUE and FALSE otherwise. >How-To-Repeat: CREATE TABLE test1 ( ID int unsigned auto_increment not null p