Hi,
I think you should try to use 0 instead of NULL
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : gg@stripped
gelugogancea@stripped
----- Original Message -----
From: "Richard Unger" <runger@stripped>
To: <mysql@stripped>
Sent: Tuesday, September 17, 2002 9:59 PM
Subject: aggregate functions producing bad data
My query:
SELECT
count(id),
count( IF(call_end - call_start > 5, id, NULL) ),
count( IF(call_end - call_start <= 5, id, NULL) )
FROM
t_calllog_calls;
My result:
1994
1956
35
However, 1956 + 35 != 1994.
Running MySQL 3.23.49-nt
Cheers,
Rich
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <mysql-thread119848@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-ggelu=arctic.ro@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
