Fossil SCM
Temporary fix for a bad query plan caused by issues in SQLite. See [forum:/forumpost/6900455c28dcd3da|forum post 6900455c28dcd3da].
Commit
9866c97b357062f8ef3c3f5a5aa92c065d0de1f3d82655d0a4cb343dd44aeccf
Parent
b58b30512e88213…
1 file changed
+1
-1
+1
-1
| --- src/descendants.c | ||
| +++ src/descendants.c | ||
| @@ -247,11 +247,11 @@ | ||
| 247 | 247 | " AND event.objid=plink.pid" |
| 248 | 248 | " ORDER BY mtime DESC" |
| 249 | 249 | " )" |
| 250 | 250 | " SELECT ancestor.rid FROM ancestor" |
| 251 | 251 | " WHERE EXISTS(SELECT 1 FROM tagxref" |
| 252 | - " WHERE tagid=%d AND tagxref.rid=ancestor.rid" | |
| 252 | + " WHERE tagid=%d AND tagxref.rid=+ancestor.rid" | |
| 253 | 253 | " AND value=%Q AND tagtype>0)" |
| 254 | 254 | " LIMIT 1", |
| 255 | 255 | rid, rid, TAG_BRANCH, zBranch |
| 256 | 256 | ); |
| 257 | 257 | } |
| 258 | 258 |
| --- src/descendants.c | |
| +++ src/descendants.c | |
| @@ -247,11 +247,11 @@ | |
| 247 | " AND event.objid=plink.pid" |
| 248 | " ORDER BY mtime DESC" |
| 249 | " )" |
| 250 | " SELECT ancestor.rid FROM ancestor" |
| 251 | " WHERE EXISTS(SELECT 1 FROM tagxref" |
| 252 | " WHERE tagid=%d AND tagxref.rid=ancestor.rid" |
| 253 | " AND value=%Q AND tagtype>0)" |
| 254 | " LIMIT 1", |
| 255 | rid, rid, TAG_BRANCH, zBranch |
| 256 | ); |
| 257 | } |
| 258 |
| --- src/descendants.c | |
| +++ src/descendants.c | |
| @@ -247,11 +247,11 @@ | |
| 247 | " AND event.objid=plink.pid" |
| 248 | " ORDER BY mtime DESC" |
| 249 | " )" |
| 250 | " SELECT ancestor.rid FROM ancestor" |
| 251 | " WHERE EXISTS(SELECT 1 FROM tagxref" |
| 252 | " WHERE tagid=%d AND tagxref.rid=+ancestor.rid" |
| 253 | " AND value=%Q AND tagtype>0)" |
| 254 | " LIMIT 1", |
| 255 | rid, rid, TAG_BRANCH, zBranch |
| 256 | ); |
| 257 | } |
| 258 |