# HG changeset patch
# User Ingo Weinzierl <ingo.weinzierl@intevation.de>
# Date 1300897211 0
# Node ID 199f0e553e3a822787a7c42d9d35c8093af74f74
# Parent  d7042094f7b7da7865e3c07117769063c68c7607
Bugfix: Repaired broken SQL statement.

artifacts/trunk@1550 c6561f87-3c4e-4783-a992-168aeb5c3f6f

diff -r d7042094f7b7 -r 199f0e553e3a ChangeLog
--- a/ChangeLog	Wed Mar 23 12:08:21 2011 +0000
+++ b/ChangeLog	Wed Mar 23 16:20:11 2011 +0000
@@ -1,3 +1,9 @@
+2011-03-23  Ingo Weinzierl <ingo@intevation.de>
+
+	* artifact-database/src/main/resources/sql/org-h2-driver.properties,
+	  artifact-database/src/main/resources/sql/org-postgresql-driver.properties:
+	  Bugfix: Repaired broken SQL statement.
+
 2011-03-23  Ingo Weinzierl <ingo@intevation.de>
 
 	* artifacts-common/src/main/java/de/intevation/artifacts/common/utils/ClientProtocolUtils.java:
diff -r d7042094f7b7 -r 199f0e553e3a artifact-database/src/main/resources/sql/org-h2-driver.properties
--- a/artifact-database/src/main/resources/sql/org-h2-driver.properties	Wed Mar 23 12:08:21 2011 +0000
+++ b/artifact-database/src/main/resources/sql/org-h2-driver.properties	Wed Mar 23 16:20:11 2011 +0000
@@ -81,7 +81,7 @@
 collection.items.list.gid= \
     SELECT a.gid, ci.attribute FROM collection_items ci \
     INNER JOIN artifacts a ON ci.artifact_id = a.id \
-    WHERE ci.id IN (SELECT id FROM collections WHERE gid = ?)
+    WHERE ci.collection_id IN (SELECT id FROM collections WHERE gid = ?)
 
 # COLLECTIONS
 collections.touch.by.gid =\
diff -r d7042094f7b7 -r 199f0e553e3a artifact-database/src/main/resources/sql/org-postgresql-driver.properties
--- a/artifact-database/src/main/resources/sql/org-postgresql-driver.properties	Wed Mar 23 12:08:21 2011 +0000
+++ b/artifact-database/src/main/resources/sql/org-postgresql-driver.properties	Wed Mar 23 16:20:11 2011 +0000
@@ -81,7 +81,7 @@
 collection.items.list.gid= \
     SELECT a.gid, ci.attribute FROM collection_items ci \
     INNER JOIN artifacts a ON ci.artifact_id = a.id \
-    WHERE ci.id IN (SELECT id FROM collections WHERE gid = ?::uuid)
+    WHERE ci.collection_id IN (SELECT id FROM collections WHERE gid = ?::uuid)
 
 # COLLECTIONS
 collections.touch.by.gid =\