Changeset 25048

Timestamp:

Aug 10, 2009, 5:47:21 PM (17 years ago)

Author:

Paul Price

Message:

I think the GROUP BY means we need the warp_id for each diff in order
to get the correct number of skycells when the diff already exists for
an exposure.

File:

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

trunk/ippTools/share/difftool_definewarpstack_part1.sql

@@ -15 +15 @@
     SELECT DISTINCT
         diffRun.*,
+        warp_id,
         exp_id
     FROM diffRun
@@ -24 +25 @@
     JOIN chipRun USING(chip_id)
     WHERE warp1 IS NOT NULL
-) AS diffExp USING(exp_id)
+) AS diffExp USING(exp_id, warp_id)
 WHERE
     warpSkyfile.fault = 0