• Marc G. Fournier's avatar
    From: Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov> · 9d5c0af5
    Marc G. Fournier authored
    Subject: [HACKERS] Aggregate function patches
    
    Here are the aggregate function patches I originally sent in last December.
    They fix sum() and avg() behavior for ints and floats when NULL values are
    involved.
    
    I was waiting to resubmit these until I had a chance to write a v6.0->v6.1
    database upgrade script to ensure that existing v6.0 databases which have
    not been reloaded for v6.1 do no break with the new aggregate behavior.
    These scripts are included below. It's OK with me if someone wants to do
    something different with the upgrade strategy, but something like this
    was discussed a few weeks ago.
    
    Also, there were a couple of small items which cropped up in doing a clean
    install of 970403 (actually 970402 + 970403 changes since the full 970403
    tar file appears to be damaged or at least suspect). They are the first
    two patches below and can be omitted if desired (although I think they
    aren't dangerous :).
    9d5c0af5
update6_0-6_1.sh 1.85 KB