Re: [sqlite] Only 128 inserts with NULL value for INTEGER PRIMARY KEY

Tom Deblauwe wrote: Tom Deblauwe wrote: D. Richard Hipp wrote: What happens when you try to insert the 129th value? I tried now the following: I get the same results in the windows commandline tool: MAX(iID) gives met 127 and COUNT(iID) gives me 29... Hereby is the database attached!

Re: [sqlite] Only 128 inserts with NULL value for INTEGER PRIMARY KEY

Tom Deblauwe wrote: D. Richard Hipp wrote: What happens when you try to insert the 129th value? I tried now the following: add entries with NULL => ok until 128 when I first add index 100, and then add values with NULL as index, it stops inserts until 128, then I get the message again abo

Re: [sqlite] Only 128 inserts with NULL value for INTEGER PRIMARY KEY

D. Richard Hipp wrote: What happens when you try to insert the 129th value? I just tried inserting 10 rows using 2.8.16 and a NULL integer primary key and everything worked great. I get the error message that the integer primary key must be unique. It seems that when the new number is gen

Re: [sqlite] Only 128 inserts with NULL value for INTEGER PRIMARY KEY

On Mon, 2005-06-06 at 13:02 +0200, Tom Deblauwe wrote: > Hello, > > I have the problem that I can only insert 128 values into my databases What happens when you try to insert the 129th value? I just tried inserting 10 rows using 2.8.16 and a NULL integer primary key and everything worked gr

[sqlite] Only 128 inserts with NULL value for INTEGER PRIMARY KEY

Hello, I have the problem that I can only insert 128 values into my databases if I use NULL als value for the INTEGER PRIMARY KEY field. If I supply myself an unique number, then there is no problem to add more than 128 records! I am running 2.8.16, on an embedded platform, with 32 bit poin