[wp-trac] [WordPress Trac] #15644: When deleting a user, corresponding comment user IDs aren't reset

[WordPress Trac]

#15644: When deleting a user, corresponding comment user IDs aren't reset
--------------------------+-----------------------------
 Reporter:  nacin         |       Owner:
     Type:  defect (bug)  |      Status:  closed
 Priority:  lowest        |   Milestone:  Future Release
Component:  Comments      |     Version:
 Severity:  minor         |  Resolution:  invalid
 Keywords:                |     Focuses:
--------------------------+-----------------------------
Changes (by chriscct7):

 * keywords:  2nd-opinion has-patch =>
 * status:  new => closed
 * resolution:   => invalid


Comment:

 Given the user_id column is an autoincrementing index, the user would
 manually (as pointed out by nacin) need to run an ALTER TABLE. As such,
 the collision possibility is only limited to where the auto incrementing
 index is intentionally set below the highest user id's user_id, and
 therefore there isn't a chance for collision during normal operation

--
Ticket URL: <https://core.trac.wordpress.org/ticket/15644#comment:11>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform