Re: [sqlite] A constraint bug?

2009-10-31 Thread Jeremy Hinegardner
On Sat, Oct 31, 2009 at 08:31:01AM -0400, D. Richard Hipp wrote: > > On Oct 30, 2009, at 10:25 PM, Mick wrote: > > > This is more FYI than needing it (as I have already worked around > > it), but I > > have discovered that an IGNORE constraint on an insert, when one of > > the > > fields in

Re: [sqlite] A constraint bug?

2009-10-31 Thread D. Richard Hipp
On Oct 30, 2009, at 10:25 PM, Mick wrote: > This is more FYI than needing it (as I have already worked around > it), but I > have discovered that an IGNORE constraint on an insert, when one of > the > fields in the constraint is NULL, will insert a duplicate record > into the > database.

Re: [sqlite] A constraint bug?

2009-10-31 Thread Simon Davies
2009/10/31 Mick : > This is more FYI than needing it (as I have already worked around it), but I > have discovered that an IGNORE constraint on an insert, when one of the > fields in the constraint is NULL, will insert a duplicate record into the > database. > > i.e. > > CREATE

[sqlite] A constraint bug?

2009-10-31 Thread Mick
This is more FYI than needing it (as I have already worked around it), but I have discovered that an IGNORE constraint on an insert, when one of the fields in the constraint is NULL, will insert a duplicate record into the database. i.e. CREATE TABLE mytable ( ID1 INTEGER NOT NULL, ID2