Glad to be of service, and thanks for the quick turn around.
On 11-06-10 02:35 PM, Dan Kennedy wrote: > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
