comparison pkg/controllers/importqueue.go @ 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 fe93c48f76c9
comparison
equal deleted inserted replaced
2672:b997e1fd1d3d 2673:df2a31e8f257
222 if !a.hasCond { 222 if !a.hasCond {
223 a.stmt.WriteString(" TRUE ") 223 a.stmt.WriteString(" TRUE ")
224 } 224 }
225 225
226 l.stmt.WriteString(" ORDER BY enqueued DESC ") 226 l.stmt.WriteString(" ORDER BY enqueued DESC ")
227 a.stmt.WriteString(" ORDER BY enqueued ") 227 a.stmt.WriteString(" ORDER BY enqueued LIMIT 1")
228 b.stmt.WriteString(" ORDER BY enqueued ") 228 b.stmt.WriteString(" ORDER BY enqueued LIMIT 1")
229 229
230 if noBefore { 230 if noBefore {
231 b = nil 231 b = nil
232 } 232 }
233 if noAfter { 233 if noAfter {