Re: Unique constraints and null

2006-03-23 Thread Bernt M. Johnsen
Mike Matrigali wrote (2006-03-22 11:22:39): I am not aware of any work being done. My only concern is that such an implementation does not the affect the performance of existing index operations. I would be interested in knowing what approach you are considering to address it. Some

Re: Feature freeze vs bug fix freeze (was Re: Unique constraints and null)

2006-03-23 Thread Rick Hillegas
Hi David, Yes, that is my understanding. I don't know any other way to address defects discovered during the stabilization/trashathon period. Regards, -Rick David W. Van Couvering wrote: I was wondering if I could get some clarity here. Feature freeze is soon approaching, but won't we be

Re: Unique constraints and null

2006-03-23 Thread Mike Matrigali
I agree that these 2 approaches should not affect performance of the index. I only bring it up as I once looked at a third option which put all the work in the index, which involved sometimes treating the nulls as different and sometimes the same - as you can imagine it added some ugly special

Re: Unique constraints and null

2006-03-22 Thread Bernt M. Johnsen
Oyvind Bakksjo wrote (2006-03-21 12:11:41): Hi folks, long time no see. :) I think I'm ready to start doing some work on Derby again (not full time, but more than zero time ;o). I was thinking of DERBY-653, which Rick H created and then closed himself during a discussion in October. I think

Re: Unique constraints and null

2006-03-22 Thread Mike Matrigali
I am not aware of any work being done. My only concern is that such an implementation does not the affect the performance of existing index operations. I would be interested in knowing what approach you are considering to address it. Oyvind Bakksjo wrote: Hi folks, long time no see. :) I

Re: Unique constraints and null

2006-03-22 Thread Kathey Marsden
Oyvind Bakksjo wrote: I think I'm ready to start doing some work on Derby again (not full time, but more than zero time ;o). Welcome back Oyvind!Feature freeze for 10.2 is fast approaching . I hope you will also consider picking up a bug or two. According to Jira, we currently have 155

Unique constraints and null

2006-03-21 Thread Oyvind Bakksjo
Hi folks, long time no see. :)I think I'm ready to start doing some work on Derby again (not full time, but more than zero time ;o). I was thinking of DERBY-653, which Rick H created and then closed himself during a discussion in October. I think it would be nice if Derby behaved correctly

Re: Unique constraints and null

2006-03-21 Thread Rick Hillegas
Hi Øyvind, Welcome back! Delighted to see you have not escaped our gravitational pull! Personally, I don't have any strong feelings about this JIRA, but it is grounded in the real customer experience of Dan Meany. For the record, the relevant section of the SQL 2003 spec is Part 2, section

Re: Unique constraints and null

2006-03-21 Thread Andreas Korneliussen
Oyvind Bakksjo wrote: Hi folks, long time no see. :) Hi Øyvind! Great to have you back I think I'm ready to start doing some work on Derby again (not full time, but more than zero time ;o). I was thinking of DERBY-653, which Rick H created and then closed himself during a discussion in