Changeset 20682 for trunk/ippTools/share/difftool_definebyquery.sql

Timestamp:

Nov 10, 2008, 8:05:10 PM (17 years ago)

Author:

Paul Price

Message:

Fix bug in selecting diff inputs by labels.

File:

• trunk/ippTools/share/difftool_definebyquery.sql (modified) (3 diffs)

trunk/ippTools/share/difftool_definebyquery.sql

@@ -7 +7 @@
     warpsToDiff.tess_id,
     warpsToDiff.filter,
-    stacksForDiff.stack_label,
-    warpsToDiff.warp_label,
     warpsToDiff.good_frac,
     warpsToDiff.diff_id,
@@ -45 +43 @@
         warpSkyfile.fault = 0
         AND warpSkyfile.ignored = 0
+    -- warpsToDiff WHERE hook %s
     ) AS warpsToDiff
 -- Get best stack as a function of skycell_id, filter
@@ -51 +50 @@
         MAX(stack_id) AS best_stack_id, -- most recent stack, by virtue of auto-increment
         skycell_id,
-        tess_id,
-        filter,
-        label as stack_label
+        filter
     FROM stackRun
     JOIN stackSumSkyfile USING(stack_id)
     WHERE stackRun.state = 'full'
         AND stackSumSkyfile.fault = 0
+    -- stacksForDiff WHERE hook %s
     GROUP BY
         skycell_id,