Importexternaldata: Double-field-errror

[kheine]

We work with SQLyog Ultimate 12.02 64bit.

In an ImportExternalData-Job we transfer data of an table between two Mysql-Servers in an incremental way.

All is done well until there is an double-field with an value like 2.5999999999:  Then the transfer is o.k., but neither

the trigger option ‘update source row’ nor the option ‘delete source row’ is being processed.

When we change the value to 2.59  or change the datatype to numeric(10,2), the trigger works fine.

 

 

 

 

[peterlaursen]

We will check after the weekend.

 

To make it easier for us can you provide CREATE statement for the affected table (execute “SHOW CREATE TABLE tablename;” It may matter if there is PRIMARY KEY or UNIQUE KEY on the column.  You should never have on FLOAT and DOUBLE columns in MySQL – please refer http://faq.webyog.com/content/29/162/en/tables-with-floating-point-datatypes-fail-to-update.html

[kheine]

Thanks for your help.  😀

 

In the SQLyog FAQ there is this hint:

 

‘When using Floating Point datatypes there should always be a PK based on non-floating column(s) and the PK-column(s) should be included in every SELECT generating a result set used for updating the table.’

 

Taking the index-field into my SELECT, the incremental transfer works fine.

 

Your SQLyog: an excellent tool !

 

Best regards

K.Heine

[Author]

Posts