Kurt Welgehausen wrote:
D.R.Hipp:
"I concur. The uniqueness constraint is not being enforced for
multi-column primary keys. Why don't you write a ticket."
-------------------------------------------------------------------
[1]If you're intending to follow SQL92, this is definitely
a bug, since the std does not allow any column of a primary
key to be null. Both insertions should have been rejected,
not just the second.
My intent is for PRIMARY KEY to imply both NOT NULL and UNIQUE,
which, if my understanding is correct, is what SQL requires.
SQLite is clearly not doing this in every case. It needs to
be fixed.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
