Fossil SCM

Fix a possible UNIQUE constraint violation in the new /vdiff logic.

drh 2019-09-03 20:08 vdiff-improvements
Commit 8e175a67084cdee77842ec28dd8f99e67a00982dd5a4531702e8148aa7ff3ee5
1 file changed +1 -1
+1 -1
--- src/info.c
+++ src/info.c
@@ -269,11 +269,11 @@
269269
"CREATE TEMP TABLE IF NOT EXISTS ok(rid INTEGER PRIMARY KEY);"
270270
"DELETE FROM ok;"
271271
);
272272
for(i=0; i<n; i++){
273273
db_multi_exec(
274
- "INSERT INTO ok VALUES(%d);"
274
+ "INSERT OR IGNORE INTO ok VALUES(%d);"
275275
"INSERT OR IGNORE INTO ok SELECT pid FROM plink WHERE cid=%d;",
276276
rx[i], rx[i]
277277
);
278278
}
279279
if( !parentsOnly ){
280280
--- src/info.c
+++ src/info.c
@@ -269,11 +269,11 @@
269 "CREATE TEMP TABLE IF NOT EXISTS ok(rid INTEGER PRIMARY KEY);"
270 "DELETE FROM ok;"
271 );
272 for(i=0; i<n; i++){
273 db_multi_exec(
274 "INSERT INTO ok VALUES(%d);"
275 "INSERT OR IGNORE INTO ok SELECT pid FROM plink WHERE cid=%d;",
276 rx[i], rx[i]
277 );
278 }
279 if( !parentsOnly ){
280
--- src/info.c
+++ src/info.c
@@ -269,11 +269,11 @@
269 "CREATE TEMP TABLE IF NOT EXISTS ok(rid INTEGER PRIMARY KEY);"
270 "DELETE FROM ok;"
271 );
272 for(i=0; i<n; i++){
273 db_multi_exec(
274 "INSERT OR IGNORE INTO ok VALUES(%d);"
275 "INSERT OR IGNORE INTO ok SELECT pid FROM plink WHERE cid=%d;",
276 rx[i], rx[i]
277 );
278 }
279 if( !parentsOnly ){
280

Keyboard Shortcuts

Open search /
Next entry (timeline) j
Previous entry (timeline) k
Open focused entry Enter
Show this help ?
Toggle theme Top nav button