Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Temporary fix for a bad query plan caused by issues in SQLite. See [forum:/forumpost/6900455c28dcd3da|forum post 6900455c28dcd3da]. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
9866c97b357062f8ef3c3f5a5aa92c06 |
| User & Date: | drh 2024-06-14 00:06:10.120 |
References
|
2024-08-31
| ||
| 17:30 | Revert the temporary fix [9866c97b35] as the underlying problem has been resolved in SQLite. check-in: ecaeb31f51 user: florian tags: trunk | |
Context
|
2024-08-31
| ||
| 17:30 | Revert the temporary fix [9866c97b35] as the underlying problem has been resolved in SQLite. check-in: ecaeb31f51 user: florian tags: trunk | |
|
2024-06-18
| ||
| 05:20 | Use auto-coloring for private branches, instead of applying the orangeish default `#fec084', so colors play better with skins and the `fossil publish' command. check-in: ee82746517 user: florian tags: trunk | |
|
2024-06-14
| ||
| 00:06 | Temporary fix for a bad query plan caused by issues in SQLite. See [forum:/forumpost/6900455c28dcd3da|forum post 6900455c28dcd3da]. check-in: 9866c97b35 user: drh tags: trunk | |
|
2024-06-11
| ||
| 18:44 | Update the built-in SQLite to a version from the exists-to-join branch in the SQLite source tree, in order to beta-test the exists-to-join optimization. Fossil uses EXISTS operators in the WHERE clause of queries in many places and is therefore a good test case. check-in: b58b30512e user: drh tags: trunk | |
Changes
Changes to src/descendants.c.
| ︙ | ︙ | |||
245 246 247 248 249 250 251 |
" 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"
| | | 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
);
}
/*
|
| ︙ | ︙ |