The following commit has been merged in the master branch:
commit 9129741b4505ec94d1e452f8d04eafeccef23e5a
Author: Andreas Tille <[email protected]>
Date: Mon Sep 9 13:28:37 2013 +0200
Now we have duplicated entries of source package if a binary package is in
more than one task but the dependency relation per task is correct. Needs to
be verified: If two binary packages from one source package are inside one
task we need to make sure that 'depends' will be prefered.
diff --git a/misc/sql/bugs.sh b/misc/sql/bugs.sh
index 413bf92..794ecf8 100755
--- a/misc/sql/bugs.sh
+++ b/misc/sql/bugs.sh
@@ -10,7 +10,7 @@ fi
psql udd > $1_buggy_packages.out <<EOT
SELECT distinct sources.source, tasks.tasks, CASE WHEN dependency = 'd'
AND component = 'main' THEN 'depends' ELSE 'suggests' END AS status, homepage,
vcs_browser, maintainer
FROM (
- SELECT s.source, b.dependency, b.component, s.homepage,
s.vcs_browser, s.maintainer, s.version, row_number() OVER (PARTITION BY
s.source ORDER BY s.version DESC)
+ SELECT s.source, b.component, s.homepage, s.vcs_browser,
s.maintainer, s.version, row_number() OVER (PARTITION BY s.source ORDER BY
s.version DESC)
FROM blends_dependencies b
JOIN packages p ON p.package = b.package
JOIN bugs bu ON bu.source = p.source
@@ -19,15 +19,14 @@ psql udd > $1_buggy_packages.out <<EOT
GROUP BY s.source, b.dependency, b.component, s.homepage,
s.vcs_browser, s.maintainer, s.version
) sources
LEFT OUTER JOIN (
- SELECT source, array_agg(task) AS tasks FROM (
- SELECT DISTINCT p.source, b.task
+ SELECT DISTINCT source, task AS tasks, dependency FROM (
+ SELECT DISTINCT p.source, b.task, dependency
FROM packages p
JOIN releases r ON p.release = r.release
JOIN blends_dependencies b ON b.package = p.package
JOIN sources s ON p.source = s.source AND p.release = s.release
WHERE b.blend = '$1'
) tmp
- GROUP BY source
) tasks ON sources.source = tasks.source
WHERE row_number = 1
ORDER BY source;
--
Static and dynamic websites for Debian Pure Blends
_______________________________________________
Blends-commit mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/blends-commit
