perl-DBD-MySQL (Fedora 24)

[Dino Edwards]

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';




-----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 11:11 AM
To: amavis-users at amavis.org
Subject: Re: perl-DBD-MySQL (Fedora 24)



 From this question I've been able to do some more testing and can see what is going on.


Running the same query from on Fedora 26 (using perl-DBD-MySQL-4.037)  I 
can see it retrieve all the set values from the policy table correctly.



On Fedora 27 (using perl-DBD-MySQL-4.043) the query returns all the set 
values from the policy table except those of type float. I.e.

spam_tag_level=>"0",
spam_tag2_level=>"0",
spam_tag3_level=>"0",
spam_kill_level=>"0",
spam_dsn_cutoff_level=>"0",
spam_quarantine_cutoff_level=>"0",


I've been through the release notes and the SQL readme files and I can't 
see a change for these fields.

Did I miss something?

Alan