Changeset 35429 for trunk/ippTools/share/chiptool_pendingcleanupimfile.sql

Timestamp:

Apr 24, 2013, 3:04:00 PM (13 years ago)

Author:

bills

Message:

include components in state error_cleaned in the list of files pending cleanup
This allows them to be cleaned later.

File:

• trunk/ippTools/share/chiptool_pendingcleanupimfile.sql (modified) (1 diff)

trunk/ippTools/share/chiptool_pendingcleanupimfile.sql

@@ -13 +13 @@
     USING(chip_id)
 WHERE
-    ((chipRun.state = 'goto_cleaned' AND (chipProcessedImfile.data_state = 'full'
-                                       OR chipProcessedImfile.data_state = 'update') AND chipProcessedImfile.quality = 0)
+    ((chipRun.state = 'goto_cleaned'
+        AND (chipProcessedImfile.data_state = 'full'
+          OR chipProcessedImfile.data_state = 'update'
+          OR chipProcessedImfile.data_state = 'error_cleaned')
+        AND chipProcessedImfile.quality = 0)
 OR 
     (chipRun.state = 'goto_scrubbed' AND chipProcessedImfile.data_state != 'scrubbed')