grahamc/hydra2 - Change K4C6DNSM7ARO6I24TEXIAHJ4XM7P3MXTXEPXKGDEAKALBL4RJQVAC

changed queries for compatibility with postgresql

Created by Rob Vermaas on April 28, 2009

K4C6DNSM7ARO6I24TEXIAHJ4XM7P3MXTXEPXKGDEAKALBL4RJQVAC

Dependencies

In channels

main

Change contents

Replacement in src/lib/Hydra/Schema/Builds.pm at line 117 [4.5202]

B:BD[3.2536] → [2.0:465]

    makeSource('JobStatus' . $name, "select * from (select project, jobset, job, system, max(id) id from Builds where finished = 1 $constraint group by project, jobset, job, system) natural join Builds");
    makeSource('LatestSucceeded' . $name, "select * from (select project, jobset, job, system, max(id) id from Builds natural join BuildResultInfo where finished = 1 and buildStatus = 0 $constraint group by project, jobset, job, system) natural join Builds");

[3.2536]

[3.3029]

    makeSource('JobStatus' . $name, "select * from (select project, jobset, job, system, max(id) as id from Builds where finished = 1 $constraint group by project, jobset, job, system) as a natural join Builds");
    makeSource('LatestSucceeded' . $name, "select * from (select project, jobset, job, system, max(id) as id from Builds natural join BuildResultInfo where finished = 1 and buildStatus = 0 $constraint group by project, jobset, job, system) as a natural join Builds");