Re: [sqlite] NULL values with NOT NULL constraint

2004-12-08 Thread Ara.T.Howard
On Wed, 8 Dec 2004, D. Richard Hipp wrote: Ara.T.Howard wrote: Has anyone seen anything like this and can suggest possible causes? does your code fork? Ooo. That sounds like the voice of experience speaking. :-) I should add forking to the documented list of ways to corrupt your database file. i

Re: [sqlite] NULL values with NOT NULL constraint

2004-12-08 Thread D. Richard Hipp
Ara.T.Howard wrote: Has anyone seen anything like this and can suggest possible causes? does your code fork? Ooo. That sounds like the voice of experience speaking. :-) I should add forking to the documented list of ways to corrupt your database file. -- D. Richard Hipp -- [EMAIL PROTECTED] --

Re: [sqlite] NULL values with NOT NULL constraint

2004-12-08 Thread Ara.T.Howard
On Wed, 8 Dec 2004, Michael Robinette wrote: I have table somewhat like this created by sqlite 2.8.14: create table t1( created timestamp not null, n int not null, url text not null, primary key(n) ); somehow i've ended up with a database where .dump t1 produces a bunch of insert into t1

Re: [sqlite] NULL values with NOT NULL constraint

2004-12-08 Thread D. Richard Hipp
Michael Robinette wrote: I have table somewhat like this created by sqlite 2.8.14: create table t1( created timestamp not null, n int not null, url text not null, primary key(n) ); somehow i've ended up with a database where .dump t1 produces a bunch of insert into t1 values(NULL,NULL,NULL); a

[sqlite] NULL values with NOT NULL constraint

2004-12-08 Thread Michael Robinette
I have table somewhat like this created by sqlite 2.8.14: create table t1( created timestamp not null, n int not null, url text not null, primary key(n) ); somehow i've ended up with a database where .dump t1 produces a bunch of insert into t1 values(NULL,NULL,NULL); a pragma integrity_check