Changeset 15528

Timestamp:

Nov 8, 2007, 3:52:25 PM (19 years ago)

Author:

jhoblitt

Message:

fix *.fault = 0 constrant

Location:

trunk/ippTools/share

Files:

• dettool_tonormalizedstat.sql (modified) (1 diff)
• dettool_toprocessedexp.sql (modified) (1 diff)

trunk/ippTools/share/dettool_tonormalizedstat.sql

@@ -45 +45 @@
         detRun.state = 'run'
         AND detRun.mode = 'master'
-        AND detStackedImfile.fault = 0
+        AND (detStackedImfile.fault = 0 || detStackedImfile.fault IS NULL)
         AND detNormalizedStatImfile.det_id IS NULL
         AND detNormalizedStatImfile.iteration IS NULL

trunk/ippTools/share/dettool_toprocessedexp.sql

@@ -49 +49 @@
         detRun.state = 'run'
         AND detRun.mode = 'master'
-        AND detProcessedImfile.fault = 0
+        AND (detProcessedImfile.fault = 0 || detProcessedImfile.fault IS NULL)
         AND detProcessedExp.det_id IS NULL
         AND detProcessedExp.exp_id IS NULL