diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2015-11-15 22:30:28 +0000 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2015-11-15 22:30:28 +0000 |
| commit | 52e3e428f405fb26fade6770c63e0cc5fa8b016d (patch) | |
| tree | 12a1b02773909630acbba59b8a8ac8ad0f50fda8 | |
| parent | Tidy up and alias glibmm and libxml++ refs (diff) | |
| download | gentoobrowse-1.1.1.1.tar.bz2 gentoobrowse-1.1.1.1.tar.xz gentoobrowse-1.1.1.1.zip | |
Handle duplication in source of mask datagentoobrowse-1.1.1.1
| -rw-r--r-- | gentoobrowse/console/packagemasks.xml | 2 |
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 |