Fossil SCM

Add the magic comment to the query for /tagtimeline to suppress the sort-w/o-index warning message from FOSSIL_DEBUG.

drh 2018-03-23 14:00 trunk
Commit 55a3316b627d3ade86faad8de691358468912492c6d73b21830dc5358cb29398
1 file changed +2 -2
+2 -2
--- src/tag.c
+++ src/tag.c
@@ -515,11 +515,11 @@
515515
" AND event.type GLOB '%q'"
516516
" AND blob.rid IN ("
517517
" SELECT rid FROM tagxref"
518518
" WHERE tagtype>0 AND tagid=%d"
519519
")"
520
- " ORDER BY event.mtime DESC",
520
+ " ORDER BY event.mtime DESC /*sort*/",
521521
timeline_query_for_tty(), zType, tagid
522522
);
523523
db_prepare(&q, "%s", blob_sql_text(&sql));
524524
blob_reset(&sql);
525525
print_timeline(&q, nFindLimit, 79, 0);
@@ -701,13 +701,13 @@
701701
db_prepare(&q,
702702
"%s AND blob.rid IN (SELECT rid FROM tagxref"
703703
" WHERE tagtype=1 AND srcid>0"
704704
" AND tagid IN (SELECT tagid FROM tag "
705705
" WHERE tagname GLOB 'sym-*'))"
706
- " ORDER BY event.mtime DESC",
706
+ " ORDER BY event.mtime DESC /*sort*/",
707707
timeline_query_for_www()
708708
);
709709
www_print_timeline(&q, 0, 0, 0, 0, 0);
710710
db_finalize(&q);
711711
@ <br />
712712
style_footer();
713713
}
714714
--- src/tag.c
+++ src/tag.c
@@ -515,11 +515,11 @@
515 " AND event.type GLOB '%q'"
516 " AND blob.rid IN ("
517 " SELECT rid FROM tagxref"
518 " WHERE tagtype>0 AND tagid=%d"
519 ")"
520 " ORDER BY event.mtime DESC",
521 timeline_query_for_tty(), zType, tagid
522 );
523 db_prepare(&q, "%s", blob_sql_text(&sql));
524 blob_reset(&sql);
525 print_timeline(&q, nFindLimit, 79, 0);
@@ -701,13 +701,13 @@
701 db_prepare(&q,
702 "%s AND blob.rid IN (SELECT rid FROM tagxref"
703 " WHERE tagtype=1 AND srcid>0"
704 " AND tagid IN (SELECT tagid FROM tag "
705 " WHERE tagname GLOB 'sym-*'))"
706 " ORDER BY event.mtime DESC",
707 timeline_query_for_www()
708 );
709 www_print_timeline(&q, 0, 0, 0, 0, 0);
710 db_finalize(&q);
711 @ <br />
712 style_footer();
713 }
714
--- src/tag.c
+++ src/tag.c
@@ -515,11 +515,11 @@
515 " AND event.type GLOB '%q'"
516 " AND blob.rid IN ("
517 " SELECT rid FROM tagxref"
518 " WHERE tagtype>0 AND tagid=%d"
519 ")"
520 " ORDER BY event.mtime DESC /*sort*/",
521 timeline_query_for_tty(), zType, tagid
522 );
523 db_prepare(&q, "%s", blob_sql_text(&sql));
524 blob_reset(&sql);
525 print_timeline(&q, nFindLimit, 79, 0);
@@ -701,13 +701,13 @@
701 db_prepare(&q,
702 "%s AND blob.rid IN (SELECT rid FROM tagxref"
703 " WHERE tagtype=1 AND srcid>0"
704 " AND tagid IN (SELECT tagid FROM tag "
705 " WHERE tagname GLOB 'sym-*'))"
706 " ORDER BY event.mtime DESC /*sort*/",
707 timeline_query_for_www()
708 );
709 www_print_timeline(&q, 0, 0, 0, 0, 0);
710 db_finalize(&q);
711 @ <br />
712 style_footer();
713 }
714

Keyboard Shortcuts

Open search /
Next entry (timeline) j
Previous entry (timeline) k
Open focused entry Enter
Show this help ?
Toggle theme Top nav button