Mercurial > dive4elements > river
view etl/src/main/resources/sql/flys-oracle-jdbc-oracledriver.properties @ 6061:e9a76ffa0f9a
Use maxOverlap to get the correct gauge for the MainValues
Previously just the first matching gauge was taken even if it's
range ended with the minimum value. This code is clearly intended
to get one gauge for one range so the best match should be taken.
| author | Andre Heinecke <aheinecke@intevation.de> |
|---|---|
| date | Wed, 22 May 2013 18:10:48 +0200 |
| parents | 5aa05a7a34b7 |
| children |
line wrap: on
line source
next.gauge.id = \ SELECT GAUGES_ID_SEQ.NEXTVAL AS gauge_id FROM DUAL next.timeinterval.id = \ SELECT TIME_INTERVALS_ID_SEQ.NEXTVAL AS time_interval_id FROM DUAL next.discharge.id = \ SELECT DISCHARGE_TABLES_ID_SEQ.NEXTVAL AS discharge_table_id FROM DUAL next.discharge.table.values.id = \ SELECT DISCHARGE_TABLE_VALUES_ID_SEQ.NEXTVAL AS discharge_table_values_id FROM DUAL