.deb upgrade from mysql to mariadb fails due to apt-get considering it a downgrade

Description

On Debian wheezy upgrade from mysql->mariadb fails like this:

The root cause is this:

I believe the problem is that apt-get considers 5.5.28+dfsg-1 a newer version
than 5.5.28-mariadb1~wheezy, and it will by default not do a downgrade to
satisfy a dependency.

A work-around is to ask for the "downgrade" explicitly:

This problem becomes more of an issue due to Oracle keeping security patches
secrect. This forces distros to upgrade to latest upstream version in released
distros, which means we will more often get a newer mysql version on top of an
earlier mariadb version, causing this issue.

One fix may be to re-write the -mariadb1~wheezy suffix to something that
apt-get considers newer than +dfsg-1, then apt-get will automatically install
the replacement package as it does not consider it a downgrade.

This however does not help if the distro introduces eg. mysql 5.5.30 while the
mariadb repositories still have only 5.5.29 - then it will still be considered
a downgrade.

Environment

None

Assignee

Kristian Nielsen

Reporter

Kristian Nielsen

Labels

Time tracking

8h

Fix versions

Affects versions

Priority

Critical
Configure