Re: [sqlite] pragma integrity_check doesn't check constraints without indices

2016-10-17 Thread Ben Newberg
To be clear, my question about all bets being off sounded more rhetorical in my head than it came out. I'm perfectly content with the outcome, just wanted to share an example of something I accidently learned the hard way when messing with schemas. And thanks to you all I know more about why it

Re: [sqlite] pragma integrity_check doesn't check constraints without indices

2016-10-17 Thread R Smith
On 2016/10/17 10:40 PM, Ben Newberg wrote: First off, my apologies for hijacking this thread. But I've seen some strange things when messing with pragma writable_schema. It appears all bets are off? example: create a table of columns (x, y, z), and fill it with values. then, modify

Re: [sqlite] pragma integrity_check doesn't check constraints without indices

2016-10-17 Thread Kees Nuyt
On Mon, 17 Oct 2016 15:40:44 -0500, Ben Newberg wrote: > But I've seen some strange things when messing with pragma writable_schema. > It appears all bets are off? Yes. that's why there's a warning: "Warning: misuse of this pragma can easily result in a corrupt database

Re: [sqlite] pragma integrity_check doesn't check constraints without indices

2016-10-17 Thread David Raymond
ber 17, 2016 4:41 PM To: SQLite mailing list Subject: Re: [sqlite] pragma integrity_check doesn't check constraints without indices First off, my apologies for hijacking this thread. But I've seen some strange things when messing with pragma writable_schema. It appears all bets are off? exa

Re: [sqlite] pragma integrity_check doesn't check constraints without indices

2016-10-17 Thread Ben Newberg
First off, my apologies for hijacking this thread. But I've seen some strange things when messing with pragma writable_schema. It appears all bets are off? example: create a table of columns (x, y, z), and fill it with values. then, modify sqlite_master to take out column z. let's say later on

Re: [sqlite] pragma integrity_check doesn't check constraints without indices

2016-10-17 Thread Simon Slavin
On 17 Oct 2016, at 8:17am, Torsten Landschoff wrote: > So much about my attempt to report a bug. If you don't want to believe my > report, then don't. Sorry, just to make it clear, I'm just a fellow-user of SQLite. I'm not on the development team. And I totally

Re: [sqlite] pragma integrity_check doesn't check constraints without indices

2016-10-14 Thread Simon Slavin
On 13 Oct 2016, at 3:46pm, Torsten Landschoff wrote: > while working on a database upgrade on our application I found a bug in > SQLite. I was adding a not null constraint by updating the sqlite_master > table and to see the check fail used pragma integrity_check