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
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

Reply via email to