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

Overview
Comment:Add the magic comment to the query for /tagtimeline to suppress the sort-w/o-index warning message from FOSSIL_DEBUG.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:55a3316b627d3ade86faad8de691358468912492c6d73b21830dc5358cb29398
User & Date: drh 2018-03-23 14:00:18
Context
2018-03-23
15:37
Disable the SQLite automatic index warning on non-debug builds. check-in: 1336c4af user: drh tags: trunk
14:00
Add the magic comment to the query for /tagtimeline to suppress the sort-w/o-index warning message from FOSSIL_DEBUG. check-in: 55a3316b user: drh tags: trunk
2018-03-22
19:43
Update the built-in SQLite to the latest pre-release snapshot for beta testing. check-in: 1849c6e2 user: drh tags: trunk
Changes

Changes to src/tag.c.

513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
...
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
        blob_append_sql(&sql,
          "%s"
          "  AND event.type GLOB '%q'"
          "  AND blob.rid IN ("
                    " SELECT rid FROM tagxref"
                    "  WHERE tagtype>0 AND tagid=%d"
                    ")"
          " ORDER BY event.mtime DESC",
          timeline_query_for_tty(), zType, tagid
        );
        db_prepare(&q, "%s", blob_sql_text(&sql));
        blob_reset(&sql);
        print_timeline(&q, nFindLimit, 79, 0);
        db_finalize(&q);
      }
................................................................................
  login_anonymous_available();
  @ <h2>Check-ins with non-propagating tags:</h2>
  db_prepare(&q,
    "%s AND blob.rid IN (SELECT rid FROM tagxref"
    "                     WHERE tagtype=1 AND srcid>0"
    "                       AND tagid IN (SELECT tagid FROM tag "
    "                                      WHERE tagname GLOB 'sym-*'))"
    " ORDER BY event.mtime DESC",
    timeline_query_for_www()
  );
  www_print_timeline(&q, 0, 0, 0, 0, 0);
  db_finalize(&q);
  @ <br />
  style_footer();
}







|







 







|







513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
...
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
        blob_append_sql(&sql,
          "%s"
          "  AND event.type GLOB '%q'"
          "  AND blob.rid IN ("
                    " SELECT rid FROM tagxref"
                    "  WHERE tagtype>0 AND tagid=%d"
                    ")"
          " ORDER BY event.mtime DESC /*sort*/",
          timeline_query_for_tty(), zType, tagid
        );
        db_prepare(&q, "%s", blob_sql_text(&sql));
        blob_reset(&sql);
        print_timeline(&q, nFindLimit, 79, 0);
        db_finalize(&q);
      }
................................................................................
  login_anonymous_available();
  @ <h2>Check-ins with non-propagating tags:</h2>
  db_prepare(&q,
    "%s AND blob.rid IN (SELECT rid FROM tagxref"
    "                     WHERE tagtype=1 AND srcid>0"
    "                       AND tagid IN (SELECT tagid FROM tag "
    "                                      WHERE tagname GLOB 'sym-*'))"
    " ORDER BY event.mtime DESC /*sort*/",
    timeline_query_for_www()
  );
  www_print_timeline(&q, 0, 0, 0, 0, 0);
  db_finalize(&q);
  @ <br />
  style_footer();
}