Project

General

Profile

« Previous | Next » 

Revision 7158

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/.TNRS/schema.sql: tnrs_canon: Annotations: Always use value from the matched name, because the accepted name does not have this

View differences:

schema.sql
140 140 
        CASE
141 141 
            WHEN tnrs_accepted.* IS NOT NULL THEN tnrs_accepted.*
142 142 
            ELSE tnrs.*
143 
        END)."Infraspecific_epithet_2_matched" AS "Infraspecific_epithet_2_matched", tnrs."Infraspecific_epithet_2_score", (
143 
        END)."Infraspecific_epithet_2_matched" AS "Infraspecific_epithet_2_matched", tnrs."Infraspecific_epithet_2_score", tnrs."Annotations" AS "Annotations", tnrs."Unmatched_terms" AS "Unmatched_terms", (
144 144 
        CASE
145 145 
            WHEN tnrs_accepted.* IS NOT NULL THEN tnrs_accepted.*
146 146 
            ELSE tnrs.*
147 
        END)."Annotations" AS "Annotations", tnrs."Unmatched_terms" AS "Unmatched_terms", (
148 
        CASE
149 
            WHEN tnrs_accepted.* IS NOT NULL THEN tnrs_accepted.*
150 
            ELSE tnrs.*
151 147 
        END)."Taxonomic_status" AS "Taxonomic_status", (
152 148 
        CASE
153 149 
            WHEN tnrs_accepted.* IS NOT NULL THEN tnrs_accepted.*

Also available in: Unified diff