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.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf > Of Baron Schwartz > Sent: June 15, 2010 4:56 PM > To: mysql@lists.mysql.com > Subject: Re: Strange GREATEST() result in 5.0.32 > > Steven, > > On Tue, Jun 1, 2010 at 11:15 AM, Steven Staples <sstap...@mnsi.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=sstap...@mnsi.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 To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org