Changeset 24460 for trunk/ippTools/share/disttool_revertrun_update.sql

Timestamp:

Jun 17, 2009, 10:04:29 AM (17 years ago)

Author:

bills

Message:

fix some problems with disttool -revertrun

File:

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

trunk/ippTools/share/disttool_revertrun_update.sql

@@ -1 +1 @@
 UPDATE distRun
-JOIN distComponent USING(dist_id)
-SET distRun.state = 'new', distRun.fault = 0
-WHERE distComponent.fault != 0
-    OR distRun.fault != 0
+SET distRun.fault = 0
+WHERE distRun.state = 'new'
+    AND distRun.fault != 0