Changeset 24460 for trunk/ippTools/share

Timestamp:

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

Author:

bills

Message:

fix some problems with disttool -revertrun

Location:

trunk/ippTools/share

Files:

• disttool_revertrun_delete.sql (modified) (1 diff)
• disttool_revertrun_update.sql (modified) (1 diff)

trunk/ippTools/share/disttool_revertrun_delete.sql

@@ -2 +2 @@
 USING distComponent, distRun
 WHERE distComponent.dist_id = distRun.dist_id
+    AND distRun.state = 'new'
     AND distComponent.fault != 0

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