I try to Test this next days again. Today i was not Successful :(

Am Sonntag, 23. Februar 2014 schrieb Zhongpeng Lin :

> In pycvsanaly2/extensions/FileRevs.py:
>
> > @@ -32,9 +34,8 @@ class FileRevs:
> >  from scmlog s, action_files af where s.id = af.commit_id and s.repository_id = ? order by s.id'''
> >      # This query selects the newest entry for those cases with two filepaths
> >      # for the same file. See https://github.com/MetricsGrimoire/CVSAnalY/issues/3 for more info.
> > -    __path_query__ = '''SELECT file_path FROM file_links,
> > -(SELECT MAX(id) id FROM file_links WHERE file_id = ? AND commit_id <= ? ORDER BY commit_id DESC) fp
> > -WHERE file_links.id = fp.id'''
> > +    __path_query__ = '''SELECT rev, file_path FROM file_links fl JOIN scmlog s
>
> Isn't ORDER BY commit_id DESC, fl.id DESC sufficient to get max
> file_links id?
>
> --
> Reply to this email directly or view it on GitHub<https://github.com/MetricsGrimoire/CVSAnalY/pull/60/files#r9977111>
> .
>