Changeset 24157

Timestamp:

May 12, 2009, 7:10:33 PM (17 years ago)

Author:

Paul Price

Message:

Needed to join against diffSkyfile to ensure we only get nodes that match a skycell.

File:

• branches/pap_magic/ippTools/share/magictool_toprocess_inputs.sql (modified) (1 diff)

branches/pap_magic/ippTools/share/magictool_toprocess_inputs.sql

@@ -8 +8 @@
     magicNodeResult.magic_id IS TRUE AS done,
     magicNodeResult.fault IS TRUE AS bad
-FROM magicTree
-JOIN magicRun USING(magic_id)
+FROM magicRun
+JOIN magicTree USING(magic_id)
+JOIN magicInputSkyfile USING(magic_id, node)
 JOIN rawExp USING(exp_id)
+JOIN diffSkyfile -- only get nodes that match a skycell
+    ON diffSkyfile.diff_id = magicRun.diff_id
+    AND diffSkyfile.skycell_id = magicInputSkyfile.node
 LEFT JOIN magicNodeResult USING(magic_id, node)
 WHERE