Re: [fossil-users] Out-of-order timestamps cause invalid export files

2015-10-02 Thread David Given
On 28/09/15 23:43, Richard Hipp wrote: [...] > I built a test repository with a timewarp (using the --override-date > on a check-in) and it would not import into git. Then I fixed the > check-in time so that was chronological and tried again, and that time > the import worked great.

Re: [fossil-users] Out-of-order timestamps cause invalid export files

2015-09-28 Thread David Given
On 28/09/15 21:14, Richard Hipp wrote: [...] > Perhaps this following change will help. Please try and let us know: Thanks! Unfortunately: > -"SELECT strftime('%%s',mtime), objid, coalesce(ecomment,comment)," > +"SELECT strftime('%%s',coalesce(emtime,mtime)," There's a missing close

Re: [fossil-users] Out-of-order timestamps cause invalid export files

2015-09-28 Thread Richard Hipp
On 9/28/15, David Given wrote: > Somehow I've ended up in this situation, where the parent of a commit > has a newer timestamp than the child: > > http://cowlark.com/cgi-bin/fossil.cgi/flooded-moon/timeline?f=905a301d7d28267ee35c41e9dd080d1ce7bcec1d > > Exporting this leads to

[fossil-users] Out-of-order timestamps cause invalid export files

2015-09-28 Thread David Given
Somehow I've ended up in this situation, where the parent of a commit has a newer timestamp than the child: http://cowlark.com/cgi-bin/fossil.cgi/flooded-moon/timeline?f=905a301d7d28267ee35c41e9dd080d1ce7bcec1d Exporting this leads to the parent commit being emitted before the child commit which

Re: [fossil-users] Out-of-order timestamps cause invalid export files

2015-09-28 Thread Richard Hipp
On 9/28/15, Richard Hipp wrote: > On 9/28/15, David Given wrote: >> On 28/09/15 21:14, Richard Hipp wrote: >> [...] >>> Perhaps this following change will help. Please try and let us know: >> >> Thanks! Unfortunately: >> >>> -"SELECT

Re: [fossil-users] Out-of-order timestamps cause invalid export files

2015-09-28 Thread Richard Hipp
On 9/28/15, David Given wrote: > On 28/09/15 21:14, Richard Hipp wrote: > [...] >> Perhaps this following change will help. Please try and let us know: > > Thanks! Unfortunately: > >> -"SELECT strftime('%%s',mtime), objid, coalesce(ecomment,comment)," >> +"SELECT

Re: [fossil-users] Out-of-order timestamps cause invalid export files

2015-09-28 Thread Joerg Sonnenberger
On Mon, Sep 28, 2015 at 10:12:25PM +0200, David Given wrote: > There ought to be a cleverer way to do this than just relying on the > timestamp (which can be wrong). Isn't there an SQL example which uses a > recursive query to walk the commit tree? That way we'd be guaranteed to > get a correct