Re: [sqlite] duplicate primary key

On 8/25/06, Mario Frasca <[EMAIL PROTECTED]> wrote: what is going on here? I'm having three records with the same NULL primary key. Well, not the same. NULL values aren't equal to anything, including another NULL value.

Re: [sqlite] duplicate primary key

Mario Frasca <[EMAIL PROTECTED]> wrote: > this is a bit surprising; where does the autoincrement-like > behaviour come from? without an explicit autoincrement > definition, I would expect ... > what is going on here? I'm having three records with t

[sqlite] duplicate primary key

I'm recording this behaviour: sqlite> create table test(f integer primary key autoincrement, v integer default 0); sqlite> insert into test(f) values(NULL); sqlite> insert into test(f) values(NULL); sqlite> insert into test(f) values(NULL); sqlite> select * from test; 1|0 2|0 3|0 this is very