# HG changeset patch
# User Ingo Weinzierl <ingo.weinzierl@intevation.de>
# Date 1299666296 0
# Node ID 94654cbf8db2779ceb4d413e5be8c7b533ca4dca
# Parent  171b6200d26dc5d8d0e7314331d691a50f0e21d8
Fixed a typo in the sql statements.

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

diff -r 171b6200d26d -r 94654cbf8db2 ChangeLog
--- a/ChangeLog	Tue Mar 08 10:38:14 2011 +0000
+++ b/ChangeLog	Wed Mar 09 10:24:56 2011 +0000
@@ -1,3 +1,9 @@
+2011-03-09  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:
+	  Fixed a typo.
+
 2011-03-08  Ingo Weinzierl <ingo@intevation.de>
 
 	* artifact-database/src/main/java/de/intevation/artifactdatabase/ArtifactDatabaseImpl.java,
diff -r 171b6200d26d -r 94654cbf8db2 artifact-database/src/main/resources/sql/org-h2-driver.properties
--- a/artifact-database/src/main/resources/sql/org-h2-driver.properties	Tue Mar 08 10:38:14 2011 +0000
+++ b/artifact-database/src/main/resources/sql/org-h2-driver.properties	Wed Mar 09 10:24:56 2011 +0000
@@ -11,7 +11,7 @@
 
 artifacts.outdated=SELECT id, factory, data FROM artifacts WHERE ttl IS NOT NULL \
     AND DATEDIFF('MILLISECOND', last_access, CURRENT_TIMESTAMP) > ttl \
-    AND id NOT IN (SELECT UNIQUE artifact_id FROM collection_items) \
+    AND id NOT IN (SELECT DISTINCT artifact_id FROM collection_items) \
     LIMIT 50
 
 artifacts.select.gid=SELECT id, last_access, ttl, factory, data FROM artifacts WHERE gid = ?
diff -r 171b6200d26d -r 94654cbf8db2 artifact-database/src/main/resources/sql/org-postgresql-driver.properties
--- a/artifact-database/src/main/resources/sql/org-postgresql-driver.properties	Tue Mar 08 10:38:14 2011 +0000
+++ b/artifact-database/src/main/resources/sql/org-postgresql-driver.properties	Wed Mar 09 10:24:56 2011 +0000
@@ -11,7 +11,7 @@
 
 artifacts.outdated=SELECT id, factory, data FROM artifacts WHERE ttl IS NOT NULL \
     AND CURRENT_TIMESTAMP - last_access > (ttl || ' microseconds')::interval \
-    AND id NOT IN (SELECT UNIQUE artifact_id FROM collection_items) \
+    AND id NOT IN (SELECT DISTINCT artifact_id FROM collection_items) \
     LIMIT 50
 
 artifacts.select.gid=SELECT id, last_access, ttl, factory, data FROM artifacts WHERE gid = ?::uuid