Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 27 Aug 2018 12:52:20 -0700
From:      David Newman <dnewman@networktest.com>
To:        perl@FreeBSD.org
Subject:   p5-DBD-mysql returns bad data to amavisd-new
Message-ID:  <2a8d97fe-fa01-5876-230f-b36283f3e219@networktest.com>

next in thread | raw e-mail | index | archive | help
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=3D130801

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=3D0 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








Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?2a8d97fe-fa01-5876-230f-b36283f3e219>