Changeset 31409 for branches/czw_branch/20110406/ippTools/share/laptool_inactiveexp.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_inactiveexp.sql (modified) (2 diffs)

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

@@ -1 +1 @@
 SELECT DISTINCT 
-    D.*,diffRun.state,sum(others.active) AS is_in_use FROM (
+    D.*,diffRun.state AS diff_state,CONVERT(sum(others.active),SIGNED) AS is_in_use FROM (
   SELECT DISTINCT 
       W.*,IFNULL(diff1.diff_id,diff2.diff_id) AS diff_id FROM (
@@ -7 +7 @@
         lapRun.dist_group, lapRun.registered, lapRun.fault, lapRun.quick_sass_id, lapRun.final_sass_id,
         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,
-        cam_id, camRun.state as camRun_state,   sum(camProcessedExp.fault) AS cam_faults, sum(camProcessedExp.quality) AS cam_quality,
-        fake_id, fakeRun.state as fakeRun_state, sum(fakeProcessedImfile.fault) as fake_faults,
-        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)