Re: [sqlite] autoincrement ... primary-key bug

2003-12-08 Thread D. Richard Hipp
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 th

Re: [sqlite] autoincrement ... primary-key bug

2003-12-08 Thread Kurt Welgehausen
> CREATE TABLE User ( Name VARCHAR (40), > UID INTEGER, > DeviceID VARCHAR (64) DEFAULT 'Unknown', > PRIMARY KEY (Name, UID, DeviceID) ); > INSERT INTO User (Name,DeviceID) VALUES ('M