Mercurial > dive4elements > framework
changeset 213:199f0e553e3a
Bugfix: Repaired broken SQL statement.
artifacts/trunk@1550 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Wed, 23 Mar 2011 16:20:11 +0000 |
| parents | d7042094f7b7 |
| children | fc435da7f471 |
| files | ChangeLog artifact-database/src/main/resources/sql/org-h2-driver.properties artifact-database/src/main/resources/sql/org-postgresql-driver.properties |
| diffstat | 3 files changed, 8 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- 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:
--- 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 =\
--- 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 =\