MySQL Compare 1.0.0.666 doesn't recognise UNIQUE KEY column

maxitone

I have a Joomla! table:

CREATE TABLE `jos_messages_cfg` (
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cfg_name` text NOT NULL,
  `cfg_value` text NOT NULL,
  UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`(100))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

MySQL compare doesn't recognise the UNIQUE KEY column length.

Which results in:


Thoughts:

• It should pick up the UNIQUE KEY correctly
• It's a shame it's not possible to copy the error from this error dialog
• Errors do NOT result in an option of a re-compare