Re: aggregate functions producing bad data

[Brian Reichert]

On Tue, Sep 17, 2002 at 11:59:42AM -0700, Richard Unger wrote:
> 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

One thing I'd check:  what happens if t_calllog_calls.id is NULL?

> Cheers,
> Rich

-- 
Brian 'you Bastard' Reichert		<reichert@stripped>
37 Crystal Ave. #303			Daytime number: [phone]
Derry NH 03038-1713 USA			Intel architecture: the left-hand path