Changeset 27839 for branches/simmosaic_branches/ippTools/share/faketool_pendingcleanupimfile.sql

Timestamp:

May 3, 2010, 8:45:22 AM (16 years ago)

Author:

eugene

Message:

updates from trunk

Location:

branches/simmosaic_branches

Files:

• . (modified) (1 prop)
• ippTools/share/faketool_pendingcleanupimfile.sql (modified) (1 diff)

branches/simmosaic_branches/ippTools/share/faketool_pendingcleanupimfile.sql

@@ -13 +13 @@
     USING(fake_id)
 WHERE
-    fakeRun.state = 'goto_cleaned'
+    ((fakeRun.state = 'goto_cleaned' AND fakeProcessedImfile.data_state = 'full')
+OR 
+    (fakeRun.state = 'goto_scrubbed' AND fakeProcessedImfile.data_state = 'full')
+OR 
+    (fakeRun.state = 'goto_purged' AND fakeProcessedImfile.data_state != 'purged'))