List:General Discussion« Previous MessageNext Message »
From:Richard Unger Date:September 17 2002 7:24pm
Subject:RE: aggregate functions producing bad data
View as plain text  
id is the primary key.  There are no entries in the DB where id=NULL

Cheers,
Rich

> -----Original Message-----
> From: Brian Reichert [mailto:reichert@stripped]
> Sent: Tuesday, September 17, 2002 12:16 PM
> To: Richard Unger
> Cc: mysql@stripped
> Subject: Re: aggregate functions producing bad data
> 
> 
> 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: (603) 434-6842
> Derry NH 03038-1713 USA			Intel 
> architecture: the left-hand path
> 
Thread
aggregate functions producing bad dataRichard Unger17 Sep
  • Re: aggregate functions producing bad dataBrian Reichert17 Sep
    • Re: aggregate functions producing bad dataDan Nelson17 Sep
  • Re: aggregate functions producing bad dataGelu Gogancea17 Sep
  • Re: aggregate functions producing bad dataGelu Gogancea17 Sep
    • Re: aggregate functions producing bad datamtoth18 Sep
  • Re: aggregate functions producing bad dataGelu Gogancea17 Sep
RE: aggregate functions producing bad dataRichard Unger17 Sep
RE: aggregate functions producing bad dataRichard Unger17 Sep
  • RE: aggregate functions producing bad datamtoth17 Sep
RE: aggregate functions producing bad dataRichard Unger17 Sep
  • Re: aggregate functions producing bad dataJay17 Sep
    • re: Re: aggregate functions producing bad dataVictoria Reznichenko18 Sep
RE: aggregate functions producing bad dataRichard Unger17 Sep
RE: aggregate functions producing bad dataRichard Unger17 Sep
  • Re: aggregate functions producing bad dataBenjamin Pflugmann18 Sep
RE: aggregate functions producing bad dataGerben Gieling18 Sep