Ok, I now see that you intentionally left 2 time-warps in place. It would be helpful to make that as a note for exporting to git. It is also confusing that the tags are there showing that they were fixed.
On Mon, Nov 3, 2014 at 5:44 PM, E. Timothy Uy <t...@loqu8.com> wrote: > Dear Richard, > > It is strange, but if you look at the timeline image I sent (second > email), your time-warp tag changes are clearly there but did not stick on > objid 35450 and 35460. I just manually did mine on this end (following your > same times) and it is now ok, though I feel a bit dirty changing commit > times! > > Leaving the time-warp in place will affect git export. Also, the other > barrier that blocks git export of the current sqlite version is that in the > fossil export.c, the pid needs to be filtered by type='ci' as one of the > parents is type='g' (tag). I have that in some notes in > http://www.fossil-scm.org/index.html/tktview?name=4013b0a81a > > db_prepare(&q3, > "SELECT pid FROM plink" > " WHERE cid=%d AND isprim" > " AND pid IN (SELECT objid FROM event WHERE type='ci')", > ckinId > ); > > Respectfully, > Tim > > On Mon, Nov 3, 2014 at 5:37 PM, Richard Hipp <d...@sqlite.org> wrote: > >> On Mon, Nov 3, 2014 at 8:13 PM, E. Timothy Uy <t...@loqu8.com> wrote: >> >> > I found some posts in the past describing fixing time-warps using tags. >> How >> > does this process get initiated? I found two while trying to export to >> .git >> > >> >> >> The test_timewarps webpage will show them all to you. Example: >> >> http://www.sqlite.org/src/test_timewarps >> >> In the example above, most of the timewarps have been fixed. To fix them, >> simple edit check-ins and change their time. >> >> I intentionally left one timewarp in SQLite unfixed. See the >> https://www.sqlite.org/src/timeline?p=3f30f00a384d23&d=3f30f00a384d235 >> timeline. I left this one as a test case for ensuring that Fossil can >> display timewarps correctly. >> >> >> >> >> > >> > sqlite> SELECT l.*, ep.mtime, ec.mtime FROM plink l LEFT JOIN event ep >> ON >> > pid = ep.objid LEFT JOIN event ec ON cid = ec.objid WHERE ep.mtime > >> > ec.mtime LIMIT 10; >> > >> > 35460|35462|1|2455469.26833333|2455469.46484954|2455469.26833333 >> > >> > 35450|35453|1|2455468.35189815|2455468.80332176|2455468.35189815 >> > >> > Respectfully, >> > >> > Tim >> > _______________________________________________ >> > sqlite-users mailing list >> > sqlite-users@sqlite.org >> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > >> >> >> >> -- >> D. Richard Hipp >> d...@sqlite.org >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users