Changeset 25428 for trunk/ippTools/share/disttool_definebyquery_stack.sql

Timestamp:

Sep 17, 2009, 10:01:32 AM (17 years ago)

Author:

bills

Message:

Require quality == 0 before queuing for distribution.
Work around a bug in stacking (faulted runs shouldn't be full).

File:

• trunk/ippTools/share/disttool_definebyquery_stack.sql (modified) (2 diffs)

trunk/ippTools/share/disttool_definebyquery_stack.sql

@@ -8 +8 @@
     distTarget.clean
 FROM stackRun
+JOIN stackSumSkyfile USING(stack_id)
 JOIN distTarget ON distTarget.stage = 'stack'
     AND stackRun.label = distTarget.label
@@ -19 +20 @@
     AND distRun.dist_id IS NULL
     AND ((stackRun.state = 'full') OR (distTarget.clean AND stackRun.state = 'cleaned'))
+    -- we shouldn't need to check fault. If faulted it shouldn't be full
+    AND (stackSumSkyfile.fault = 0 AND stackSumSkyfile.quality = 0)