Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Use the somewhat simpler join in place of a subselect |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 7563c241ce93422867eb379c550f2f35 |
| User & Date: | joerg 2011-03-25 02:53:13 |
Context
|
2011-03-25
| ||
| 02:55 | Move vfile_check_signature into "finfo --status" branch. The other options don't use it and it involves a lot of IO. check-in: ae84e6c7 user: joerg tags: trunk | |
| 02:53 | Use the somewhat simpler join in place of a subselect check-in: 7563c241 user: joerg tags: trunk | |
|
2011-03-24
| ||
| 18:34 | fix typo in error msg check-in: dc87a907 user: bharder tags: trunk | |
Changes
Changes to src/finfo.c.
140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 |
fossil_fatal("no history for file: %b", &fname);
}
zFilename = blob_str(&fname);
db_prepare(&q,
"SELECT b.uuid, ci.uuid, date(event.mtime,'localtime'),"
" coalesce(event.ecomment, event.comment),"
" coalesce(event.euser, event.user)"
" FROM mlink, blob b, event, blob ci"
" WHERE mlink.fnid=(SELECT fnid FROM filename WHERE name=%Q)"
" AND b.rid=mlink.fid"
" AND event.objid=mlink.mid"
" AND event.objid=ci.rid"
" ORDER BY event.mtime DESC LIMIT %d OFFSET %d",
zFilename, iLimit, iOffset
);
blob_zero(&line);
|
| | > |
140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 |
fossil_fatal("no history for file: %b", &fname);
}
zFilename = blob_str(&fname);
db_prepare(&q,
"SELECT b.uuid, ci.uuid, date(event.mtime,'localtime'),"
" coalesce(event.ecomment, event.comment),"
" coalesce(event.euser, event.user)"
" FROM mlink, blob b, event, blob ci, filename"
" WHERE filename.name=%Q"
" AND mlink.fnid=filename.fnid"
" AND b.rid=mlink.fid"
" AND event.objid=mlink.mid"
" AND event.objid=ci.rid"
" ORDER BY event.mtime DESC LIMIT %d OFFSET %d",
zFilename, iLimit, iOffset
);
blob_zero(&line);
|