summaryrefslogtreecommitdiff
path: root/multiarchanalyze.sql
diff options
context:
space:
mode:
Diffstat (limited to 'multiarchanalyze.sql')
-rw-r--r--multiarchanalyze.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/multiarchanalyze.sql b/multiarchanalyze.sql
index b94a367..79d62c3 100644
--- a/multiarchanalyze.sql
+++ b/multiarchanalyze.sql
@@ -158,6 +158,16 @@ CREATE VIEW archall_candidate AS
SELECT 1 FROM content AS c5
WHERE c5.pid = p3.id
AND c5.filename = c2.filename))
+ AND NOT EXISTS (
+ SELECT 1
+ FROM package AS p4, package AS p5, provides AS r1
+ WHERE p4.name = p1.name
+ AND p5.name = p1.name
+ AND r1.pid = p4.id
+ AND NOT EXISTS (
+ SELECT 1 FROM provides AS r2
+ WHERE r2.pid = p5.id
+ AND r1.provided = r2.provided))
AND p1.hasarchdeps = 0;
/* Packages that coud be marked Multi-Arch:same, because they