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
hap
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 sqlite_mast
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 file."
When changing an
e-users-boun...@mailinglists.sqlite.org] On
Behalf Of Ben Newberg
Sent: Monday, October 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 som
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 dow
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 believe what you wrote. One
On 14 Oct 2016, Simon Slavin wrote:
> The problem is that SQLite doesn't expect you to make manual changes to
> sqlite_master. It doesn't reread the schema to execute every command.
That is factually correct as evidenced by this example:
=== snip
(loco2-precise)torsten.landschoff@h
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 to find the
> offending rows th
Hi *,
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 to find the
offending rows that I know are there.
However, the integrity check just pa
9 matches
Mail list logo