Fossil

Check-in [d9841bef06]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Avoid duplicate entries in the output of "fossil finfo"
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | piechart
Files: files | file ages | folders
SHA1: d9841bef06f7eabb09e4d354d5bcd0b46635d10c
User & Date: drh 2015-05-10 16:09:42.044
Context
2015-05-11
01:31
Merge in the --compress-only option for "fossil rebuild" check-in: 9fdfaf0f68 user: drh tags: piechart
2015-05-10
17:35
Avoid duplicate entries in the output of "fossil finfo". check-in: 26c283467a user: drh tags: trunk
16:09
Avoid duplicate entries in the output of "fossil finfo" check-in: d9841bef06 user: drh tags: piechart
2015-05-09
23:08
Automatically show a piechart in addition to the bar graph on ByUser and ByDayOfWeek activity reports. check-in: f857ea5410 user: drh tags: piechart
Changes
Unified Diff Ignore Whitespace Patch
Changes to src/finfo.c.
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
    rid = db_int(0, "SELECT rid FROM vfile WHERE pathname=%B %s",
                 &fname, filename_collation());
    if( rid==0 ){
      fossil_fatal("no history for file: %b", &fname);
    }
    zFilename = blob_str(&fname);
    db_prepare(&q,
        "SELECT b.uuid, ci.uuid, date(event.mtime%s),"
        "       coalesce(event.ecomment, event.comment),"
        "       coalesce(event.euser, event.user),"
        "       (SELECT value FROM tagxref WHERE tagid=%d AND tagtype>0"
                                " AND tagxref.rid=mlink.mid)" /* Tags */
        "  FROM mlink, blob b, event, blob ci, filename"
        " WHERE filename.name=%Q %s"
        "   AND mlink.fnid=filename.fnid"







|







180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
    rid = db_int(0, "SELECT rid FROM vfile WHERE pathname=%B %s",
                 &fname, filename_collation());
    if( rid==0 ){
      fossil_fatal("no history for file: %b", &fname);
    }
    zFilename = blob_str(&fname);
    db_prepare(&q,
        "SELECT DISTINCT b.uuid, ci.uuid, date(event.mtime%s),"
        "       coalesce(event.ecomment, event.comment),"
        "       coalesce(event.euser, event.user),"
        "       (SELECT value FROM tagxref WHERE tagid=%d AND tagtype>0"
                                " AND tagxref.rid=mlink.mid)" /* Tags */
        "  FROM mlink, blob b, event, blob ci, filename"
        " WHERE filename.name=%Q %s"
        "   AND mlink.fnid=filename.fnid"