Fossil SCM
Slight re-parenthesizing of the previous commit's query to avoid a corner case of picking up a non-technote artifact, as reported in [forum:59014563bd|forum post 2026-10-08T09:35:25Z].
Commit
349f1a8eabc66b125e8bb622367aaa47dd59135c4eac1c5d40d8f8b1fc6597e6
Parent
ffc9cab3acfa3d9…
1 file changed
+3
-2
+3
-2
| --- src/wiki.c | ||
| +++ src/wiki.c | ||
| @@ -2152,15 +2152,16 @@ | ||
| 2152 | 2152 | " WHERE e.type='e'" |
| 2153 | 2153 | " AND e.tagid IS NOT NULL" |
| 2154 | 2154 | " AND (e.objid IN" |
| 2155 | 2155 | " (SELECT rid FROM tagxref" |
| 2156 | 2156 | " WHERE tagid=(SELECT tagid FROM tag" |
| 2157 | - " WHERE tagname GLOB '%q')))" | |
| 2158 | - " OR (e.objid IN" | |
| 2157 | + " WHERE tagname GLOB '%q'))" | |
| 2158 | + " OR (e.objid IN" | |
| 2159 | 2159 | " (SELECT rid FROM tagxref" |
| 2160 | 2160 | " WHERE tagid=(SELECT tagid FROM tag" |
| 2161 | 2161 | " WHERE tagname GLOB 'sym-%q')))" |
| 2162 | + " )" | |
| 2162 | 2163 | " ORDER BY e.mtime DESC LIMIT 1", |
| 2163 | 2164 | zETime, zETime); |
| 2164 | 2165 | } |
| 2165 | 2166 | return rid; |
| 2166 | 2167 | } |
| 2167 | 2168 |
| --- src/wiki.c | |
| +++ src/wiki.c | |
| @@ -2152,15 +2152,16 @@ | |
| 2152 | " WHERE e.type='e'" |
| 2153 | " AND e.tagid IS NOT NULL" |
| 2154 | " AND (e.objid IN" |
| 2155 | " (SELECT rid FROM tagxref" |
| 2156 | " WHERE tagid=(SELECT tagid FROM tag" |
| 2157 | " WHERE tagname GLOB '%q')))" |
| 2158 | " OR (e.objid IN" |
| 2159 | " (SELECT rid FROM tagxref" |
| 2160 | " WHERE tagid=(SELECT tagid FROM tag" |
| 2161 | " WHERE tagname GLOB 'sym-%q')))" |
| 2162 | " ORDER BY e.mtime DESC LIMIT 1", |
| 2163 | zETime, zETime); |
| 2164 | } |
| 2165 | return rid; |
| 2166 | } |
| 2167 |
| --- src/wiki.c | |
| +++ src/wiki.c | |
| @@ -2152,15 +2152,16 @@ | |
| 2152 | " WHERE e.type='e'" |
| 2153 | " AND e.tagid IS NOT NULL" |
| 2154 | " AND (e.objid IN" |
| 2155 | " (SELECT rid FROM tagxref" |
| 2156 | " WHERE tagid=(SELECT tagid FROM tag" |
| 2157 | " WHERE tagname GLOB '%q'))" |
| 2158 | " OR (e.objid IN" |
| 2159 | " (SELECT rid FROM tagxref" |
| 2160 | " WHERE tagid=(SELECT tagid FROM tag" |
| 2161 | " WHERE tagname GLOB 'sym-%q')))" |
| 2162 | " )" |
| 2163 | " ORDER BY e.mtime DESC LIMIT 1", |
| 2164 | zETime, zETime); |
| 2165 | } |
| 2166 | return rid; |
| 2167 | } |
| 2168 |