On 06/11/2011 12:08 AM, Max wrote: > CREATE TABLE TestTable ( > id integer primary key, > name varchar, > source_id integer not null, > parent_id integer, > foreign key(source_id, parent_id) references TestTable(source_id, id) > ); > > CREATE UNIQUE INDEX testindex on TestTable(source_id, id); > > PRAGMA foreign_keys=1; > INSERT INTO TestTable VALUES (1, 'Parent', 1, null); > INSERT INTO TestTable VALUES (2, 'Child', 1, 1); > > UPDATE TestTable SET parent_id=1000 where id=2; > > Error: near line 15: database disk image is malformed
Thanks. Should be fixed here: http://www.sqlite.org/src/info/2b3d9996a8 Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users