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 Oct 17, 2016 5:21 PM, "Kees Nuyt" <k.n...@zonnet.nl> wrote:
> On Mon, 17 Oct 2016 15:40:44 -0500, Ben Newberg
> <ben.newb...@gmail.com> wrote:
> > But I've seen some strange things when messing with pragma
> > 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 anything in the sqlite_master table you are
> circumventing all mechanisms SQLite has to keep the database
> What you did in your example is creating a table description in
> sqlite_master that doesn't match the physical table in the
> database, so yes, all bets are off.
> Kees Nuyt
> sqlite-users mailing list
sqlite-users mailing list