Changeset 23438 for trunk/ippTools/share/difftool_completed_runs.sql

Timestamp:

Mar 19, 2009, 2:54:59 PM (17 years ago)

Author:

bills

Message:

manage magicked status of diffSkyfiles made with magicked inputs

File:

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

trunk/ippTools/share/difftool_completed_runs.sql

@@ -1 +1 @@
 SELECT DISTINCT
-    diff_id
+    diff_id,
+    all_magicked as magicked
 FROM (
     SELECT
         COUNT(diffInputSkyfile.skycell_id), COUNT(diffSkyfile.skycell_id),
-        diffSkyfile.*
+        diffSkyfile.*,
+        SUM(!diffSkyfile.magicked) = 0 as all_magicked
     FROM diffRun
     JOIN diffInputSkyfile USING(diff_id)