Changeset 17742

Timestamp:

May 19, 2008, 11:51:26 AM (18 years ago)

Author:

Paul Price

Message:

Fixing "ambiguous tess_id".

Location:

trunk/ippTools/share

Files:

• magictool_find_complete_warpruns.sql (modified) (1 diff)
• magictool_find_unmagiced.sql (modified) (1 diff)

trunk/ippTools/share/magictool_find_complete_warpruns.sql

@@ -19 +19 @@
         FROM warpRun
         JOIN warpSkyCellMap
-            USING(warp_id)
+            USING(warp_id, tess_id)
         LEFT JOIN warpSkyfile
             USING(warp_id, skycell_id, tess_id)

trunk/ippTools/share/magictool_find_unmagiced.sql

@@ -14 +14 @@
     -- find all of the skycells that came out of a single exposure
     JOIN warpSkyCellMap
-        USING(warp_id)
+        USING(warp_id, tess_id)
     LEFT JOIN warpSkyfile
         USING(warp_id, skycell_id, tess_id)