Changeset 13403 for trunk/ippTools/share/chiptool_completely_processed_exp.sql

Timestamp:

May 16, 2007, 3:42:33 PM (19 years ago)

Author:

jhoblitt

Message:

do not migrate an exp from pending -> processed if any of it's imfiles are faulted

File:

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

trunk/ippTools/share/chiptool_completely_processed_exp.sql

@@ -21 +21 @@
     AND chipPendingImfile.chip_id IS NULL
     AND chipProcessedImfile.chip_id IS NOT NULL
+    AND chipProcessedImfile.fault = 0
 GROUP BY
     chipPendingExp.chip_id