Changeset 28626 for trunk/ippTools/share/warptool_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/warptool_setskyfiletoupdate.sql (modified) (1 diff)

trunk/ippTools/share/warptool_setskyfiletoupdate.sql

@@ -11 +11 @@
     AND (warpSkyfile.data_state = 'cleaned')
     AND (warpRun.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)