Fossil

Check-in [7563c241]
Login

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
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 7563c241ce93422867eb379c550f2f355103fc61
User & Date: joerg 2011-03-25 02:53:13.822
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
Unified Diff Ignore Whitespace Patch
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);
︙︙