same data marked as different in compare

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
webycam
Posts: 8
Joined: Tue 02 Sep 2014 18:07

same data marked as different in compare

Post by webycam » Thu 04 Sep 2014 09:03

although the data are equal, marks them as different.

See Image
http://www.lastplayer.com/error_comp_data.jpg
Image

alexa

Re: same data marked as different in compare

Post by alexa » Thu 04 Sep 2014 11:31

Could you please provide us the CREATE definitions of the tables and let us know what types of data are stored in the columns?

webycam
Posts: 8
Joined: Tue 02 Sep 2014 18:07

Re: same data marked as different in compare

Post by webycam » Thu 04 Sep 2014 15:19

I delete the tables and then created with schemacompare /sync

A double data type


CREATE TABLE qf.historico (
HST_ID int(11) NOT NULL AUTO_INCREMENT,
HST_CODISIN varchar(50) DEFAULT NULL,
HST_Fecha date NOT NULL,
HST_Cierre float(15, 6) DEFAULT NULL,
HST_CodVisualChart varchar(50) DEFAULT NULL,
PRIMARY KEY (HST_ID, HST_Fecha),
INDEX HST_CodISIN (HST_CODISIN),
INDEX HST_CodVisualChart (HST_CodVisualChart),
INDEX HST_Fecha (HST_Fecha),
INDEX `HST_ID,HST_Fecha` (HST_ID, HST_Fecha),
CONSTRAINT historico_ibfk_1 FOREIGN KEY (HST_CODISIN)
REFERENCES qf.fondos (FON_ISIN) ON DELETE CASCADE ON UPDATE CASCADE
)
ENGINE = INNODB
AUTO_INCREMENT = 60226834
AVG_ROW_LENGTH = 67
CHARACTER SET utf8
COLLATE utf8_general_ci;

alexa

Re: same data marked as different in compare

Post by alexa » Fri 05 Sep 2014 12:50

Unfortunately, we were not able to reproduce this issue.

Will it be possible to send us the data specified on the screenshot you provided through exporting data to SQL or CSV format?

You can send a reply straight to our support system at supportATdevartDOTcom, so we will keep further correspondence with you on this issue via e-mail.

alexa

Re: same data marked as different in compare

Post by alexa » Wed 10 Dec 2014 16:27

We would like to let you know that we have released a new version 6.3 of dbForge Studio for MySQL where this issue is fixed http://www.devart.com/dbforge/mysql/stu ... nload.html

Thank you for your help in improving dbForge Studio for MySQL.

Post Reply