[request-tracker-maintainers] Bug#986707: rt4-db-mysql: should declare an incompatibility with mysql 8

[Ángel]

On 2023-08-19 at 15:52 +1200, Andrew Ruthven wrote:
> Perhaps we should explicitly depend on the mariadb packages. Thinking
> about this is a bit further, this does seem the best option.

I was initially thinking on changing the dependency from virtual-mysql-
server to mariadb-server | mysql-server << 8.0, but the mysql package name is versioned (mysql-server-8.0), so that would be equivalent to what you mention.

However, this won't work, since this is a suggests, not a depends. With
good reason, since the database server doesn't need to (and on
production systems it usually won't) be in the same machine as the web
server.

Which also means the remote db server may get upgraded to MySQL 8
despite a conflicts.

I think the proper solution would be to backport
https://github.com/bestpractical/rt/commit/573f3353394ea3a8b90493a249a8ab8e15af5bb1

it appears somewhat big (16 files changed, 84 insertions, 31
deletions), but it's just a bunch of trivial changes to ensure the name
of the table Groups gets quoted in MySQL 8 (MySQL 8 made Groups a
reserved keyword).

The patch applies cleanly on top of rt-4.4.6 and it should just work™

Regards