Red Gate forums :: View topic - won't compare some columns
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
MySQL Data Compare
MySQL Data Compare forum

won't compare some columns

Search in MySQL Data Compare forum
Post new topic   Reply to topic
Jump to:  
Author Message
jlu



Joined: 25 Jan 2012
Posts: 3

PostPosted: Wed Jan 25, 2012 4:12 pm    Post subject: won't compare some columns Reply with quote

Hi there, I have the same issue as someone previous reported:

some column when i compare with MySqlCompare they show has identical, but when i try to sync the data, it refuse to compare some varchar field marked with a yellow (!) sign w/o any other indications.


I did not see any solution from the previous response, so how can I work around this issue????
Back to top
View user's profile Send private message
neil.anderson



Joined: 28 Sep 2010
Posts: 64

PostPosted: Thu Jan 26, 2012 9:53 am    Post subject: Reply with quote

Hi jlu,

The previous reporter of the issue and I were not able to recreate the problem. Can you send us the schema of the tables you are comparing and the versions of the instances of MySQL please?

You can post the info here or send it to mysql@red-gate.com

Thanks for your report,
Neil
Back to top
View user's profile Send private message
jlu



Joined: 25 Jan 2012
Posts: 3

PostPosted: Thu Jan 26, 2012 1:34 pm    Post subject: Reply with quote

Hi Neil,

This is what is being shown from MySQL Compare in both the left (v5.5 DB instance) and right (v5.1 DB instance) side of the screen, they are identical:

CREATE TABLE `ALERT_Engines` (
`id` int(11) unsigned NOT NULL auto_increment,
`name` varchar(256) NOT NULL,
`ALERT_Engines_Categories_id` int(11) NOT NULL,
`alert_title` text NOT NULL,
`alert_title_commercial` text NOT NULL,
`commercial_only` int(11) NOT NULL DEFAULT '0',
`alert_display` tinyint(4) NOT NULL,
`alert_display_order` int(11) NOT NULL,
`alert_description` text NOT NULL,
`alert_description_commercial` text NOT NULL,
`requires_channels` tinyint(4) NOT NULL DEFAULT 0,
`type` varchar(50) NOT NULL,
`admin` tinyint(1) NOT NULL,
`all_users` tinyint(4) NOT NULL DEFAULT 0,
`defaultstate` int(11) NOT NULL,
`sleeplength` int(10) NOT NULL,
`sendfrequency` int(10) NOT NULL,
`lurk` tinyint(1) NOT NULL,
`enabled` tinyint(4) NOT NULL DEFAULT 1,
`offset` int(3) NOT NULL DEFAULT '0' COMMENT 'in days',
`uses_appliance_table` tinyint(2) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 row_format=COMPACT AUTO_INCREMENT=27


From MySQL Data Compare, under the tables tab, in the row "ALERT_Engines" the right column "Columns in Comparison" has "19 of 23 columns". When I click it, there are four ! marks in yellow triangle, it looks like:

[code]
Int offset !
TinyInt uses_appliance_table !
! offset Int
! uses_appliance_table TinyInt
[/code]


j[/img]
Back to top
View user's profile Send private message
jlu



Joined: 25 Jan 2012
Posts: 3

PostPosted: Thu Jan 26, 2012 1:43 pm    Post subject: Reply with quote

I am not sure if that matters, the offset and uses_appliance_table columns were added after the creation of the tables. IE, when I first run MySQL Compare 1 and MySQL Data Compare 1 on this table, these columns didn't exist. After the columns were added, I re-ran MySQL Compare 1 and it showed identical schema, but when I re-ran MySQL Data Compare 1, I cannot compare the new columns.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group