Fossil SCM

The cpnode table used for cherrypick timelines should be a TEMP table.

drh 2023-07-07 18:23 trunk
Commit 2478837b5674fce0989d90f14891405cc623278f0bfa149fa236a5392b6ae406
1 file changed +1 -1
+1 -1
--- src/timeline.c
+++ src/timeline.c
@@ -2283,11 +2283,11 @@
22832283
if( forkOnly ){
22842284
blob_append_sql(&cond, " AND event.objid IN rnfork ");
22852285
}
22862286
if( cpOnly && showCherrypicks ){
22872287
db_multi_exec(
2288
- "CREATE TABLE IF NOT EXISTS cpnodes(rid INTEGER PRIMARY KEY);"
2288
+ "CREATE TEMP TABLE IF NOT EXISTS cpnodes(rid INTEGER PRIMARY KEY);"
22892289
"INSERT OR IGNORE INTO cpnodes SELECT childid FROM cherrypick;"
22902290
"INSERT OR IGNORE INTO cpnodes SELECT parentid FROM cherrypick;"
22912291
);
22922292
blob_append_sql(&cond, " AND event.objid IN cpnodes ");
22932293
}
22942294
--- src/timeline.c
+++ src/timeline.c
@@ -2283,11 +2283,11 @@
2283 if( forkOnly ){
2284 blob_append_sql(&cond, " AND event.objid IN rnfork ");
2285 }
2286 if( cpOnly && showCherrypicks ){
2287 db_multi_exec(
2288 "CREATE TABLE IF NOT EXISTS cpnodes(rid INTEGER PRIMARY KEY);"
2289 "INSERT OR IGNORE INTO cpnodes SELECT childid FROM cherrypick;"
2290 "INSERT OR IGNORE INTO cpnodes SELECT parentid FROM cherrypick;"
2291 );
2292 blob_append_sql(&cond, " AND event.objid IN cpnodes ");
2293 }
2294
--- src/timeline.c
+++ src/timeline.c
@@ -2283,11 +2283,11 @@
2283 if( forkOnly ){
2284 blob_append_sql(&cond, " AND event.objid IN rnfork ");
2285 }
2286 if( cpOnly && showCherrypicks ){
2287 db_multi_exec(
2288 "CREATE TEMP TABLE IF NOT EXISTS cpnodes(rid INTEGER PRIMARY KEY);"
2289 "INSERT OR IGNORE INTO cpnodes SELECT childid FROM cherrypick;"
2290 "INSERT OR IGNORE INTO cpnodes SELECT parentid FROM cherrypick;"
2291 );
2292 blob_append_sql(&cond, " AND event.objid IN cpnodes ");
2293 }
2294

Keyboard Shortcuts

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