Changeset 15763 for trunk/ippTools/share/regtool_pendingexp.sql

Timestamp:

Dec 7, 2007, 12:59:59 PM (18 years ago)

Author:

jhoblitt

Message:

stop exposures with rawImfiles that have non zero fault codes from slipping through

File:

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

trunk/ippTools/share/regtool_pendingexp.sql

@@ -25 +25 @@
         newExp.state = 'run'
         AND rawExp.exp_id IS NULL
-        AND (rawImfile.fault = 0 || rawImfile.fault IS NULL)
     GROUP BY
         newExp.exp_id
     HAVING
         COUNT(newImfile.tmp_class_id) = COUNT(rawImfile.tmp_class_id)
+        AND SUM(rawImfile.fault) = 0
     ) as Foo