summaryrefslogtreecommitdiff
path: root/gentoobrowse-api/service/sql
diff options
context:
space:
mode:
authorDan Goodliffe <daniel.goodliffe@pressassociation.com>2016-11-18 15:08:52 +0000
committerDan Goodliffe <daniel.goodliffe@pressassociation.com>2016-11-18 15:08:52 +0000
commit8135220aea07459c6d6d5dabe143fc6004e28c54 (patch)
tree5c0eb03b1eb31cfbe03dbdac388442acc7883b84 /gentoobrowse-api/service/sql
parentAdd support for getting packaged details tracked by a user (diff)
downloadgentoobrowse-api-8135220aea07459c6d6d5dabe143fc6004e28c54.tar.bz2
gentoobrowse-api-8135220aea07459c6d6d5dabe143fc6004e28c54.tar.xz
gentoobrowse-api-8135220aea07459c6d6d5dabe143fc6004e28c54.zip
Fix use flag ordering to be not locale sensitive and resulting changes in test case
Diffstat (limited to 'gentoobrowse-api/service/sql')
-rw-r--r--gentoobrowse-api/service/sql/portage/getPackageUses.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/gentoobrowse-api/service/sql/portage/getPackageUses.sql b/gentoobrowse-api/service/sql/portage/getPackageUses.sql
index 5e74e35..0b06b20 100644
--- a/gentoobrowse-api/service/sql/portage/getPackageUses.sql
+++ b/gentoobrowse-api/service/sql/portage/getPackageUses.sql
@@ -15,4 +15,4 @@ FROM gentoobrowse.ebuilds e
AND eu.use = ugs.name || '_' || ugg.use
WHERE e.packageid = ?
GROUP BY eu.use, ul.use, ul.packageid, ug.use, ugs.name, ugg.usegroupid, ugg.use, ugg.description
-ORDER BY ugs.name nulls first, eu.use
+ORDER BY ugs.name nulls first, LTRIM(COALESCE(ugg.use, eu.use), '+')