Changeset 33233

Timestamp:

Feb 10, 2012, 11:20:48 AM (14 years ago)

Author:

bills

Message:

don't join rawExp to rawImfile using exp_time it doesn't work
if value is floating point

File:

• tags/ipp-20111222/ippTools/share/camtool_find_pendingimfile.sql (modified) (2 diffs, 1 prop)

tags/ipp-20111222/ippTools/share/camtool_find_pendingimfile.sql

@@ -2 +2 @@
     camRun.cam_id,
     chipProcessedImfile.*,
-    (IF(exp_time IS NOT NULL AND deteff_magref IS NOT NULL,
-       (2.5 * LOG10(exp_time) + chipProcessedImfile.deteff_magref),  NULL))
+    (IF(rawExp.exp_time IS NOT NULL AND deteff_magref IS NOT NULL,
+       (2.5 * LOG10(rawExp.exp_time) + chipProcessedImfile.deteff_magref),
+        NULL))
         AS deteff_inst,
     rawExp.exp_name,
@@ -17 +18 @@
     USING(exp_id)
 JOIN rawImfile
-    USING(exp_id, class_id, exp_time)
+    USING(exp_id, class_id)
 LEFT JOIN camProcessedExp
     USING(cam_id)