IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 24271


Ignore:
Timestamp:
May 27, 2009, 5:26:20 PM (17 years ago)
Author:
Paul Price
Message:

Don't CONVERT() the floating point value!

Location:
trunk/ippScripts/scripts
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippScripts/scripts/ipp_serial_mops.pl

    r24270 r24271  
    8080    MAX(diffWarps.diff_id) AS diff_id,
    8181    -- The following trick pulls out the appropriate values for the maximum diff_id
    82     CONVERT(SUBSTRING_INDEX(GROUP_CONCAT(camProcessedExp.zpt_obs ORDER BY diffWarps.diff_id), ',', 1), UNSIGNED) AS zpt_obs,
     82    SUBSTRING_INDEX(GROUP_CONCAT(camProcessedExp.zpt_obs ORDER BY diffWarps.diff_id), ',', 1) AS zpt_obs,
    8383    CONVERT(SUBSTRING_INDEX(GROUP_CONCAT(diffWarps.inverse ORDER BY diffWarps.diff_id), ',', 1), UNSIGNED) AS inverse
    8484FROM (

  • trunk/ippScripts/scripts/ipp_serial_mops_warps.pl

    r24270 r24271  
    8080    MAX(warpRun.warp_id) AS warp_id,
    8181    -- The following trick pulls out the 'zpt_obs' value for the maximum warp_id
    82     CONVERT(SUBSTRING_INDEX(GROUP_CONCAT(camProcessedExp.zpt_obs ORDER BY warpRun.warp_id), ',', 1), UNSIGNED) AS zpt_obs
     82    SUBSTRING_INDEX(GROUP_CONCAT(camProcessedExp.zpt_obs ORDER BY warpRun.warp_id), ',', 1) AS zpt_obs
    8383FROM warpRun
    8484JOIN fakeRun USING(fake_id)
Note: See TracChangeset for help on using the changeset viewer.