Changeset 24194

Timestamp:

May 15, 2009, 11:35:28 AM (17 years ago)

Author:

bills

Message:

diffRun no longer has an exp_id

Location:

trunk/ippTools/share

Files:

• disttool_definebyquery_diff.sql (modified) (1 diff)
• disttool_pendingcomponent.sql (modified) (1 diff)

trunk/ippTools/share/disttool_definebyquery_diff.sql

@@ -11 +11 @@
 JOIN fakeRun USING(fake_id)
 JOIN camRun USING(cam_id)
-JOIN chipRun USING(exp_id, chip_id)
+JOIN chipRun USING(chip_id)
 JOIN rawExp USING(exp_id)
 JOIN distTarget ON distTarget.stage = 'diff' AND rawExp.obs_mode = distTarget.obs_mode

trunk/ippTools/share/disttool_pendingcomponent.sql

@@ -229 +229 @@
 JOIN diffRun ON stage_id = diff_id
 JOIN diffSkyfile using(diff_id)
-JOIN rawExp using(exp_id)
+JOIN diffInputSkyfile USING(diff_id, skycell_id)
+JOIN warpRun
+    ON warpRun.warp_id = diffInputSkyfile.warp1
+JOIN fakeRun USING(fake_id)
+JOIN camRun USING(cam_id)
+JOIN chipRun USING(chip_id)
+JOIN rawExp USING(exp_id)
 LEFT JOIN distComponent 
     ON distRun.dist_id = distComponent.dist_id