Changeset 24268 for trunk/ippScripts/scripts

Timestamp:

May 27, 2009, 5:18:20 PM (17 years ago)

Author:

Paul Price

Message:

Need to use trick to get corresponding value for MAX() field.

Location:

trunk/ippScripts/scripts

Files:

• ipp_serial_mops.pl (modified) (1 diff)
• ipp_serial_mops_warps.pl (modified) (1 diff)

trunk/ippScripts/scripts/ipp_serial_mops.pl

@@ -78 +78 @@
 SELECT
     rawExp.exp_id,
-    camProcessedExp.zpt_obs,
     MAX(diffWarps.diff_id) AS diff_id,
-    -- The following trick pulls out the 'inverse' value for the maximum diff_id
+    -- The following trick pulls out the appropriate values for the maximum diff_id
+    CONVERT(SUBSTRING_INDEX(GROUP_CONCAT(camProcessedExp.zpt_obs ORDER BY diffWarps.diff_id), ',', 1), UNSIGNED) AS zpt_obs,
     CONVERT(SUBSTRING_INDEX(GROUP_CONCAT(diffWarps.inverse ORDER BY diffWarps.diff_id), ',', 1), UNSIGNED) AS inverse
 FROM (

trunk/ippScripts/scripts/ipp_serial_mops_warps.pl

@@ -78 +78 @@
 SELECT
     rawExp.exp_id,
-    camProcessedExp.zpt_obs,
-    MAX(warpRun.warp_id) AS warp_id
+    MAX(warpRun.warp_id) AS warp_id,
+    -- The following trick pulls out the 'zpt_obs' value for the maximum warp_id
+    CONVERT(SUBSTRING_INDEX(GROUP_CONCAT(camProcessedExp.zpt_obs ORDER BY warpRun.warp_id), ',', 1), UNSIGNED) AS zpt_obs
 FROM warpRun
 JOIN fakeRun USING(fake_id)