@@ -231,8 +231,8 @@ END
SELECT url.val AS uval,
rev.val AS rval,
- url.job AS job,
- ${\ other_revision_job_suffix('url.job','url.use',' ') } AS othrev,
+ rev.job AS job,
+ ${\ other_revision_job_suffix('rev.job','rev.use',' ') } AS othrev,
url.name AS longname
FROM tmp_build_info AS rev
@@ -241,8 +241,8 @@ END
WHERE (rev.name LIKE E'built\\_revision\\_%' OR
rev.name LIKE E'revision\\_%')
AND url.name LIKE E'tree\\_%'
- AND rev.use = url.use
- AND rev.job = url.job
+ AND url.use = rev.use
+ AND url.job = rev.job
AND (rev.name = 'built_revision_' || substr(url.name,6) OR
rev.name = 'revision_' || substr(url.name,6))
This query is going to turn into two variants, one of which doesn't have the url join. In the output, prefer to refer to fields from job. They are constrained to be equal (and they are not null) so this has no functional change. Also swap the conditions over for clarity. No functional change. Signed-off-by: Ian Jackson <ian.jackson@eu.citrix.com> --- cs-bisection-step | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-)