Revision 11711
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 124 | 124 |
BEGIN |
| 125 | 125 |
/* exclude homonyms because these are not valid matches (i.e. TNRS provides |
| 126 | 126 |
a name, but the name is not meaningful because it is not unambiguous). */ |
| 127 |
new.is_valid_match = COALESCE(CASE |
|
| 127 |
new.is_valid_match = new."Taxonomic_status" != 'Invalid' |
|
| 128 |
AND COALESCE(CASE |
|
| 128 | 129 |
WHEN new."Family_score" = 1 AND NOT family_is_homonym -- exact match |
| 129 | 130 |
THEN true |
| 130 | 131 |
ELSE -- consider genus |
Also available in: Unified diff
fix: inputs/.TNRS/schema.sql: tnrs_populate_fields(): is_valid_match: set this to false if Taxonomic_status is Invalid