Serious error in update Mysql 4.1.7

[Luciano Pulvirenti]

I am trying Mysql 4.1.7 before putting it in production in 4.0.16 
substitution on Windows NT.
I have found an anomaly for me serious.
I use Visual Basic 6 with ADO last version and the driver MYODBC 3.51.10.
The program produces the following query:

UPDATE `paghe`.`anagpaghe`
SET `giorni_congedo_mp`=1.25000000000000000e+001,
`giorni_congedo_anno_prec_mp`=0.00000000000000000e+000,
`giorni_permessi_retrib_mp`=2.00000000000000000e+000,
`giorni_congedo`=1.15000000000000000e+001,
`giorni_congedo_anno_prec`=0.00000000000000000e+000,
`giorni_permessi_retribuiti`=2.00000000000000000e+000,
`swnuovo`=0
WHERE `matricola`=43258
AND `giorni_congedo_mp`=1.25000000000000000e+001
AND `giorni_congedo_anno_prec_mp`=0.00000000000000000e+000
AND `giorni_permessi_retrib_mp`=2.00000000000000000e+000
AND `giorni_congedo`=1.15000000000000000e+001
AND `giorni_congedo_anno_prec`=0.00000000000000000e+000
AND `giorni_permessi_retribuiti`=2.00000000000000000e+000
AND `swnuovo`=1


Mysql doesn't succeed to update the record because no succeeds in finding 
the record corresponding to the syntax WHERE.
I have made some tests have discover that the cause is

AND `giorni_congedo`=1.15000000000000000e+001

In the version 4.0.16 work correctly.
The fields "giorni..." have declared in the structure double(5,1).
Thank you 



-- 
Internal Virus Database is out-of-date.
Checked by AVG Anti-Virus.
Version: 7.0.290 / Virus Database: 265.4.3 - Release Date: 26/11/2004