RE: [PHP-QA] [RFC] Facility for QA reports

Markus Fischer writes: > On Mon, Dec 10, 2001 at 01:02:31PM -0000, Karl Austin wrote : > > >> A given testfile record would be optionally tied to a bug ID. Many > > >> testfile records (and their corresponding tests) are a direct result > > >> of bug-resolution. > > >> > > >> The success/failure of a given testfile record would be tied back to > > >> the bug ID automatically. > > > > > That is what is proposed. The 'bugs' textfield contains a > > > comma-or-whatever separated list of associated bug reprots. > > > > Bad idea, if you want to store multiple values for a single field then > > split the field off into another table rather than having several files > > stored by a deliminator, it's just not good DB design otherwise and it > > will come back and bite you in the ass later. > > I don't know if we can link the real bug DB table together or > not. Having a separate table instead of the list seems > awkward either to me. > > Thanks for your Feedback! > > - Markus > Why not normalize and use a join table? Using the delimited list > method is something I've tried in the past and has never been worth > it. :) My point exactly, it's gonna come back and haunt you if you use a deliminated field to store multiple values. Karl