Fossil SCM
Use the somewhat simpler join in place of a subselect
Commit
7563c241ce93422867eb379c550f2f355103fc61
Parent
dc87a9075b26d1b…
1 file changed
+3
-2
+3
-2
| --- src/finfo.c | ||
| +++ src/finfo.c | ||
| @@ -142,12 +142,13 @@ | ||
| 142 | 142 | zFilename = blob_str(&fname); |
| 143 | 143 | db_prepare(&q, |
| 144 | 144 | "SELECT b.uuid, ci.uuid, date(event.mtime,'localtime')," |
| 145 | 145 | " coalesce(event.ecomment, event.comment)," |
| 146 | 146 | " coalesce(event.euser, event.user)" |
| 147 | - " FROM mlink, blob b, event, blob ci" | |
| 148 | - " WHERE mlink.fnid=(SELECT fnid FROM filename WHERE name=%Q)" | |
| 147 | + " FROM mlink, blob b, event, blob ci, filename" | |
| 148 | + " WHERE filename.name=%Q" | |
| 149 | + " AND mlink.fnid=filename.fnid" | |
| 149 | 150 | " AND b.rid=mlink.fid" |
| 150 | 151 | " AND event.objid=mlink.mid" |
| 151 | 152 | " AND event.objid=ci.rid" |
| 152 | 153 | " ORDER BY event.mtime DESC LIMIT %d OFFSET %d", |
| 153 | 154 | zFilename, iLimit, iOffset |
| 154 | 155 |
| --- src/finfo.c | |
| +++ src/finfo.c | |
| @@ -142,12 +142,13 @@ | |
| 142 | zFilename = blob_str(&fname); |
| 143 | db_prepare(&q, |
| 144 | "SELECT b.uuid, ci.uuid, date(event.mtime,'localtime')," |
| 145 | " coalesce(event.ecomment, event.comment)," |
| 146 | " coalesce(event.euser, event.user)" |
| 147 | " FROM mlink, blob b, event, blob ci" |
| 148 | " WHERE mlink.fnid=(SELECT fnid FROM filename WHERE name=%Q)" |
| 149 | " AND b.rid=mlink.fid" |
| 150 | " AND event.objid=mlink.mid" |
| 151 | " AND event.objid=ci.rid" |
| 152 | " ORDER BY event.mtime DESC LIMIT %d OFFSET %d", |
| 153 | zFilename, iLimit, iOffset |
| 154 |
| --- src/finfo.c | |
| +++ src/finfo.c | |
| @@ -142,12 +142,13 @@ | |
| 142 | zFilename = blob_str(&fname); |
| 143 | db_prepare(&q, |
| 144 | "SELECT b.uuid, ci.uuid, date(event.mtime,'localtime')," |
| 145 | " coalesce(event.ecomment, event.comment)," |
| 146 | " coalesce(event.euser, event.user)" |
| 147 | " FROM mlink, blob b, event, blob ci, filename" |
| 148 | " WHERE filename.name=%Q" |
| 149 | " AND mlink.fnid=filename.fnid" |
| 150 | " AND b.rid=mlink.fid" |
| 151 | " AND event.objid=mlink.mid" |
| 152 | " AND event.objid=ci.rid" |
| 153 | " ORDER BY event.mtime DESC LIMIT %d OFFSET %d", |
| 154 | zFilename, iLimit, iOffset |
| 155 |