MySQL 4.0

[Jason Pyeron]

the gotchas mostly  have to do with sign on numeric operations but also 
have an effect on sorting, etc. v4 has specific operations which are not 
consistent with v3. I am not saying that Bugzilla will have a breakage as a 
result, but with documented incompatibility, we must allow for a migration 
window for those systems where this is an issue, or at least time for the 
product to be mature (according to 80% of the population)

On Tue, 8 Apr 2003, Myk Melez wrote:

Jason Pyeron wrote:

>release 4.0.12 (15 Mar 2003: Production) 
>
>
>I think it should be waited until September 15 before any changes are 
>introduced into bugzilla which would force My-SQL v4 usage.
>
>I know they have had v4 in beta/alpha for a while, but many people have 
>been wary about installing it on their servers, since it was not stamped 
>production. Now that it has been stamped, and many will be using it, let 
>them fix their bugs which will be found. We will be upgrading to it in May 
>if it does not have any major issues on Slashdot, which are not fixed.
>
>remember there are a lot of "gotchas" in v4
>http://www.mysql.com/doc/en/Upgrading-from-3.23.html
>  
>
Are there?  I just read through the list for the second time, and I 
still haven't found anything that looks like it affects Bugzilla.  I do 
agree that more bugs will be found now that it's in production, 
however.  I found one myself the other day after upgrading a b.m.o 
mirror from 3.32.54 to 4.0.12 while leaving b.m.o at 3.23.44:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=4577f265.0303281306.43bd7dff%40posting.google.com&rnum=3&prev=/groups%3Fq%3Dmelez%26hl%3Den%26lr%3D%26ie%3DUTF-8%26scoring%3Dd

In fairness, the MySQL manual does say, "With regard to version 4.0, we 
recommend using same version on both sides," although it isn't clear if 
they are discouraging 3.23.x <-> 4.0.x replication or just 4.0.x <-> 
4.0.y replication.

http://www.mysql.com/doc/en/Replication_Implementation.html

-myk


----
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=jpyeron@pyerotechnics.com>


-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
-                                                               -
- Jason Pyeron                   http://www.pyerotechnics.com   -
- Owner & Lead                  Pyerotechnics Development, Inc. -
- +1 410 808 6646 (c)           500 West University Parkway #1S -
- +1 410 467 2266 (f)           Baltimore, Maryland  21210-3253 -
-                                                               -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

This message is for the designated recipient only and may contain 
privileged, proprietary, or otherwise private information. If you
have received it in error, purge the message from your system and 
notify the sender immediately.  Any other use of the email by you 
is prohibited.