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: Steven Staples (sstaplesmnsi.net)
Date: Wed Jun 16 2010 - 08:09:57 CDT

Baron,

Out of curiosity, do you (or anyone else) know what could be an issue with
upgrading to even 5.0.93? or even the 5.1 branch?

There are a lot of stored procedures/functions, as well as the fact that it
is being replicated (the backup server is running multiple instances, and
is replicating 3 other servers). So, all the sql databases will have to
be updated/upgraded, but is there anything I/we should be made aware of
before we go ahead? (there is a lot of release notes to sift through)

Steven Staples

> -----Original Message-----
> From: baron.schwartzgmail.com [mailto:baron.schwartzgmail.com] On Behalf
> Of Baron Schwartz
> Sent: June 15, 2010 4:56 PM
> To: mysqllists.mysql.com
> Subject: Re: Strange GREATEST() result in 5.0.32
>
> 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
> To unsubscribe: http://lists.mysql.com/mysql?unsub=sstaplesmnsi.net
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.829 / Virus Database: 271.1.1/2917 - Release Date: 06/15/10
> 02:35:00

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