Mercurial > dive4elements > river
diff backend/src/main/java/org/dive4elements/river/model/sinfo/CollisionAggregateValue.java @ 9152:8d4e7e08dbc0
Fixed query semicolon
author | mschaefer |
---|---|
date | Thu, 14 Jun 2018 16:58:35 +0200 |
parents | 623b51bf03d7 |
children | 38e8febd11b6 |
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());