diff artifact-database/src/main/resources/sql/org-h2-driver.properties @ 243:33b9cc23ac9b

Granularity of ttls should be milliseconds and not microseconds. artifacts/trunk@1678 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 13 Apr 2011 15:19:59 +0000
parents b35d32e507b6
children a2df2b48d2aa
line wrap: on
line diff
--- a/artifact-database/src/main/resources/sql/org-h2-driver.properties	Wed Apr 13 11:26:53 2011 +0000
+++ b/artifact-database/src/main/resources/sql/org-h2-driver.properties	Wed Apr 13 15:19:59 2011 +0000
@@ -15,10 +15,10 @@
     AND id NOT IN ($LOCKED_IDS$) \
     LIMIT 50
 
-artifacts.select.gid=SELECT id, factory, data FROM artifacts WHERE gid = ?::uuid \
+artifacts.select.gid=SELECT id, ttl, factory, data FROM artifacts WHERE gid = ?::uuid \
     AND (ttl IS NULL \
     OR  (DATEDIFF('MILLISECOND', last_access, CURRENT_TIMESTAMP) <= ttl)  \
-    OR  id IN (SELECT artifact_id FROM collection_items)) \
+    OR  id IN (SELECT artifact_id FROM collection_items))
 
 artifacts.get.id=SELECT id FROM artifacts WHERE gid = ?
 

http://dive4elements.wald.intevation.org