Changeset 15769 for trunk/ippTools/share/flatcorr_completely_processed_chiprun.sql

Timestamp:

Dec 7, 2007, 4:36:46 PM (19 years ago)

Author:

jhoblitt

Message:

fix .fault handling

File:

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

trunk/ippTools/share/flatcorr_completely_processed_chiprun.sql

@@ -27 +27 @@
         WHERE
             chipRun.state = 'stop'
-            AND (chipProcessedImfile.fault = 0 || chipProcessedImfile.fault IS NULL)
         GROUP BY
             chipRun.chip_id,
             chipRun.exp_id
-        HAVING COUNT(rawImfile.class_id) = COUNT(chipProcessedImfile.class_id)
+        HAVING
+            COUNT(rawImfile.class_id) = COUNT(chipProcessedImfile.class_id)
+            AND SUM(chipProcessedImfile.fault) = 0
         ) as Foo
     ) as Bar