Project

General

Profile

« Previous | Next » 

Revision 14323

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: inputs/.TNRS/schema.sql: derived columns: use "Accepted_family__@TNRS__@vegpath.org" instead of "*Accepted_name_family" because "*Accepted_name_family" is sometimes missing

View differences:

vegbien.my.sql
15484 15484 
    ELSE NULL::varchar(255)
15485 15485 
END))))
15486 15486 
CASE
15487 
    WHEN (`*Accepted_name_rank` = CAST('family' AS varchar(255))) THEN concat_ws(CAST(' ' AS varchar(255)), `*Accepted_name_family`, `[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org`)
15487 
    WHEN (`*Accepted_name_rank` = CAST('family' AS varchar(255))) THEN concat_ws(CAST(' ' AS varchar(255)), `Accepted_family__@TNRS__@vegpath.org`, `[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org`)
15488 15488 
    WHEN (`*Accepted_name_rank` = CAST('genus' AS varchar(255))) THEN concat_ws(CAST(' ' AS varchar(255)), `*Accepted_name`, `[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org`)
15489 15489 
    ELSE `*Accepted_name_species`
15490 15490 
END)))
......
15497 15497 
    ELSE `*Name_matched_author`
15498 15498 
END)))
15499 15499 
CASE
15500 
    WHEN matched_has_accepted THEN `*Accepted_name_family`
15500 
    WHEN matched_has_accepted THEN `Accepted_family__@TNRS__@vegpath.org`
15501 15501 
    ELSE `*Name_matched_accepted_family`
15502 15502 
END)))
15503 15503 
CASE

Also available in: Unified diff