Re: RE: MIN/MAX( IF( ...) ) problems: min bigger than max

Richard, Tuesday, August 20, 2002, 9:04:05 PM, you wrote: RU> Is it fixed only in MySQL 4.x, or will it be in the next point RU> release of 3.x as well? No, it wasn't changed in 3.23, only in 4.0.3.. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is

RE: MIN/MAX( IF( ...) ) problems: min bigger than max

Is it fixed only in MySQL 4.x, or will it be in the next point release of 3.x as well? Cheers, Rich > -Original Message- >Thanks for bug report! > >If NULL is present (t_calllog_calls.call_end - >t_calllog_calls.call_start < 5) the result_type is changed from >int to char. > >It was fi

Re: MIN/MAX( IF( ...) ) problems: min bigger than max

Richard, Tuesday, August 06, 2002, 9:05:16 PM, you wrote: RU> Using MySQL 3.2.3.51-nt RU> I think there's something wrong with the way I'm combining the IF and MIN/MAX functions... RU> I'm using aggregate functions of the form MIN( IF( condition, int, NULL ) ), and MAX with the same predicate