Bug ID domain?

Bradley Baetz bbaetz at acm.org
Fri Apr 25 08:00:19 UTC 2003


On Fri, Apr 25, 2003 at 03:52:13AM -0400, Jason Pyeron wrote:
> I just assumed that he had PK(bug,field,row) for that.

We're talking about the data table, not hte definition table - there
isn't any ordering from that POV.

> 
> I don't like not having a identity column. It just makes every thing 
> easier. 

Well, not necessarily.

The main issue with UNIQUE(NULL, x) is thatyou can then have multiple
values for x, eg (NULL, 1), (NULL, 1) is valid with a unique constraint,
since NULL != NULL.

On second throuhgs, maybe a separate 'defaults' table is better, but
shared for all types. Its not like creating a table costs us or
anything, and we won't be using this in a context where it would be an
extra join, I think - it'll just be a different one.

Bradley



More information about the developers mailing list