Changeset 31409 for branches/czw_branch/20110406/ippTools/share/laptool_exposures.sql

Timestamp:

Apr 29, 2011, 2:33:48 PM (15 years ago)

Author:

watersc1

Message:

Finished with laptool (for now at least), as it seems to be working properly. Change to psDB.c adds some more information to help debug 'type lookup failed.' errors.

File:

• branches/czw_branch/20110406/ippTools/share/laptool_exposures.sql (modified) (2 diffs)

branches/czw_branch/20110406/ippTools/share/laptool_exposures.sql

@@ -1 +1 @@
 SELECT DISTINCT 
-    D.*,diffRun.state,sum(others.private) AS needs_remade FROM (
+    D.*,diffRun.state,
+    CONVERT(sum(others.private),SIGNED) AS needs_remade 
+--      0 AS needs_remade
+    FROM (
   SELECT DISTINCT 
-      W.*,IFNULL(diff1.diff_id,diff2.diff_id) AS diff_id FROM (
+      W.*,CONVERT(IFNULL(diff1.diff_id,diff2.diff_id),SIGNED) AS diff_id FROM (
     SELECT DISTINCT
         lap_id,lapRun.tess_id,projection_cell,filter,lapRun.state as lapRun_state, lapRun.registered, lapRun.fault, lapRun.label,
         lapExp.exp_id,lapExp.chip_id,lapExp.pair_id,private,pairwise,active,lapExp.data_state,
-        chipRun.state as chipRun_state, sum(chipProcessedImfile.fault) as chip_faults, sum(chipProcessedImfile.quality) as chip_quality,
-        camRun.cam_id, camRun.state as camRun_state,   sum(camProcessedExp.fault) AS cam_faults, sum(camProcessedExp.quality) AS cam_quality,
-        fakeRun.fake_id, fakeRun.state as fakeRun_state, sum(fakeProcessedImfile.fault) as fake_faults,
-        warpRun.warp_id, warpRun.state as warpRun_state, sum(warpSkyfile.fault) as warp_faults, sum(warpSkyfile.quality) as warp_quality,
+        chipRun.state as chipRun_state, 
+        CONVERT(sum(chipProcessedImfile.fault),SIGNED) as chip_faults, 
+        CONVERT(sum(chipProcessedImfile.quality),SIGNED) as chip_quality,
+        camRun.cam_id, camRun.state as camRun_state,   
+        CONVERT(sum(camProcessedExp.fault),SIGNED) AS cam_faults, 
+        CONVERT(sum(camProcessedExp.quality),SIGNED) AS cam_quality,
+        fakeRun.fake_id, fakeRun.state as fakeRun_state, 
+        CONVERT(sum(fakeProcessedImfile.fault),SIGNED) as fake_faults,
+        warpRun.warp_id, warpRun.state as warpRun_state, 
+        CONVERT(sum(warpSkyfile.fault),SIGNED) as warp_faults, 
+        CONVERT(sum(warpSkyfile.quality),SIGNED) as warp_quality,
         warpRun.magicked
     FROM lapRun JOIN lapExp USING(lap_id)
@@ -28 +38 @@
 LEFT JOIN diffRun USING(diff_id)
 JOIN lapExp AS others ON (D.chip_id = others.chip_id AND D.lap_id != others.lap_id)
-GROUP BY lap_id,exp_id
+