Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-24599

non-unique long key isn't truncated

    XMLWordPrintable

    Details

      Description

      CREATE TABLE IF NOT EXISTS `pds_core_menu_items` (
        `menu_id` varchar(32) NOT NULL,
        `parent_menu_id` int(32) unsigned DEFAULT NULL,
        `menu_name` varchar(255) DEFAULT NULL,
        `menu_link` varchar(255) DEFAULT NULL,
        `plugin` varchar(255) DEFAULT NULL,
        `menu_type` int(1) DEFAULT NULL,
        `extend` varchar(255) DEFAULT NULL,
        `new_window` int(1) DEFAULT NULL,
        `rank` int(100) DEFAULT NULL,
        `hide` int(1) DEFAULT NULL,
        `template_id` int(32) unsigned DEFAULT NULL,
        `alias` varchar(255) DEFAULT NULL,
        `layout` varchar(255) DEFAULT NULL,
        PRIMARY KEY (`menu_id`),
        KEY `index` (`parent_menu_id`,`menu_link`,`plugin`,`alias`)
      ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
      

      ERROR 1071 Specified key was too long; max key length is 1000 bytes
      

        Attachments

          Activity

            People

            Assignee:
            sanja Oleksandr Byelkin
            Reporter:
            serg Sergei Golubchik
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration