p5-DBD-mysql returns bad data to amavisd-new

[David Newman]

Greetings. You are receiving this email as the listed maintainer for the
p5-DBD-mysql pkg/port on FreeBSD.

I've got a situation with a production mail server where versions of
p5-DBD-mysql after 4.037 return incorrect values to the amavisd-new
pkg/port after a MySQL query.

This issue was previously reported on, and fixed, and then reverted in
4.043:

https://github.com/perl5-dbi/DBD-mysql/issues/78

https://lists.amavis.org/pipermail/amavis-users/2016-December/004674.html

That was more than a year ago, and the type-conversion bug is still
present in 4.046, the current release. And it's marked as solved in the
Perl bug tracker:

https://rt.perl.org/Public/Bug/Display.html?id=130801

As for my particular issue, I've posted configuration files and a debug
log here:

https://pastebin.com/9htv3r5D

Note in particular the tagged_above=0 value in the debug log, when the
expected result (and the one correctly returned in the MySQL client) is
6.0.

It's still broken in that the current of p5-DBD-mysql still returns bad
data. Is there a timeline for a fix?

Alternatively, can you advise on a patch for this one issue? I
understand that the 4.043 reversion changed many other things.

Many thanks.

Regards,
David Newman