Signed-off-by: Ian Jackson <[email protected]>
---
Osstest/HostDB/Executive.pm | 7 +++++--
1 file changed, 5 insertions(+), 2 deletions(-)
diff --git a/Osstest/HostDB/Executive.pm b/Osstest/HostDB/Executive.pm
index 3e5eca2..300178b 100644
--- a/Osstest/HostDB/Executive.pm
+++ b/Osstest/HostDB/Executive.pm
@@ -76,10 +76,13 @@ SELECT DISTINCT hostflag
FROM hostflags h0
WHERE EXISTS (
SELECT *
- FROM hostflags h1, hostflags h2
- WHERE h0.hostname = h1.hostname AND h1.hostname = h2.hostname
+ FROM hostflags h1, hostflags h2, hostflags h3
+ WHERE h0.hostname = h1.hostname
+ AND h1.hostname = h2.hostname
+ AND h2.hostname = h3.hostname
AND h1.hostflag = ?
AND h2.hostflag = ?
+ AND h3.hostflag = 'purpose-test'
)
AND hostflag like 'platform-%';
END
--
2.11.0
_______________________________________________
Xen-devel mailing list
[email protected]
https://lists.xen.org/xen-devel
