Changes between Initial Version and Version 1 of Ticket #31388, comment 21
- Timestamp:
- 07/29/2015 08:07:26 AM (10 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #31388, comment 21
initial v1 42 42 Run the following sql to verify, no index is in place after the drop/add index command. 43 43 44 [CREATE TABLE `wp_terms` ( 44 45 {{{ 46 CREATE TABLE `wp_terms` ( 45 47 `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 46 48 `name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', … … 53 55 54 56 55 ALTER TABLE test DROP INDEX slug, ADD INDEX slug(slug(191)); -- <-- FAILS!] 57 ALTER TABLE wp_terms DROP INDEX slug, ADD INDEX slug(slug(191)); -- <-- FAILS! 58 }}} 59