summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDan Goodliffe <dan@randomdan.homeip.net>2015-11-15 22:30:28 +0000
committerDan Goodliffe <dan@randomdan.homeip.net>2015-11-15 22:30:28 +0000
commit52e3e428f405fb26fade6770c63e0cc5fa8b016d (patch)
tree12a1b02773909630acbba59b8a8ac8ad0f50fda8
parentTidy up and alias glibmm and libxml++ refs (diff)
downloadgentoobrowse-52e3e428f405fb26fade6770c63e0cc5fa8b016d.tar.bz2
gentoobrowse-52e3e428f405fb26fade6770c63e0cc5fa8b016d.tar.xz
gentoobrowse-52e3e428f405fb26fade6770c63e0cc5fa8b016d.zip
Handle duplication in source of mask datagentoobrowse-1.1.1.1
-rw-r--r--gentoobrowse/console/packagemasks.xml2
1 files changed, 1 insertions, 1 deletions
diff --git a/gentoobrowse/console/packagemasks.xml b/gentoobrowse/console/packagemasks.xml
index 261ee9b..fd03528 100644
--- a/gentoobrowse/console/packagemasks.xml
+++ b/gentoobrowse/console/packagemasks.xml
@@ -29,7 +29,7 @@
</project2:sqlmerge>
<project2:sqlmerge name="masks" datasource="postgres" targettable="ebuild_masks" useview="yes">
<sql>
- SELECT s.setno, ebuildfilter(REGEXP_SPLIT_TO_TABLE(tm.atoms, '\n')) ebuildid
+ SELECT DISTINCT s.setno, ebuildfilter(REGEXP_SPLIT_TO_TABLE(tm.atoms, '\n')) ebuildid
FROM tmpmasks tm, masksets s
WHERE tm.dateadded = s.dateadded
AND tm.n = s.n