Re: Upgrading from 7.2.3 to....??

>>>>> "CM" == Carlos Moreno <moreno@mochima.com> writes:

CM> What would be your advice?  Is 7.3.4 the recommended one
CM> if we need reliability?  Or has 7.4 earned sufficient
CM> trust by now?

CM> Also, how about back compatibility?  Should I expect some
CM> trouble?  I remember with one of the previous upgrades

I just did that switch from 7.2 over to 7.4 this past weekend.  It
went very smoothly.  The major things to watch for that I found in the
history/release notes which were not very obvious were:

1) implicit converstion of empty string to numeric 0 is no longer
   there.  be sure you either specify numeric 0 or string '0' when you
   mean that.

2) if you have default 'NOW()' (in quotes!) you have to change that to
   default NOW() without quotes.  Similar for other date/time default
   thingies.

3) 7.2 used to nicely order your group by's implicitly.  this is no
   longer the case -- you must explicitly list any ordering you wish
   imposed on group by's.

I think that was it.  The speed seems to be faster, but that could
also be due to moving from a 4-disk RAID10 to a 14 disk RAID5 with
faster spindles ;-)

This is running my production site which does a *lot* of
inserts/updates daily.  I'm very happy with it.  You will be to :-)


--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/