changeset 6622:718b0822374d

CrossSection: Uppercase sql keywords in query.
author Felix Wolfsteller <felix.wolfsteller@intevation.de>
date Mon, 22 Jul 2013 11:07:14 +0200
parents 7e697c6eb379
children 3999162f474f
files backend/src/main/java/org/dive4elements/river/model/CrossSection.java
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/backend/src/main/java/org/dive4elements/river/model/CrossSection.java	Mon Jul 22 11:03:41 2013 +0200
+++ b/backend/src/main/java/org/dive4elements/river/model/CrossSection.java	Mon Jul 22 11:07:14 2013 +0200
@@ -66,8 +66,8 @@
             " (SELECT id FROM cross_sections WHERE river_id = :river_id) " +
             "  GROUP BY cross_section_id" +
         ") cs_ranges " +
-        "JOIN cross_sections CS on cs_ranges.cross_section_id = cs.id " +
-        "LEFT OUTER JOIN time_intervals on cs.time_interval_id = time_intervals.id " +
+        "JOIN cross_sections cs ON cs_ranges.cross_section_id = cs.id " +
+        "LEFT OUTER JOIN time_intervals ON cs.time_interval_id = time_intervals.id " +
         "WHERE :km BETWEEN minkm AND maxkm " +
         "ORDER BY stop_time desc, start_time asc, :km - minkm";
     // Order by time interval missing.

http://dive4elements.wald.intevation.org