Changeset 37709 for trunk/ippTools/share/addtool_queue_diff_id.sql

Timestamp:

Dec 2, 2014, 3:27:44 PM (12 years ago)

Author:

heather

Message:

changes to addtool to do addstar diffs

File:

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

trunk/ippTools/share/addtool_queue_diff_id.sql

@@ -4 +4 @@
         'diff',         -- stage
         diff_id,        -- stage_id
-        diff_skyfile_id, -- stage_extra1
+        %d, -- stage_extra1
         '%s',           -- state
         '%s',           -- workdir
@@ -17 +17 @@
         '%s',           -- minidvodb_group 
         '%s'            -- minidvodb_name
-    FROM diffInputSkyfile 
-    JOIN diffSkyfile using (diff_id, skycell_id)
-    JOIN diffRun using (diff_id)
+    FROM diffRun
     WHERE
-        diffRun.state = 'full' AND
+        diffRun.state = 'full' 
         AND diffRun.diff_id = %lld
+