won't compare some columns

jlu

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????

neil.anderson

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

jlu

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:

Int         offset                        !
TinyInt   uses_appliance_table  !
                                             !   offset                        Int
                                             !   uses_appliance_table TinyInt

j[/img]

jlu

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.