Mailing List Archive


Back to the month index Back to the list index
David J. Hughes (bambi@Hughes.com.au)
Thu, 15 Apr 1999 10:30:00 +1000 (EST) 

Date: Thu, 15 Apr 1999 10:30:00 +1000 (EST)
From: "David J. Hughes" <bambi@Hughes.com.au>
Subject: Re: un-enforced "unique" indices
Message-ID: <Pine.BSF.3.96.990415102816.353E-100000@fawn.Hughes.com.au>

On Mon, 12 Apr 1999, James E. Harrell wrote:

> > Having a problem with unique indices... The index will enforce UNIQUE
> > when you attempt to insert *new* data, but when you update current data
> > in an indexed field, it allows non-unique data to be created... any
> > suggestions?

The above mentioned bug has been found and fixed. It is associated with
the fact that the index that should catch the non-unique situation is a
compound index that is partially (not fully) modified by the new values
provided in the update statement. The code now handles this situation
correctly.

The fix has been included in the 2.0.9 code.

Bambi
...