What are the challenges you face when working across database platforms? Take the survey
Options

MySQL Compare 1.0.0.666 doesn't recognise UNIQUE KEY column

maxitonemaxitone Posts: 2
edited March 19, 2016 8:32AM in MySQL Compare
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:
Capture.PNG

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
Sign In or Register to comment.