Changeset 23886 for trunk/ippTools/share/magictool_inputs.sql

Timestamp:

Apr 16, 2009, 2:05:33 PM (17 years ago)

Author:

bills

Message:

add missing commma, balance number of rows in the selects being unioned

File:

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

trunk/ippTools/share/magictool_inputs.sql

@@ -9 +9 @@
     diffSkyfile.uri,
     diffSkyfile.path_base,
-    diffSkyfile.fault
+    diffSkyfile.fault,
     diffSkyfile.quality
 FROM magicRun
@@ -26 +26 @@
     magicNodeResult.uri,
     NULL, -- magicNodeResult doesn't have a path_base
-    magicNodeResult.fault
+    magicNodeResult.fault,
+    0 as quality
 FROM magicTree
 JOIN magicRun