Changeset 28626

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.

Location:

trunk/ippTools/share

Files:

• difftool_setskyfiletoupdate.sql (modified) (1 diff)
• warptool_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)

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)