Changeset 21308 for trunk/ippTools/share/difftool_definebyquery_part2.sql

Timestamp:

Feb 5, 2009, 9:35:41 AM (17 years ago)

Author:

bills

Message:

Changed the way image ids are handled. For chip and warp new tables are
added the sole purpose of which are to create the image ids before
the images are created. For diff the id is added to diffInputSkyfile

File:

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

trunk/ippTools/share/difftool_definebyquery_part2.sql

@@ -2 +2 @@
 INSERT INTO skycellsToDiff
     SELECT
-        0,              -- diff_id
+        0,                      -- diff_id
         warpSkyfile.skycell_id,
-        warp_id,        -- warp1
-        NULL,           -- stack1
-        NULL,           -- warp2
-        max_stack_id,   -- stack2
-        warpSkyfile.tess_id
+        warpSkyfile.warp_id,    -- warp1
+        NULL,                   -- stack1
+        NULL,                   -- warp2
+        max_stack_id,           -- stack2
+        warpSkyfile.tess_id,
+        0
         FROM warpSkyfile
         JOIN warpRun USING(warp_id)
@@ -28 +29 @@
         USING(skycell_id)
         WHERE
-            warp_id = %lld
+            warpSkyfile.warp_id = %lld
             AND ignored = 0
             AND filter = '%s'