we need some ordering
authorAndreas Steffen <andreas.steffen@strongswan.org>
Mon, 12 Jul 2010 20:44:27 +0000 (22:44 +0200)
committerAndreas Steffen <andreas.steffen@strongswan.org>
Mon, 12 Jul 2010 20:44:27 +0000 (22:44 +0200)
src/libhydra/plugins/attr_sql/pool_attributes.c

index 7e3cb86..5f7afdf 100644 (file)
@@ -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)
        {