Revision 11424
Added by Aaron Marcuse-Kubitza about 11 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 1380 | 1380 |
WHERE taxondetermination_id = ( |
| 1381 | 1381 |
SELECT taxondetermination_id FROM taxondetermination |
| 1382 | 1382 |
WHERE taxonoccurrence_id = taxonoccurrence_id_ |
| 1383 |
AND determinationtype NOT IN ('accepted', 'matched')
|
|
| 1383 |
AND (determinationtype IS NULL |
|
| 1384 |
OR determinationtype NOT IN ('accepted', 'matched'))
|
|
| 1384 | 1385 |
ORDER BY |
| 1385 | 1386 |
isoriginal/*false first*/ |
| 1386 | 1387 |
, determinationdate DESC NULLS LAST |
Also available in: Unified diff
bugfix: schemas/vegbien.sql: taxondetermination_set_iscurrent(): is_datasource_current (used by analytical_stem_view): need to separately check if `determinationtype IS NULL`, because `determinationtype NOT IN (accepted, matched))` will return NULL (false) if determinationtype is NULL, causing no match