Changeset 35672 for trunk/ippTools/share/bgtool_definewarp.sql

Timestamp:

Jun 18, 2013, 1:46:43 PM (13 years ago)

Author:

bills

Message:

fix errors in defining and running warp_bg and chip_bg runs

File:

• trunk/ippTools/share/bgtool_definewarp.sql (modified) (1 diff)

trunk/ippTools/share/bgtool_definewarp.sql

@@ -15 +15 @@
 JOIN chipBackgroundRun ON chipRun.chip_id = chipBackgroundRun.chip_id 
     AND (chipBackgroundRun.cam_id = camRun.cam_id OR chipBackgroundRun.cam_id = 0)
-LEFT JOIN warpBackgroundRun ON chipBackgroundRun.chip_bg_id = warpBackgroundRun.warp_bg_id -- label hook %s
+LEFT JOIN warpBackgroundRun ON chipBackgroundRun.chip_bg_id = warpBackgroundRun.chip_bg_id -- label hook %s
 WHERE chipBackgroundRun.state = 'full'
     AND warpRun.state IN ('full', 'cleaned', 'goto_cleaned') -- need warp to have completed so warpSkyCellMap is populated