On Mon, 17 Oct 2016 15:40:44 -0500, Ben Newberg
> 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.
sqlite-users mailing list