List:General Discussion« Previous MessageNext Message »
From:mtoth Date:September 17 2002 8:36pm
Subject:Re: aggregate functions producing bad data
View as plain text  
Is call_end - call_start a integer, maybe the range is to big and it is
eval'd as NULL or false.  shrug.



On Tue, 17 Sep 2002, Gelu Gogancea wrote:

> Hi,
> > One thing I'd check:  what happens if t_calllog_calls.id is NULL?
> ...is not count.
>
> Regards,
>
> Gelu
> _____________________________________________________
> G.NET SOFTWARE COMPANY
>
> Permanent e-mail address : gg@stripped
>                                           gelugogancea@stripped
> ----- Original Message -----
> From: "Brian Reichert" <reichert@stripped>
> To: "Richard Unger" <runger@stripped>
> Cc: <mysql@stripped>
> Sent: Tuesday, September 17, 2002 10:16 PM
> 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
> >
> >
> > > 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
> >
> > ---------------------------------------------------------------------
> > 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-thread119849@stripped>
> > To unsubscribe, e-mail
> <mysql-unsubscribe-ggelu=arctic.ro@stripped>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
> ---------------------------------------------------------------------
> 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-thread119859@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-mtoth=queldor.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

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