# HG changeset patch
# User Ingo Weinzierl <ingo.weinzierl@intevation.de>
# Date 1319183133 0
# Node ID 2d525562fae9bb042b80ad07209f27ef610b8398
# Parent  7514fe89efef24875d9074c6bf9274523f2bac5a
Bugfix: added missing bracket to a H2 sql statement.

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

diff -r 7514fe89efef -r 2d525562fae9 ChangeLog
--- a/ChangeLog	Thu Oct 20 10:13:46 2011 +0000
+++ b/ChangeLog	Fri Oct 21 07:45:33 2011 +0000
@@ -1,3 +1,8 @@
+2011-10-21  Ingo Weinzierl <ingo@intevation.de>
+
+	* artifact-database/src/main/resources/sql/org-h2-driver.properties:
+	  Bugfix: added missing bracket to an sql statement.
+
 2011-10-20	Sascha L. Teichmann	<sascha.teichmann@intevation.de>
 
 	* artifact-database/src/main/java/de/intevation/artifactdatabase/Backend.java(getMasterArtifact):
diff -r 7514fe89efef -r 2d525562fae9 artifact-database/src/main/resources/sql/org-h2-driver.properties
--- a/artifact-database/src/main/resources/sql/org-h2-driver.properties	Thu Oct 20 10:13:46 2011 +0000
+++ b/artifact-database/src/main/resources/sql/org-h2-driver.properties	Fri Oct 21 07:45:33 2011 +0000
@@ -168,7 +168,7 @@
 outdate.artifacts.collection=UPDATE artifacts \
     SET last_access = DATEADD('MILLISECOND', -2, CURRENT_TIMESTAMP), ttl = 1 \
     WHERE id IN \
-    SELECT artifact_id FROM collection_items \
+    (SELECT artifact_id FROM collection_items \
         WHERE collection_id = ? AND \
         artifact_id NOT IN (SELECT DISTINCT artifact_id FROM collection_items WHERE collection_id <> ?))