Changeset 28612

Timestamp:

Jul 6, 2010, 9:54:33 AM (16 years ago)

Author:

bills

Message:

merge change from r28611 from trunk. Fix sql for revertprocessedimfile to
only delete chipProcessedimfile's where chipRun.state = 'new'

File:

• tags/ipp-20100701/ippTools/share/chiptool_revertprocessedimfile.sql (modified) (1 diff, 1 prop)

tags/ipp-20100701/ippTools/share/chiptool_revertprocessedimfile.sql

@@ -2 +2 @@
 USING chipProcessedImfile, chipRun, rawExp
 WHERE
-    rawExp.exp_id = chipProcessedImfile.exp_id
+    chipRun.chip_id = chipProcessedImfile.chip_id
+    AND rawExp.exp_id = chipProcessedImfile.exp_id
     AND chipRun.state = 'new'
     AND chipProcessedImfile.fault != 0