changeset 6621:7e697c6eb379

CrossSection: Improve SQl compat of statement.
author Felix Wolfsteller <felix.wolfsteller@intevation.de>
date Mon, 22 Jul 2013 11:03:41 +0200
parents 0bc7d3546470
children 718b0822374d
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	Fri Jul 19 13:52:35 2013 +0200
+++ b/backend/src/main/java/org/dive4elements/river/model/CrossSection.java	Mon Jul 22 11:03:41 2013 +0200
@@ -65,8 +65,8 @@
             "WHERE cross_section_id IN " +
             " (SELECT id FROM cross_sections WHERE river_id = :river_id) " +
             "  GROUP BY cross_section_id" +
-        ") AS cs_ranges " +
-        "JOIN cross_sections as CS on cs_ranges.cross_section_id = cs.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 " +
         "WHERE :km BETWEEN minkm AND maxkm " +
         "ORDER BY stop_time desc, start_time asc, :km - minkm";

http://dive4elements.wald.intevation.org