Project

General

Profile

« Previous | Next » 

Revision 7158

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

View differences:

inputs/.TNRS/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