Fossil

Differences From Artifact [6fa21312cf]:

• File src/descendants.c — part of check-in [40266bf9b2] at 2023-07-16 20:47:43 on branch verify-options-cgi — Add calls to cgi_check_for_malice() on many more web pages. Log all 418 responses to the error log. (user: drh size: 21937) [more...]

To Artifact [bb63b0429b]:

• File src/descendants.c — part of check-in [9866c97b35] at 2024-06-14 00:06:10 on branch trunk — Temporary fix for a bad query plan caused by issues in SQLite. See [forum:/forumpost/6900455c28dcd3da|forum post 6900455c28dcd3da]. (user: drh size: 21938) [more...]

245
246
247
248
249
250
251
252
253
254
255
256
257
258
259

    "      FROM ancestor, plink, event"
    "     WHERE plink.cid=ancestor.rid"
    "       AND event.objid=plink.pid"
    "     ORDER BY mtime DESC"
    "  )"
    "  SELECT ancestor.rid FROM ancestor"
    "   WHERE EXISTS(SELECT 1 FROM tagxref"
                    " WHERE tagid=%d AND tagxref.rid=ancestor.rid"
                    "   AND value=%Q AND tagtype>0)"
    "  LIMIT 1",
    rid, rid, TAG_BRANCH, zBranch
  );
}

/*

|

245
246
247
248
249
250
251
252
253
254
255
256
257
258
259

    "      FROM ancestor, plink, event"
    "     WHERE plink.cid=ancestor.rid"
    "       AND event.objid=plink.pid"
    "     ORDER BY mtime DESC"
    "  )"
    "  SELECT ancestor.rid FROM ancestor"
    "   WHERE EXISTS(SELECT 1 FROM tagxref"
                    " WHERE tagid=%d AND tagxref.rid=+ancestor.rid"
                    "   AND value=%Q AND tagtype>0)"
    "  LIMIT 1",
    rid, rid, TAG_BRANCH, zBranch
  );
}

/*