Mercurial > dive4elements > river
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";