create table IF NOT EXISTS Unions
(
    Id integer primary key autoincrement,
    UName nvarchar(500) unique,
    Filter bit not null default 0
);
 
replace into Unions(UName,Filter) values('a','True')--Source Id is 1
replace into Unions(UName,Filter) values('a','False')//Changed Id is 2
why primary key can changed?Id changed is 2,is bug?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to