I am getting a "foreign key mismatch" in TCL in the following situation:
#The system is Ubuntu 10.10 32bit, using ActiveState 8.6 32 bit TCL binaries
% package require sqlite3
3.7.6.3
#Two example tables:
create table users (name primary key unique, pass not null)
create table users1 (name references users (name), pass references users (pass))
#the following works fine
insert into users values ('user1', 'pass1')
#either replace or update fail with "foreign key mismatch" error:
replace into users values ('user1', 'pass2')
#or
update users set name = 'user1', pass = 'pass2'
#if I remove one of the foreign keys from users1 table, the error goes away.
#The exact same replace and update commands work fine under sqlite3
shell, version 3.7.2-1ubuntu0.1, 32 bit
Thanks,
Victor
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
