OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Strange GREATEST() result in 5.0.32

From: Baron Schwartz (baronxaprb.com)
Date: Tue Jun 15 2010 - 15:56:23 CDT


Steven,

On Tue, Jun 1, 2010 at 11:15 AM, Steven Staples <sstaplesmnsi.net> wrote:
> Hello all
>
> I have a stored procedure that probably does a lot more than it should, but
> it works fine on my test server (which is running 5.0.67).   When I moved it
> over to the production server, (which is running 5.0.32 and I never thought
> to check that the versions were the same before) it works almost perfectly.

It sounds like you're running into a bug, simply put. 5.0.32 is very
old and an amazing amount of bugs have been fixed since then. I would
not even consider running it in production. I know it'll be tough to
upgrade, but if you don't, my experience is that another of the
unfixed bugs is going to cause you serious pain anyway, such as
crashing your server.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql