Changeset 20738

Timestamp:

Nov 13, 2008, 3:53:23 PM (17 years ago)

Author:

Paul Price

Message:

Wasn't setting warp_id in magicBestDiffs correctly (it wasn't
necessarily the warp_id associated with the best diff_id), so
jettisoned it. If we want it, we can join against diffInputSkyfile.

File:

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

trunk/ippTools/share/magictool_definebyquery_temp_insert.sql

@@ -3 +3 @@
 SELECT
     rawExp.exp_id,
-    warpSkyfile.skycell_id,
-    warpSkyfile.tess_id,
-    warpRun.warp_id AS warp_id,
+    diffInputSkyfile.skycell_id,
+    diffInputSkyfile.tess_id,
     MAX(diffSkyfile.diff_id) AS diff_id
 FROM rawExp
@@ -18 +17 @@
     AND diffInputSkyfile.skycell_id = warpSkyfile.skycell_id
     AND diffInputSkyfile.template = 0 -- selecting inputs only
+JOIN diffRun USING(diff_id)
 JOIN diffSkyfile USING(diff_id)
 WHERE
     diffSkyfile.fault = 0
----- WHERE hook %s
+-- WHERE hook %s
 GROUP BY
     exp_id,
-    warpSkyfile.skycell_id
+    diffInputSkyfile.skycell_id,
+    diffInputSkyfile.tess_id
+;