Show
Ignore:
Timestamp:
11/03/10 20:38:14 (4 years ago)
Author:
Theo Schlossnagle <jesus@omniti.com>
git-committer:
Theo Schlossnagle <jesus@omniti.com> 1288816694 +0000
git-parent:

[dbd0c9dbeda6f50b3591b96efc2de01c606c0d25]

git-author:
Theo Schlossnagle <jesus@omniti.com> 1288816694 +0000
Message:

fix the fetch of the check to be the most recent

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/sprocs/stratcon.metric_name_summary_compile_fts_data.sql

    r4a0968d r3d20bc1  
    1717    v_fts_data tsvector; 
    1818BEGIN 
    19     SELECT sid, module, name, target FROM check_archive WHERE sid=in_sid INTO ref_sid,ref_module,ref_name,ref_target; 
     19    SELECT sid, module, name, target FROM check_archive WHERE sid=in_sid  
     20        ORDER BY whence DESC LIMIT 1 INTO ref_sid,ref_module,ref_name,ref_target; 
    2021    IF NOT FOUND THEN 
    2122        RETURN NULL;