Something like this rune can be useful for comparing testids of different flights.
Signed-off-by: Ian Jackson <ian.jack...@eu.citrix.com> --- NOTES.flight-comparison | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 NOTES.flight-comparison diff --git a/NOTES.flight-comparison b/NOTES.flight-comparison new file mode 100644 index 0000000..ea290f8 --- /dev/null +++ b/NOTES.flight-comparison @@ -0,0 +1,22 @@ +select + l.job, l.stepno, l.testid, l.status, + r.job, r.stepno, r.testid, r.status +from + (select * from steps where flight=110909) l + full outer join + (select * from steps where flight=110951) r +on + regexp_replace(l.testid,'\([0-9]*\)$','') = + regexp_replace(r.testid,'\([0-9]*\)$','') + and + l.job=r.job + and + (l.stepno=r.stepno or l.stepno+1=r.stepno) +where + coalesce(r.testid,'') != 'syslog-server' + and + (l.testid is null or r.testid is null or l.status!=r.status) +order by + coalesce(l.job, r.job), + l.stepno, r.stepno, + l.testid, r.testid; -- 2.1.4 _______________________________________________ Xen-devel mailing list Xen-devel@lists.xen.org https://lists.xen.org/xen-devel
