Fossil

Check-in [55a3316b]
Login

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
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 55a3316b627d3ade86faad8de691358468912492c6d73b21830dc5358cb29398
User & Date: drh 2018-03-23 14:00:18.341
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
Unified Diff Ignore Whitespace Patch
Changes to src/tag.c.
︙︙
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527

        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);
      }








|








513
514
515
516
517
518
519
520
521
522
523
524
525
526
527

        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);
      }
︙︙
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713

  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();
}








|








699
700
701
702
703
704
705
706
707
708
709
710
711
712
713

  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();
}