Changeset 28626 for trunk/ippTools/share/difftool_setskyfiletoupdate.sql

Timestamp:

Jul 7, 2010, 3:02:59 PM (16 years ago)

Author:

bills

Message:

Allow for magciDSRun to be NULL even if skycells were magciked.
This will happen if the inputs are already destreaked.

File:

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

trunk/ippTools/share/difftool_setskyfiletoupdate.sql

@@ -12 +12 @@
     -- don't queue update if the associated magicDSFile still exists
     AND (diffRun.magicked = 0 
-      OR (magicDSRun.state = 'cleaned' OR magicDSRun.state = 'new')
+      OR (magicDSRun.state = 'cleaned' OR magicDSRun.state = 'new' OR magicDSRun.state IS NULL)
             AND magicDSFile.component IS NULL)