Hello, I have a duplicate rowid in a 3.16.2 database and this is
essentially produced as follows:
CREATE TABLE t(i INTEGER PRIMARY KEY, a TEXT)
;
INSERT INTO t VALUES
(NULL, 'generates row 1')
;
REPLACE INTO t VALUES
(NULL, 'generates row 2'),
(1, 'replaces row 1')
;
It is alright after changing the order in the multiple values. Hope
I'm not mistaken.Thanks, E. Pasma
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users