Changeset 34973 for trunk/ippTools/share

Timestamp:

Jan 18, 2013, 11:11:29 AM (13 years ago)

Author:

bills

Message:

Fix staticskytool -defineskycalrun so that new runs can be queued with different label
than existing runs. The join in the previous version was incorrect

File:

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

trunk/ippTools/share/staticskytool_defineskycalrun.sql

@@ -1 +1 @@
 SELECT
-    sky_id,
-    stack_id,
+    staticskyRun.sky_id,
+    stackRun.stack_id,
     skycell_id,
     filter,
@@ -14 +14 @@
     JOIN stackSumSkyfile USING(stack_id)
     JOIN skycell USING(tess_id, skycell_id)
-    LEFT JOIN skycalRun USING(sky_id, stack_id)
+    LEFT JOIN skycalRun ON staticskyRun.sky_id = skycalRun.sky_id AND stackRun.stack_id = skycalRun.stack_id -- join hook %s
 WHERE staticskyRun.state = 'full'
     AND staticskyResult.quality = 0