From owner-freebsd-perl@freebsd.org Mon Aug 27 19:52:36 2018 Return-Path: Delivered-To: freebsd-perl@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 7BB3E1094869 for ; Mon, 27 Aug 2018 19:52:36 +0000 (UTC) (envelope-from dnewman@networktest.com) Received: from mailman.ysv.freebsd.org (mailman.ysv.freebsd.org [IPv6:2001:1900:2254:206a::50:5]) by mx1.freebsd.org (Postfix) with ESMTP id 05C6480F37 for ; Mon, 27 Aug 2018 19:52:36 +0000 (UTC) (envelope-from dnewman@networktest.com) Received: by mailman.ysv.freebsd.org (Postfix) id BE4AF1094868; Mon, 27 Aug 2018 19:52:35 +0000 (UTC) Delivered-To: perl@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 9C5831094867 for ; Mon, 27 Aug 2018 19:52:35 +0000 (UTC) (envelope-from dnewman@networktest.com) Received: from mail8.networktest.com (mail8.networktest.com [IPv6:2607:f740:c::a13]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 28C5E80F36 for ; Mon, 27 Aug 2018 19:52:35 +0000 (UTC) (envelope-from dnewman@networktest.com) Received: from mail8.networktest.com (localhost [127.0.0.1]) by mail8.networktest.com (Postfix) with ESMTP id D4B9561803B for ; Mon, 27 Aug 2018 12:52:23 -0700 (PDT) Authentication-Results: mail8.networktest.com (amavisd-new); dkim=pass (1024-bit key) reason="pass (just generated, assumed good)" header.d=networktest.com DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=networktest.com; h=content-transfer-encoding:content-language:content-type :content-type:mime-version:user-agent:date:date:message-id :subject:subject:organization:from:from:to; s=dkim; t= 1535399543; x=1536004344; bh=UEJtqNTbUKYKg77jI326KzfLBRPHR7R9N/G NL5Jz5tQ=; b=RZQq5jrdGcIRP8tXPf2JgW1W7X1fp5Op0d6PLlsJeJmO+mLe4BW +pgycTFBV9mA2JxGOwcHn0MlPGtgno1/XTg4FdxZBdMJugs6mabYFRs5WtynJ5Js BTZe1AZ+7bl/2ABM/e2KYyKgtZAnyaLhiF3/CxCDwQp3ebPA6gbPuVe0= X-Virus-Scanned: amavisd-new at mail8.networktest.com X-Spam-Flag: NO X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=x tagged_above=-100 required=1 WHITELISTED tests=[] autolearn=unavailable Received: from mail8.networktest.com ([127.0.0.1]) by mail8.networktest.com (mail8.networktest.com [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id l_b6ExyVcy_p for ; Mon, 27 Aug 2018 12:52:23 -0700 (PDT) Received: from dhcp129.eng.networktest.com (ns.networktest.com [69.75.159.98]) by mail8.networktest.com (Postfix) with ESMTPSA id 1050A61803A for ; Mon, 27 Aug 2018 12:52:22 -0700 (PDT) To: perl@FreeBSD.org From: David Newman Openpgp: preference=signencrypt Autocrypt: addr=dnewman@networktest.com; prefer-encrypt=mutual; keydata= xsFNBFnmfMEBEACt5x64cZy4FPct3SaH44BMAYkghlJDxI11XpHUJNFAuJ8MD8WgF5F6Nc9C PCl7WzIHAwgWkM2ntAgcOeKvBiFTtzMfiIczfgIAkhiyANYAm3MIH4Li9X0NltYtROQ7FUn+ H4IWZ0SF/BZH1jfoLRNVvuLHdXVYrol/9sGlSI1KTpzpt3GIgeTxdOgTy0nO0HO7c0EBTnRv L3fyYs2E9XgmqsHlFqHBvF1OV0HjVJsqohQxb9iReZEL2UseTZYIYOhKizI3oJOnwPmf7zYg E4jzL422tHbbj4Qwh8l4kZDvy3J+S+KmqFD+IvOUbFBmHZKKB8oFZvLrjd7PLRs0ORSaseqA di0TEUAC3RpmybB1iuukvYhayeLV9afwXWFGNTqrAGCrGPR9umP7OeKGIm6SHrmGnqMlAAz6 qfVITcbhdne2JiqLaZ23B1ezTmJwPPbDGi7G6Yk3Z5pzuZBgq/L1ZyenUBmIcx95C1kVmUtl POJJ3RUNXqJLkjfZhGcmQczR2U0WoOuHVWCmztxa3yhkQETjKhmlIkBV6pj2Bc/mtynVBZg8 XclC6f4Q9bADDOiwO6uDbqI8Bpa1X8YY7iL8QJy2JHACT/j/+mji6Er8c+xU9qkxNmjc3E2a KpCg7gIqnWFj/Ag76AHkPkIo2SO2QINyRMgnFMQeS6j7ij7BOwARAQABzUtEYXZpZCBOZXdt YW4gKERhdmlkIE5ld21hbiBOZXR3b3JrIFRlc3Qgd29yayBrZXkpIDxkbmV3bWFuQG5ldHdv cmt0ZXN0LmNvbT7CwX8EEwEIACkFAlnmfMECGwMFCQeGH4AHCwkIBwMCAQYVCAIJCgsEFgID AQIeAQIXgAAKCRB8vD6mldfDUqfvD/4zARgEeKZqNrJWOK9YMkIah6C6dMohRH0Pz9AkMz9+ 9i9VhdZf2Pv0hq+IEGw+6ISQZL/xiNmq4l6rBioU+AAq98CZq8sh0VLSSeEqYDbo9anvSu2W j1MzhC0BKhlaFPgy08EYZlN2z4pbSvG/ARc0xfTiGlU2jA+iEiMNDbHveGEH1iwAXV3JGA9T bIpe/D5pVO2aemTsePf6+OiATE7M3crqKYZX7WMejqMbOuXzWbeCh/HoDnBBSFDIHR3lQfqR 6jwvb/NogoBioMx6I9vtXvwkqVgp4/jxgkK+I1X4BCdXvC1s3qnJQ9lQT3kFPCJBhQ3qcORv Lvx5svBtp9undPvvp+7SEOBIZDyAfAtSRvBHSv86Y8XnTSrseqk/XtcQbsHs7eVAYcg7F0dR gXFNFUMg67VgacXfyi2GrmkIvA3Zh8h39pZBiTiKfizMhn10gFPhHI6zndR5mYVO5sGUVMVt Mw4f0MDiKHmgFZcs/zcO89OSx3vRwAn5YfBdCagrX1VPYAgGxsfPhnUT8BjmqAFLbHHpb23n HUtfepMIeNaN76/PcxQJUInx/9MfceKL/XGJ8uThM3Ujdv8x6IS7mzEqSbMQTqVVi7loIfP3 qqP87k4Z6G7IMNXKk/Mg84kLTq7YD48pm9S1ME+ghd7wraX2tcbMycuZsrE4XfI8ic7BTQRZ 5nzBARAA9fYZMETrO0l7alXxUVxYxLYVWulKh3GBz9yAeSXSEIJ+q8f0WsDK5zPd6ndBzY2k pT2DJ/ND1NfZJlEo5o27eETQJkpIMV38ZINZz/gVThMIIpCHZeSMW3JveZYEB1xYLFLxeILI ECBAO/h0ASdRz0KYLJldWmuWBUd3tsxhOpK/lZ/s5wbFpstAzsAiw0sm2de4UpNpmGHc1x1j eJH4WBKIAUkZLDXUWEkN1aSVMGWH/2yH87x/J/Mjrj49T+6RwwUohSgOQV3q1XjGjqDq/tpN BPODp32z9GchIvmCU4cRF0uQKpUXtu0fpwnmc1W5M/1aVPQ33vgEFcS/brpWMf7xLIL9EGDp 4/4BukImG4wOx1L3GuKIw5XXNLA9uCriWXr7NSvI00AhXR7m/NbE9ZLIHKfTWssFf9hYnh3p x2n1E+Hy/okqDppfGynHUJjcl5UwP2v6lKO4VO8Gz6wdhl2sYU9pNT6/8Hfp9lnY0BTbFv5Y zZfD77NdCJoDwEd2FUgRzb4vqjwoswci8U73pcOCylbQbAEC5scy/Bd5BOoSIy0kGaQYqumA 3rGXzDn4B02xiYiraNIH28jZPmWzYGM/jncajRFYARZFh/K1OW8Wl3JILAlwZP4VO6ECDj3r qv9EwUv6gxsikXtCT0xjnHL/N5+UQBIQOrx7/TKb80MAEQEAAcLBZQQYAQgADwUCWeZ8wQIb DAUJB4YfgAAKCRB8vD6mldfDUvPlD/4rpb17nhmvSnAy+ShanY2p40M4kgo46Mwmvm3Dmug8 5P+ECRtmhTZ+kEU8Ici/u7FFvE1WHydeNCdE/tOaJ3qXMLBOd4SiB+sa21E0veqR28qUmymI Ti/gFhMpL2Cfa5oPQj5sq/fdEPJzpAoaHfxUMPIUZ7ebM96syazndEFJAFS9MO00/SJ/HcUx 8VMypzqoG+EyBs4c+PThNRyuUH5x8gh4uABILTYIwqUE4HESpRef9ETdJpBkWhsQqxo3Nvoa TLjZH0LNnMyZXOb/aUeQBm0TSGda+on+0BdI70QgI42mu6ovKup32eUhHh7C9scKv8NJYo1Z 4PqRQVIEPznCizZ90aBP1Ia0rJfcADzFNrOQru1WXmm+zXu/TYdESyoL5MRAlitEIs34oeJF X8wMgkHZBFVhvEm60ynH2HZQRLWGIVBnW7oJ2apTx10L2AZWZvLQ6P8pn4eZMPX3+f854d4Q D4yEhE9Ec7CTiqmo6A5+bHGi/yf8VzxMNorlyHCIFZZdfm5vctcg78iUfqsKyvAULpmjLKyA YkX0qv2EnCMUb9urwITWbQTySOVazfjOjRPUO1z5RbfGwCMwNdW8ahf94jtLaVbvVp+7F8dD Y81Qhcbc2MAOWzP1ghr+wsyAyvzVJuDS0kDh6XjpuZddSBEYAh+aI8Kcwqsr75INMg== Organization: Network Test Inc. Subject: p5-DBD-mysql returns bad data to amavisd-new Message-ID: <2a8d97fe-fa01-5876-230f-b36283f3e219@networktest.com> Date: Mon, 27 Aug 2018 12:52:20 -0700 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable X-BeenThere: freebsd-perl@freebsd.org X-Mailman-Version: 2.1.27 Precedence: list List-Id: maintainer of a number of perl-related ports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 27 Aug 2018 19:52:36 -0000 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