Which version to upgrade to for Bugzilla's MySQL server?

[Benton, Kevin]

> > My Bugzilla is using an old version of MySQL ("Ver 3.23.51 for
> > pc-linux-gnu on i686"), so I am going to upgrade it.
> 
> > I see that MySQL 5.0 has been out for a few months now.  What are
> > people's experiences with it?  Has it been field tested enough to be
> > found reliable for use?  Or should I go instead to the last release
of
> > in the MySQL 4 line?
> 
> AFAIK, prior to 2.20 of Bugzilla aren't tested very well using MySQL
5.
> 2.22 will be much well tested though.

You're right that Bugzilla flat-out doesn't work at all with MySQL
5.0.12 and higher prior to Bugzilla 2.20rc1.  This is due to a
significant change in query requirements from MySQL (making it more ANSI
compliant).  MySQL doesn't allow SELECT a, b FROM t1, t2 LEFT JOIN t3
... because it's ambiguous (which table should MySQL join t3 to, t1, or
t2?).  In Bugzilla 2.20, code was updated to make it work with PgSQL and
some of these issues were resolved without making specific attempts at
becoming MySQL 5.x compliant.  2.20 was released prior to MySQL 5, so
testing against MySQL 5 was not wise (it was still in development).

There may be other reasons, but your best bet is to go with at least
Bugzilla 2.20 (release).  If you choose to wait for 2.22, we're
expecting to enter the release candidate process for 2.22 soon.