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:7563c241ce93422867eb379c550f2f355103fc61
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);