#89169Redirects indey key too long after source path increase
Description
Due to #88336 redirect URLs can now be longer. However, this also affects the index_source index which includes source_host and source_path which now easily extends regular index limits:
$ typo3cms d:u -vvv No schema updates were performed for update types: "field.add", "field.change", "table.add", "table.change" The following errors occurred: +---------------+-------------------------------------------------+-----------------------------+ | Type | SQL Statement | Message | +---------------+-------------------------------------------------+-----------------------------+ | Change fields | ALTER TABLE `sys_redirect` CHANGE `source_path` | Specified key was too long; | | | `source_path` VARCHAR(2048) DEFAULT '' NOT NULL | max key length is 3072 | | | | bytes | | | | | +---------------+-------------------------------------------------+-----------------------------+
The collation is utf_general_ci for the mentioned fields and table.
After manually dropping the index_source index the change can be applied however:
$ typo3cms d:u -vvv The following database schema updates were performed: +---------------+-------------------------------------------------+ | Type | SQL Statements | +---------------+-------------------------------------------------+ | Add fields | CREATE INDEX `index_source` ON `sys_redirect` | | | (source_host(80), source_path(80)) | | Change fields | ALTER TABLE `sys_redirect` CHANGE `source_path` | | | `source_path` VARCHAR(2048) DEFAULT '' NOT NULL | +---------------+-------------------------------------------------+