Saturday, 19 March 2016

MySQL Compare doesn't recognise UNIQUE KEY column lengths

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))
MySQL compare doesn't recognise the UNIQUE KEY column length.

Which results in:


  • 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

No comments: