(Fri, 23 Mar 07:56) Richard Hipp: > > how to fix an SQLite warning on the /tagtimeline page? > > The easiest solution is probably to recompile without the -DFOSSIL_DEBUG > option.
it didn't go away with: ./configure --fossil-debug=0 CFLAGS='-UFOSSIL_DEBUG' with ./configure --fossil-debug, there are just more details: SQLITE_WARNING: automatic index on tagxref(tagtype) 21 scan steps for 1 rows in [SELECT blob.rid AS blobRid, uuid AS uuid, datetime(event.mtime,toLocal()) AS timestamp, coalesce(ecomment, comment) AS comment, coalesce(euser, user) AS user, blob.rid IN leaf AS leaf, bgcolor AS bgColor, event.type AS eventType, (SELECT group_concat(substr(tagname,5), ', ') FROM tag, tagxref WHERE tagname GLOB 'sym-*' AND tag.tagid=tagxref.tagid AND tagxref.rid=blob.rid AND tagxref.tagtype>0) AS tags, tagid AS tagid, brief AS brief, event.mtime AS mtime FROM event CROSS JOIN blob WHERE blob.rid=event.objid 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] -- https://www.juef.space/ _______________________________________________ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users