[Bug 231250] possible data type bug in security/amavisd-new

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=231250

            Bug ID: 231250
           Summary: possible data type bug in security/amavisd-new
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: flo at FreeBSD.org
          Reporter: dnewman at networktest.com
          Assignee: flo at FreeBSD.org
             Flags: maintainer-feedback?(flo at FreeBSD.org)

FreeBSD-11.2-p2, amavisd-new-2.11.0_3,1, p5-DBD-mysql-4.046 (also 4.037),
mysql57-server-5.7.23_1

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.

-- 
You are receiving this mail because:
You are the assignee for the bug.