Showing entries 1 to 1
Displaying posts with tag: Annoyance (reset)
Nov
12
2021
Duplicate Entry in ALTER TABLE (and in OPTIMIZE TABLE)
Posted by Jean-François Gagné on Fri 12 Nov 2021 06:00 UTC
Tags:

A few weeks ago and in MySQL 5.7, I had an ALTER TABLE that failed with a duplicate entry error.  This is old news as it is happening since MySQL 5.6, but I only saw this recently because I am normally using online schema change from the Percona Toolkit (pt-osc) or GitHub's online schema migration (gh-ost).  I do not like that and I am disappointed this has not been improved, so this

Showing entries 1 to 1