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

Reply via email to