perl-DBD-MySQL (Fedora 24)

[Dino Edwards]

Also reading through the comments, I wasn't sure if it only affected MySQL and not MariaDB. 


-----Original Message-----
From: amavis-users [mailto:amavis-users-bounces+dino.edwards=mydirectmail.net at amavis.org] On Behalf Of Alan Munday
Sent: Wednesday, January 3, 2018 1:22 PM
To: amavis-users at amavis.org
Subject: Re: perl-DBD-MySQL (Fedora 24)

On 03/01/18 18:15, Dino Edwards wrote:
> Not sure, what's happening there. I can tell you on my end that those fields are float type also. What does your sql_select_policy look like? Mine looks like this:
> 
> $sql_select_policy = 'SELECT *, users.id FROM users,policy'.
> ' WHERE (users.policy_id=policy.id) AND (users.email IN (%k))'; ' 
> ORDER BY users.priority DESC';
> 


I'm still looking at this and it looks like there is a long standing bug in DBD-MySQL.


 From what I've found so far see:


https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=856064

https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=847311

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



What I'm currently searching for is a temporary workaround, a couple of 
things I've tried so far have not worked.

Alan