Re: Cannot upgrade p5-DBD-mysql with Mariadb

On Sat, 23 Mar 2024, Horatiu Moldovan wrote:

> On 23/03/2024 10:12, Kurt Jaeger wrote:
>> Hi!
>> 
>>> Seems that an upstream change broke compatibility between
>>> databases/p5-DBD-mysql and MariaDB :
>>> 
>>>> DBD::mysql requires MySQL 8.x for building. Version reported by
>>>> mysql_config --version: 10.5.23 at ./Makefile.PL line 451, <PIPE> line
>>>> 3.
>>> Since I use MariaDB, I don't want to install mysql80-client
>> Use databases/p5-DBD-MariaDB.
>> 
>
> It gets a little more complicated than explicitly using p5-DBD-MariaDB,
> as all the ports listing p5-DBD-mysql as a dependency will fail to build
> - in my case mail/opendmarc, security/amavisd-new, mail/spamassassin,
> databases/mytop...

It also handles Unicode drastically differently -- more "correctly", yes, 
but incompatibly with some existing stuff, including security/amavisd-new, 
so it can require some code changes to mark binary fields as binary so 
they aren't treated as malformed UTF-8 instead.

Perl somewhat randomly dumps core when I try to use DBD::MariaDB with
DBIx::Connector.  I ended up going back to DBD::mysql for it.

It's not quite ready as a drop-in replacement.