mysqldump, indexes, and checksetup

[David Miller]

Shane H. W. Travis wrote:
> So I'm running checksetup from 2.18rc3 on our 2.16.7 database, and it seems
> to be balking at one point; it isn't properly clearing away the index
> 'product' from 'milestones' because it can't find an index of that name.

Someone else reported this in Bugzilla a while back and it got resolved 
WORKSFORME because nobody could reproduce it, and checksetup.pl has 
never in the entire history of Bugzilla ever created a primary key on 
that table.

If it's a defect in mysqldump, that would explain a lot.  If you can 
track sown said bug, let's reopen it.  We probably need to make 
checksetup.pl examine the current indexes and be prepared to drop either 
one, depending on which it ended up with.

-- 
Dave Miller      Project Leader, Bugzilla Bug Tracking System
http://www.justdave.net/             http://www.bugzilla.org/