Changeset 15372 for trunk/ippTools/share/chiptool_completely_processed_exp.sql

Timestamp:

Oct 24, 2007, 11:35:07 AM (19 years ago)

Author:

jhoblitt

Message:

fix the where clause statement 'chipProcessedImfile.fault = 0', which was hosing the left join between rawImfile and chipProcessedImfile

File:

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

trunk/ippTools/share/chiptool_completely_processed_exp.sql

@@ -24 +24 @@
     WHERE
         chipRun.state = 'run'
-        AND chipProcessedImfile.fault = 0
+        AND (chipProcessedImfile.fault = 0 || chipProcessedImfile.fault IS NULL)
     GROUP BY
         chipRun.chip_id,