To reproduce this problem, enter the following 5 SQL statements at the SQLite command line.
create table X(id INTEGER primary key ON CONFLICT REPLACE); create table Y(id INTEGER primary key ON CONFLICT REPLACE); insert into X values (1); insert into Y select * from X; insert into Y select * from X; When I tried to run the last SQL statement twice, SQLite produced the following error message. Error: PRIMARY KEY must be unique Is this a bug? Please advise. Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
