From 40a3214b5028cc3208ea38d03bf0199e0f64d5c9 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Felix=20D=C3=B6rre?= Date: Tue, 4 Jul 2017 21:53:22 +0200 Subject: [PATCH] fix: use deterministic order of certificates Change-Id: Ibddd1a9dad32107981d162e44263cbd486a224d7 --- src/club/wpia/gigi/dbObjects/CertificateOwner.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/club/wpia/gigi/dbObjects/CertificateOwner.java b/src/club/wpia/gigi/dbObjects/CertificateOwner.java index 1783394c..1c7cdb4a 100644 --- a/src/club/wpia/gigi/dbObjects/CertificateOwner.java +++ b/src/club/wpia/gigi/dbObjects/CertificateOwner.java @@ -83,7 +83,7 @@ public abstract class CertificateOwner implements IdCachable, Serializable { } public Certificate[] getCertificates(boolean includeRevoked) { - try (GigiPreparedStatement ps = new GigiPreparedStatement(includeRevoked ? "SELECT id FROM certs WHERE memid=?" : "SELECT id FROM certs WHERE memid=? AND revoked IS NULL")) { + try (GigiPreparedStatement ps = new GigiPreparedStatement(includeRevoked ? "SELECT id FROM certs WHERE memid=? ORDER BY id DESC" : "SELECT id FROM certs WHERE memid=? AND revoked IS NULL ORDER BY id DESC")) { ps.setInt(1, getId()); GigiResultSet rs = ps.executeQuery(); -- 2.39.2