Data typing issue with perl doubles and floats
(Previously filed FreeBSD bug 231250 against this)
amavisd-new-2.11.0_2,1, spamassassin-3.4.1_12, mysql57-server-5.7.23, iRedMail 0.9.8, iRedAdmin-Pro 2.4.0, FreeBSD 11.2-RELEASE-p4
When using p5-DBD-mysql releases after 4.037, amavisd-new creates false positives and erroneously adds a "tagged_above=0" label to message headers.
This is due to a change in p5-DBD-mysql-4.038 and later releases so that p5-DBD-mysql "now returns mysql doubles as perl doubles and mysql floats as perl floats (and not as a string anymore)."
Due to this change in data types, the p5-DBD-mysql client obtains erroneous '0' results from queries. The MySQL client obtains the correct values.
This thread describes the problem in more detail and includes a link with configuration files and debug logs:
https://lists.amavis.org/pipermail/amavis-users/2018-August/005399.html
The changelog for p5-DBD-mysql describes the changes instituted with its 4.038 release:
https://fastapi.metacpan.org/source/CAPTTOFU/DBD-mysql-4.046/Changes
Please let me know if you need further info.