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
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
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
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
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
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
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
7 matches
Mail list logo