On Mon, 17 Oct 2016 15:40:44 -0500, Ben Newberg <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
