Project

General

Profile

« Previous | Next » 

Revision 7110

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/vegbien.sql: taxondetermination_set_iscurrent(): Fixed bug where need to sort scrubbed determinations first for scrub.make to work. (Otherwise, a datasource determination might remain iscurrent even after a scrubbed determination was added, causing scrub.make to repeatedly attempt to re-add it.)

View differences:

vegbien.sql
1031 1031 
    WHERE taxondetermination_id = (
1032 1032 
        SELECT taxondetermination_id FROM taxondetermination
1033 1033 
        WHERE taxonoccurrence_id = new.taxonoccurrence_id
1034 
        ORDER BY isoriginal/*false first*/, determinationdate DESC NULLS LAST
1034 
        ORDER BY
1035 
            -- Scrubbed determinations must come first for scrub.make to work
1036 
            COALESCE(determinationtype = 'computer', false) DESC/*true first*/
1037 
            , isoriginal/*false first*/
1038 
            , determinationdate DESC NULLS LAST
1035 1039 
        LIMIT 1
1036 1040 
    );
1037 1041

Also available in: Unified diff