Project

General

Profile

« Previous | Next » 

Revision 7145

Added by Aaron Marcuse-Kubitza almost 12 years ago

inputs/.TNRS/schema.sql: tnrs_canon: Fixed bug where need to always use Unmatched_terms from tnrs rather than tnrs_accepted

View differences:

schema.sql
144 144 
        CASE
145 145 
            WHEN tnrs_accepted.* IS NOT NULL THEN tnrs_accepted.*
146 146 
            ELSE tnrs.*
147 
        END)."Annotations" AS "Annotations", (
147 
        END)."Annotations" AS "Annotations", tnrs."Unmatched_terms" AS "Unmatched_terms", (
148 148 
        CASE
149 149 
            WHEN tnrs_accepted.* IS NOT NULL THEN tnrs_accepted.*
150 150 
            ELSE tnrs.*
151 
        END)."Unmatched_terms" AS "Unmatched_terms", (
152 
        CASE
153 
            WHEN tnrs_accepted.* IS NOT NULL THEN tnrs_accepted.*
154 
            ELSE tnrs.*
155 151 
        END)."Taxonomic_status" AS "Taxonomic_status", (
156 152 
        CASE
157 153 
            WHEN tnrs_accepted.* IS NOT NULL THEN tnrs_accepted.*

Also available in: Unified diff