The following commit has been merged in the master branch:
commit bed966aee99cfc891d85d32cecd656d83ed9fc3d
Author: Andreas Tille <ti...@debian.org>
Date: Fri Dec 13 13:25:31 2013 +0100
Try to prevent duplicates (which works only partly - we really need to base
this on highest version number)
diff --git a/misc/sql/0-uncategorised.sh b/misc/sql/0-uncategorised.sh
index 7429f91..5ac16c8 100755
--- a/misc/sql/0-uncategorised.sh
+++ b/misc/sql/0-uncategorised.sh
@@ -39,8 +39,7 @@ SELECT t.source, s.bin FROM (
GROUP BY source
HAVING MAX(is_in_task) = 0
) t
- JOIN sources s ON t.source = s.source
- WHERE s.release = 'sid'
+ LEFT JOIN (SELECT DISTINCT source, bin FROM sources s WHERE release = 'sid')
s ON t.source = s.source
ORDER BY source
;
EOT
--
Static and dynamic websites for Debian Pure Blends
_______________________________________________
Blends-commit mailing list
Blends-commit@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/blends-commit
