On 3/23/18, Svyatoslav Mishyn <svyatoslav.mis...@gmail.com> wrote: > (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' >
I do not understand that because the warning message is clearly conditional on FOSSIL_DEBUG. https://www.fossil-scm.org/fossil/artifact/3ad7d4054ca?ln=389 > > 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] > I get a warning about "sort w/o index" when I build with FOSSIL_DEBUG. I have never seen the too warnings you show above. I checked in a fix for the sort w/o index warning. But without being able to repo, I don't know how to fix the others. I still think the best solution is to compile w/o the FOSSIL_DEBUG setting. I'm not sure that is really happening. Maybe you need to do "make clean" or something. -- D. Richard Hipp d...@sqlite.org _______________________________________________ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users