(Fri, 23 Mar 10:06) Richard Hipp: > 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
I think that warning message is from sqlite3.c (where.c): https://www.sqlite.org/src/artifact/7cae47e813393d70?ln=714 > > 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. You can clone one of my repo to see it, for example, jmsn: https://f.juef.space/jmsn > 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. Yes, `make clean` was run before recompiling. -- 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