<HTML ><HEAD ><TITLE >Database Integrity</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.61 "><LINK REL="HOME" TITLE="The Bugzilla Guide" HREF="index.html"><LINK REL="UP" TITLE="The Future of Bugzilla" HREF="future.html"><LINK REL="PREVIOUS" TITLE="Bug Issues" HREF="bugprobs.html"><LINK REL="NEXT" TITLE="Bugzilla 3.0" HREF="bz30.html"></HEAD ><BODY CLASS="SECTION" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >The Bugzilla Guide</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="bugprobs.html" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" >Chapter 6. The Future of Bugzilla</TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="bz30.html" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECTION" ><H1 CLASS="SECTION" ><A NAME="DBASEINTEGRITY" >6.5. Database Integrity</A ></H1 ><P ><P CLASS="LITERALLAYOUT" >Bugzilla could be more proactive in detecting suboptimal situations and<br> prevent them or whine about them.<br> <br> 1. Bugzilla Crime #1: Marking A Bug Fixed With Unresolved Dependencies<br> <br> It can't be marked fixed with unresolved dependencies. Either mark it<br> INVALID (tracking bugs), fix the dependencies at the same time, or<br> resolve the blockers.<br> <br> See "http://bugzilla.mozilla.org/show_bug.cgi?id=24496".<br> <br> 2. Keyword Restrictions<br> <br> Some keywords should only apply in certain circumstances, eg beta1 =><br> Milestone <<br> M14, css1 => Component = Style System are possibilities. See<br> "http://bugzilla.mozilla.org/show_bug.cgi?id=26940".<br> <br> 3. Whine About Old Votes<br> <br> Old votes can just sit on resolved bugs. This is problematic with<br> duplicates especially. Automatic transferral/removal is not<br> appropriate since bugs can be reopened, but a whining solution might<br> work. See "http://bugzilla.mozilla.org/show_bug.cgi?id=27553".<br> <br> 4. Whine And Warn About Milestone Mismatches<br> <br> Here's a fun one. Bug X (M17) depends on Bug Y (M15). Bug Y gets moved<br> out to M19. The notification to the assignee of Bug X gets ignored (of<br> course) and Bug X is now due to be fixed before one of its blockers.<br> <br> Warnings about this when it is detected as well as whining about it in<br> email would help bring these issues to the attention of people sooner.<br> <br> Note that this would be less of a problem if we didn't have so many<br> tracking bugs since they aren't updated that often and often have this<br> problem.<br> <br> See "http://bugzilla.mozilla.org/show_bug.cgi?id=16743".</P ></P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="bugprobs.html" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="bz30.html" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Bug Issues</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="future.html" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Bugzilla 3.0</TD ></TR ></TABLE ></DIV ></BODY ></HTML >