Mercurial > dive4elements > framework
comparison artifact-database/src/main/resources/sql/org-h2-driver.properties @ 346:2d525562fae9
Bugfix: added missing bracket to a H2 sql statement.
artifacts/trunk@3050 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Fri, 21 Oct 2011 07:45:33 +0000 |
| parents | 542caebea773 |
| children | 08731e7403b5 |
comparison
equal
deleted
inserted
replaced
| 345:7514fe89efef | 346:2d525562fae9 |
|---|---|
| 166 artifact_id NOT IN (SELECT DISTINCT artifact_id FROM collection_items WHERE collection_id <> ?) | 166 artifact_id NOT IN (SELECT DISTINCT artifact_id FROM collection_items WHERE collection_id <> ?) |
| 167 | 167 |
| 168 outdate.artifacts.collection=UPDATE artifacts \ | 168 outdate.artifacts.collection=UPDATE artifacts \ |
| 169 SET last_access = DATEADD('MILLISECOND', -2, CURRENT_TIMESTAMP), ttl = 1 \ | 169 SET last_access = DATEADD('MILLISECOND', -2, CURRENT_TIMESTAMP), ttl = 1 \ |
| 170 WHERE id IN \ | 170 WHERE id IN \ |
| 171 SELECT artifact_id FROM collection_items \ | 171 (SELECT artifact_id FROM collection_items \ |
| 172 WHERE collection_id = ? AND \ | 172 WHERE collection_id = ? AND \ |
| 173 artifact_id NOT IN (SELECT DISTINCT artifact_id FROM collection_items WHERE collection_id <> ?)) | 173 artifact_id NOT IN (SELECT DISTINCT artifact_id FROM collection_items WHERE collection_id <> ?)) |
| 174 | 174 |
| 175 outdate.artifacts.user=UPDATE artifacts \ | 175 outdate.artifacts.user=UPDATE artifacts \ |
| 176 SET last_access = DATEADD('MILLISECOND', -2, CURRENT_TIMESTAMP), ttl = 1 \ | 176 SET last_access = DATEADD('MILLISECOND', -2, CURRENT_TIMESTAMP), ttl = 1 \ |