List:General Discussion« Previous MessageNext Message »
From:Gerben Gieling Date:September 18 2002 8:55am
Subject:RE: aggregate functions producing bad data
View as plain text  
Perhaps you should create a new table with an id column and a flag
column.
Select the found calls > 5 or <= 5 into that new table and set the flag.
Then do a left join of your t_callog_calls table on the new table
selecting only the rows where the flag is NULL, these should be the rows
not found by either query.
Inspect the data in these rows manually to determine what is wrong.

> -----Original Message-----
> From: Richard Unger [mailto:runger@stripped] 
> Sent: September 17, 2002 21:00
> To: mysql@stripped
> 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
> 
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