Changes between Initial Version and Version 1 of Ticket #31335, comment 2


Ignore:
Timestamp:
Mar 3, 2020, 9:31:50 AM (5 years ago)
Author:
Simon Charette

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #31335, comment 2

    initial v1  
    1 Looks like MySQL will be ''smart'' enough to silently drop the index on `article_id` when `comment_list_covering_idx` is created but decides to do otherwise when the latter is dropped.
     1Looks like MySQL will be ''smart'' enough to silently drop the index on `article_id` when `comment_list_covering_idx` is created but not ''smart'' enough to create an implicit index when the explicit one is dropped.
    22
    33From [https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html MySQL's docs]
Back to Top