changeset 2673:df2a31e8f257 import-overview-rework

Re-added LIMIT 1 hint to prev/next SELECTs.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 14 Mar 2019 17:42:15 +0100
parents b997e1fd1d3d
children 43e1abaf9ee3
files pkg/controllers/importqueue.go
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/controllers/importqueue.go	Thu Mar 14 17:29:36 2019 +0100
+++ b/pkg/controllers/importqueue.go	Thu Mar 14 17:42:15 2019 +0100
@@ -224,8 +224,8 @@
 	}
 
 	l.stmt.WriteString(" ORDER BY enqueued DESC ")
-	a.stmt.WriteString(" ORDER BY enqueued ")
-	b.stmt.WriteString(" ORDER BY enqueued ")
+	a.stmt.WriteString(" ORDER BY enqueued LIMIT 1")
+	b.stmt.WriteString(" ORDER BY enqueued LIMIT 1")
 
 	if noBefore {
 		b = nil