Mercurial > dive4elements > river
changeset 9152:8d4e7e08dbc0
Fixed query semicolon
author | mschaefer |
---|---|
date | Thu, 14 Jun 2018 16:58:35 +0200 |
parents | 5be112fba832 |
children | 910334e2eadd |
files | backend/src/main/java/org/dive4elements/river/model/sinfo/CollisionAggregateValue.java |
diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/backend/src/main/java/org/dive4elements/river/model/sinfo/CollisionAggregateValue.java Thu Jun 14 15:12:25 2018 +0200 +++ b/backend/src/main/java/org/dive4elements/river/model/sinfo/CollisionAggregateValue.java Thu Jun 14 16:58:35 2018 +0200 @@ -106,7 +106,7 @@ + " FROM collision_values v INNER JOIN collision s ON v.collision_id=s.id" + " WHERE (collision_id=:parent)" + " AND (station BETWEEN (:kmLo - 0.0001) AND (:kmHi + 0.0001))" - + " GROUP BY FLOOR(station+0.4999);").addScalar("station", StandardBasicTypes.DOUBLE) + + " GROUP BY FLOOR(station+0.4999)").addScalar("station", StandardBasicTypes.DOUBLE) .addScalar("count", StandardBasicTypes.INTEGER).addScalar("date_min", StandardBasicTypes.DATE) .addScalar("date_max", StandardBasicTypes.DATE).addScalar("gauge_w", StandardBasicTypes.DOUBLE); query.setInteger("parent", parent.getId());