# HG changeset patch
# User Felix Wolfsteller <felix.wolfsteller@intevation.de>
# Date 1374484034 -7200
# Node ID 718b0822374d87bdd6ede2c17154116b0eeedd58
# Parent  7e697c6eb3794aaf7c7316829954e8d6129799b9
CrossSection: Uppercase sql keywords in query.

diff -r 7e697c6eb379 -r 718b0822374d backend/src/main/java/org/dive4elements/river/model/CrossSection.java
--- 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.