First off, my apologies for hijacking this thread. But I've seen some strange things when messing with pragma writable_schema. It appears all bets are off?
example: create a table of columns (x, y, z), and fill it with values. then, modify sqlite_master to take out column z. let's say later on down the line, you either add a column using the pragma writable_schema, or the ALTER TABLE. What happens is the new column is filled with the old column's values: SQLite version 3.14.2 2016-09-12 18:50:49 Enter ".help" for usage hints. sqlite> .headers on sqlite> create table t (x, y, z); sqlite> insert into t values (1, 'a', 'A'), (2, 'b', 'B'), (3, 'c', 'C'); sqlite> select * from t; x|y|z 1|a|A 2|b|B 3|c|C sqlite> pragma writable_schema = 1; sqlite> update sqlite_master set sql = 'create table t (x, y)' where name = 't'; sqlite> select * from t; x|y|z 1|a|A 2|b|B 3|c|C -- we are still seeing column z, until we vaccum: sqlite> vacuum; Error: table vacuum_db.t has 2 columns but 3 values were supplied sqlite> select * from t; x|y 1|a 2|b 3|c sqlite> alter table t add column w; sqlite> insert into t values (4, 'd', 'D'); sqlite> select * from t; x|y|w 1|a|A 2|b|B 3|c|C 4|d|D sqlite> On Mon, Oct 17, 2016 at 4:03 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 17 Oct 2016, at 8:17am, Torsten Landschoff <torsten.landsch...@scale.eu> > wrote: > > > So much about my attempt to report a bug. If you don't want to believe my > > report, then don't. > > Sorry, just to make it clear, I'm just a fellow-user of SQLite. I'm not > on the development team. And I totally believe what you wrote. One of > more of the development team might be figuring out the problem right now. > > Simon. > _______________________________________________ > 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
