Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Importexternaldata: Double-field-errror

forums forums SQLyog Sync tools, Migration, Scheduled Backup and Notifications Importexternaldata: Double-field-errror

Tagged: ,

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #13283
      kheine
      Member

      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.

       

       

       

       

    • #35105
      peterlaursen
      Participant

      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

    • #35106
      kheine
      Member

      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

Viewing 2 reply threads
  • You must be logged in to reply to this topic.