Login | Register
My pages Projects Community openCollabNet

Discussions > issues > [Issue 10] New - Some revisions are never found no matter the query.

kamikaze-qscm
Discussion topic

Back to topic list

[Issue 10] New - Some revisions are never found no matter the query.

Author jduprey
Full name John Duprey
Date 2004-09-22 22:30:39 PDT
Message http://kamikaze-qscm​.tigris.org/issues/s​how_bug.cgi?id=10
                  Issue #:|10
                  Summary:|Some revisions are never found no matter the query.
                Component:|kamikaze-qscm
                  Version:|0.1 Initial Release
                 Platform:|All
               OS/Version:|All
                      URL:|
                   Status:|NEW
        Status whiteboard:|
                 Keywords:|
               Resolution:|
               Issue type:|DEFECT
                 Priority:|P3
             Subcomponent:|DB
              Assigned to:|jduprey
              Reported by:|jduprey






------- Additional comments from jduprey at tigris dot org Wed Sep 22 22:30:37 -0700 2004 -------
Some revisions are never found no matter the query. There is a bug in the SQL select in which the join
with the resources table will not reveal any revisions that did not affect any files. (Kamikaze does not
currently record changes to directories...) I believe this to be the fix to the SQL select:

LEFT JOIN resource on revision.id = resource.rev_id

e.g.

SELECT revision.date, author.user, repository.alias, revision.rev,
revision.rep_id, resource.resource, resource.action, revision.log
SELECT revision.date, author.user, repository.alias, revision.rev,
revision.rep_id, resource.resource, resource.action, revision.log
FROM author, repository, revision LEFT JOIN resource on revision.id =
resource.rev_id
 WHERE repository.id = revision.rep_id AND revision.author_id = author.id
AND (revision.rep_id='4')
AND (resource.action='A' OR action='M' OR resource.action='D' OR
resource.action IS NULL)
 ORDER BY repository.alias, revision.rev DESC, resource.action,
resource.resource

-as per this information: http://dev.mysql.com​/doc/mysql/en/JOIN.h​tml

--------------------​--------------------​--------------------​---------
To unsubscribe, e-mail: issues-unsubscribe@k​amikaze-qscm.tigris.​org
For additional commands, e-mail: issues-help@kamikaze​-qscm.tigris.org

« Previous message in topic | 1 of 1 | Next message in topic »

Messages

Show all messages in topic

[Issue 10] New - Some revisions are never found no matter the query. jduprey John Duprey 2004-09-22 22:30:39 PDT
Messages per page: