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

Reply via email to