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 happened.
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 > 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 anything in the sqlite_master table you are > circumventing all mechanisms SQLite has to keep the database > consistent. > 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. > > -- > Regards, > > Kees Nuyt > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
