| commit | bd9039fd4c32d2f63158014cef411c7dd66995d9 | [log] [tgz] |
|---|---|---|
| author | Abhishek Patel <abhishek.a.patel@ericsson.com> | Fri Jul 13 16:13:15 2018 -0400 |
| committer | Abhishek Patel <abhishek.a.patel@ericsson.com> | Fri Jul 13 16:13:15 2018 -0400 |
| tree | 20b4925b30b27a153087f04d5cd6b2b1d5d9f487 | |
| parent | 61b0e34717f166ddd6856a7303d5fc4f484ad46d [diff] |
SQLQueryMaker: add order-by clause to the query Set the SQL query with an order-by clause to fix the otherwise inconsistent result. Change-Id: Id950a31573b0411cd4865131ba50fab07f2f6f62
diff --git a/src/main/java/com/ericsson/gerrit/plugins/eventslog/sql/SQLQueryMaker.java b/src/main/java/com/ericsson/gerrit/plugins/eventslog/sql/SQLQueryMaker.java index 53e406c..6e60aed 100644 --- a/src/main/java/com/ericsson/gerrit/plugins/eventslog/sql/SQLQueryMaker.java +++ b/src/main/java/com/ericsson/gerrit/plugins/eventslog/sql/SQLQueryMaker.java
@@ -59,7 +59,7 @@ throw new MalformedQueryException(e); } return String.format( - "SELECT * FROM %s WHERE %s BETWEEN '%s' and '%s' LIMIT %d", + "SELECT * FROM %s WHERE %s BETWEEN '%s' and '%s' ORDER BY date_created LIMIT %d", TABLE_NAME, DATE_ENTRY, dates[0], dates[1], returnLimit); }