+2013-10-25 Ryosuke Niwa <rniwa@webkit.org>
+
+ Build fix. The query results weren't sorted by the latest commit time,
+ yielding wrong set of tests to be listed in the builder pane.
+
+ * public/include/test-results.php:
+
2013-10-25 Ryosuke Niwa <rniwa@webkit.org>
Links in new flakiness dashboard could benefit from tooltips
$number_of_days = self::MAXIMUM_NUMBER_OF_DAYS;
$all_results = $this->db->query(
"SELECT results.*, builds.* FROM results
- JOIN (SELECT builds.*, array_agg((build_revisions.repository, build_revisions.value, build_revisions.time)) AS revisions
+ JOIN (SELECT builds.*, array_agg((build_revisions.repository, build_revisions.value, build_revisions.time)) AS revisions,
+ max(build_revisions.time) AS latest_revision_time
FROM builds, build_revisions
WHERE build_revisions.build = builds.id AND builds.builder = $1 AND builds.start_time > now() - interval '$number_of_days days'
- GROUP BY builds.id
- ORDER BY max(build_revisions.time) DESC) as builds ON results.build = builds.id
- ORDER BY results.test", array($this->builder_id));
+ GROUP BY builds.id) as builds ON results.build = builds.id
+ ORDER BY results.test, latest_revision_time DESC", array($this->builder_id));
if (!$all_results)
return FALSE;