changeset 9641:f96be528ee35

Removed AS for table aliases in infrastructure queries to avoid Oracle problem
author mschaefer
date Mon, 02 Dec 2019 09:24:38 +0100 (2019-12-02)
parents 68d7b09a47b7
children 3987fef69143
files artifacts/doc/conf/meta-data.xml
diffstat 1 files changed, 16 insertions(+), 16 deletions(-) [+]
line wrap: on
line diff
--- a/artifacts/doc/conf/meta-data.xml	Tue Nov 12 10:07:09 2019 +0100
+++ b/artifacts/doc/conf/meta-data.xml	Mon Dec 02 09:24:38 2019 +0100
@@ -1462,10 +1462,10 @@
       <dc:statement>
           SELECT s.id, MIN(s.filename) AS filename, MIN(s.group_id) AS group_id, MIN(g.name) AS group_label, 
             MIN(s.annotation_type_id) AS type_id, MIN(t.name) AS type_label
-          FROM (((infrastructure AS s INNER JOIN infrastructure_values AS v ON v.infrastructure_id = s.id)
-            INNER JOIN annotation_types AS g ON s.group_id = g.id)
-            INNER JOIN annotation_types AS t ON s.annotation_type_id = t.id)
-            INNER JOIN attributes AS rs ON v.attribute_id = rs.id
+          FROM (((infrastructure s INNER JOIN infrastructure_values v ON v.infrastructure_id = s.id)
+            INNER JOIN annotation_types g ON s.group_id = g.id)
+            INNER JOIN annotation_types t ON s.annotation_type_id = t.id)
+            INNER JOIN attributes rs ON v.attribute_id = rs.id
           WHERE (s.river_id = ${river_id})
             AND (v.station BETWEEN ${fromkm}-0.0001 AND ${tokm}+0.0001)
             ${infra_rs_clause}
@@ -1478,10 +1478,10 @@
       <dc:statement>
           SELECT s.id, MIN(s.filename) AS filename, MIN(s.group_id) AS group_id, MIN(g.name) AS group_label, 
             MIN(s.annotation_type_id) AS type_id, MIN(t.name) AS type_label
-          FROM (((infrastructure AS s INNER JOIN infrastructure_values AS v ON v.infrastructure_id = s.id)
-            INNER JOIN annotation_types AS g ON s.group_id = g.id)
-            INNER JOIN annotation_types AS t ON s.annotation_type_id = t.id)
-            INNER JOIN attributes AS rs ON v.attribute_id = rs.id
+          FROM (((infrastructure s INNER JOIN infrastructure_values v ON v.infrastructure_id = s.id)
+            INNER JOIN annotation_types g ON s.group_id = g.id)
+            INNER JOIN annotation_types t ON s.annotation_type_id = t.id)
+            INNER JOIN attributes rs ON v.attribute_id = rs.id
           WHERE (s.river_id = ${river_id})
             AND (v.station BETWEEN ${fromkm}-0.0001 AND ${tokm}+0.0001)
             AND (lower(rs.value) = 'links')
@@ -1494,10 +1494,10 @@
       <dc:statement>
           SELECT s.id, MIN(s.filename) AS filename, MIN(s.group_id) AS group_id, MIN(g.name) AS group_label, 
             MIN(s.annotation_type_id) AS type_id, MIN(t.name) AS type_label
-          FROM (((infrastructure AS s INNER JOIN infrastructure_values AS v ON v.infrastructure_id = s.id)
-            INNER JOIN annotation_types AS g ON s.group_id = g.id)
-            INNER JOIN annotation_types AS t ON s.annotation_type_id = t.id)
-            INNER JOIN attributes AS rs ON v.attribute_id = rs.id
+          FROM (((infrastructure s INNER JOIN infrastructure_values v ON v.infrastructure_id = s.id)
+            INNER JOIN annotation_types g ON s.group_id = g.id)
+            INNER JOIN annotation_types t ON s.annotation_type_id = t.id)
+            INNER JOIN attributes rs ON v.attribute_id = rs.id
           WHERE (s.river_id = ${river_id})
             AND (v.station BETWEEN ${fromkm}-0.0001 AND ${tokm}+0.0001)
             AND (lower(rs.value) = 'rechts')
@@ -1510,10 +1510,10 @@
       <dc:statement>
           SELECT s.id, MIN(s.filename) AS filename, MIN(s.group_id) AS group_id, MIN(g.name) AS group_label, 
             MIN(s.annotation_type_id) AS type_id, MIN(t.name) AS type_label
-          FROM (((infrastructure AS s INNER JOIN infrastructure_values AS v ON v.infrastructure_id = s.id)
-            INNER JOIN annotation_types AS g ON s.group_id = g.id)
-            INNER JOIN annotation_types AS t ON s.annotation_type_id = t.id)
-            INNER JOIN attributes AS rs ON v.attribute_id = rs.id
+          FROM (((infrastructure s INNER JOIN infrastructure_values v ON v.infrastructure_id = s.id)
+            INNER JOIN annotation_types g ON s.group_id = g.id)
+            INNER JOIN annotation_types t ON s.annotation_type_id = t.id)
+            INNER JOIN attributes rs ON v.attribute_id = rs.id
           WHERE (s.river_id = ${river_id})
             AND (v.station BETWEEN ${fromkm}-0.0001 AND ${tokm}+0.0001)
           GROUP BY s.id

http://dive4elements.wald.intevation.org