List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 19 1999 9:28pm
Subject:Re: SUM() changed in 3.23?
View as plain text  
At 4:16 PM -0500 7/19/99, Sasha Pachev wrote:
>Scott Hess wrote:
>>
>> Sasha Pachev <sasha@stripped> wrote:
>> > Balint TOTH wrote:
>> > > Is it OK if sum(field) returns NULL if the table has no records? Older
>> > > versions (like 3.22.22) returned 0.
>> >
>> > This is more logical, I think. If this is not what you want, you can do
>> > ifnull(sum(field), 0)
>>
>> Except insofar as it breaks existing code!  Just this weekend this became a
>> problem as I tested against 3.22.23 (we were using 3.22.15).
>>
>> Is this how SUM() is supposed to work?  When I described the problem at the
>> office, my colleagues were pretty much amazed that this happened, and think
>> it must be a bug.  If it's considered a feature, I need to send some emails
>> around...
>>
>> Later,
>> scott
>
>If you have too much code that depends on this, and you cannot just
>change it in the code, you can change a couple of lines in the sources
>of mysql and recompile.

Where?  Which file?  What lines?

--
Paul DuBois, paul@stripped
Thread
SUM() changed in 3.23?Balint TOTH19 Jul
  • Re: SUM() changed in 3.23?Sasha Pachev19 Jul
  • Re: SUM() changed in 3.23?Scott Hess20 Jul
  • Re: SUM() changed in 3.23?Sasha Pachev20 Jul
    • Re: SUM() changed in 3.23?Paul DuBois20 Jul
  • Re: SUM() changed in 3.23?Sasha Pachev20 Jul
    • Re: SUM() changed in 3.23?Michael Widenius30 Jul