92101 - Referential integrity not maintained when deleting bugs

Status: RESOLVED DUPLICATE of bug 86328

(Bugzilla :: Administration, task, P3)

Description

[Jason Lee]

Bugzilla does not seem to maintain referential integrity in the database when
the "delete bugs" paramater is enabled.  I close a prodcut for bug entry, and
delete the product (along with its bugs).  However, the text descriptions and
keyword entries in tables bugs.longdescs and bugs.keywords pertaining to those
bugs are not removed, leading to a deletion anomaly in the database.  We can see
this problem if we run a sanity check.

I think the solution may be to add the ON DELETE CASCADE subclause to
checksetup.pl in order to have deletions cascade into tables that use the
deleted bug's bug_id as a foreign key.

Comment 1

[Matthew Tuck [:CodeMachine]]

Hmm isn't that referential integrity stuff, I don't think that's supported by
MySQL.  I think I remember seeing something in the docs about a half an hour ago
complaining about cascaded deletes and saying they were a bad thing because of
the potential for data loss.

But anyway, we would have to deal with lots of tables: attachments,
bugs_activity, cc, dependencies, duplicates, keywords, longdescs & votes.

Not sure which we're currently doing.

Comment 2

[Matthew Tuck [:CodeMachine]]

*** This bug has been marked as a duplicate of 86328 ***

Comment 3

[Dave Miller [:justdave]]

clearing milestone for invalid/wontfix/worksforme/duplicate so they'll show up
as untriaged if they get reopened.