195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
|
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
|
-
-
+
+
+
+
+
|
** (1) Primary parents
** (2) Merge parents
** (3) Cherrypick merge parents.
** (4) All ancestores of 1 and 2 but not of 3.
*/
double rLimitMtime = 0.0;
if( ridBackTo ){
rLimitMtime = db_double(0.0, "SELECT mtime FROM event WHERE objid=%d",
ridBackTo);
rLimitMtime = db_double(0.0,
"SELECT mtime FROM event"
" WHERE objid=%d"
" AND mtime<(SELECT mtime FROM event WHERE objid=%d)",
ridBackTo, rid);
}
db_multi_exec(
"WITH RECURSIVE "
" parent(pid,cid,isCP) AS ("
" SELECT plink.pid, plink.cid, 0 AS xisCP FROM plink"
" UNION ALL"
" SELECT parentid, childid, 1 FROM cherrypick WHERE NOT isExclude"
|