Changeset 20903 for branches/bills_081204/ippTools/share/magictool_inputs.sql

Timestamp:

Dec 4, 2008, 1:44:33 PM (18 years ago)

Author:

bills

Message:

on branch. Reorganizing the diff stage to consist of a collection of
skyfiles

File:

• branches/bills_081204/ippTools/share/magictool_inputs.sql (modified) (2 diffs)

branches/bills_081204/ippTools/share/magictool_inputs.sql

@@ -11 +11 @@
     diffSkyfile.fault
 FROM magicInputSkyfile
+JOIN magicRun USING(magic_id)
 JOIN diffSkyfile
     USING(diff_id)
-JOIN magicRun
-    USING(magic_id)
 UNION
 -- Merged skycells
@@ -21 +20 @@
     magicRun.state,
     magicTree.node,
-    0,
+    0,   -- no diff_id
     magicNodeResult.uri,
     NULL, -- magicNodeResult doesn't have a path_base