diff options
| author | Andreas Steffen <andreas.steffen@strongswan.org> | 2010-07-12 22:44:27 +0200 |
|---|---|---|
| committer | Andreas Steffen <andreas.steffen@strongswan.org> | 2010-07-12 22:44:27 +0200 |
| commit | c1918dc28f0d264c2f946bf26752a160c3aabe3d (patch) | |
| tree | f622bd8c3e8caebd2bfa448d0542706c399dfb2e | |
| parent | c13a4b40303eb0ae63bac88fe7a8420893898017 (diff) | |
| download | strongswan-c1918dc28f0d264c2f946bf26752a160c3aabe3d.tar.bz2 strongswan-c1918dc28f0d264c2f946bf26752a160c3aabe3d.tar.xz | |
we need some ordering
| -rw-r--r-- | src/libhydra/plugins/attr_sql/pool_attributes.c | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/libhydra/plugins/attr_sql/pool_attributes.c b/src/libhydra/plugins/attr_sql/pool_attributes.c index 7e3cb8607..5f7afdfcd 100644 --- a/src/libhydra/plugins/attr_sql/pool_attributes.c +++ b/src/libhydra/plugins/attr_sql/pool_attributes.c @@ -586,7 +586,9 @@ void status_attr(bool hexout) "LEFT OUTER JOIN identities " "ON attributes.identity = identities.id " "LEFT OUTER JOIN attribute_pools " - "ON attributes.pool = attribute_pools.id", + "ON attributes.pool = attribute_pools.id " + "ORDER BY attributes.type, attribute_pools.name, " + "identities.type, identities.data, attributes.value", DB_INT, DB_TEXT, DB_INT, DB_BLOB, DB_BLOB); if (enumerator) { |