Task #816
Updated by Aaron Marcuse-Kubitza over 10 years ago
* temporary workaround for names with an accepted name:
use @Accepted_name_family@ when @Name_matched_accepted_family@ is not available
* this will fix the 300,000 no-opinion names[1] scrubbed during the 6 days that TNRS was broken[2], when it wasn't populating the critical field @Name_matched_accepted_family@
fn1(((. +293816+
<pre><code class="SQL">
SELECT COUNT(*) FROM "TNRS".tnrs
WHERE
"Name_matched_accepted_family" IS NULL
AND "Family_matched" IS NOT NULL
AND "Accepted_name_family" IS NULL -- where we are using the matched name instead of the accepted name
AND "Name_matched_rank" != 'family' -- this is also the case for family-only matches
Total query runtime: 5718 ms.
</code></pre>
fn2(((. 2013-5-23..28
<pre><code class="SQL">
SELECT min(batch), max(batch) FROM "TNRS".tnrs
WHERE
"Name_matched_accepted_family" IS NULL
AND "Family_matched" IS NOT NULL
AND "Accepted_name_family" IS NULL -- where we are using the matched name instead of the accepted name
AND "Name_matched_rank" != 'family' -- this is also the case for family-only matches
Total query runtime: 3928 ms.
"2013-05-23 15:48:28.970796-07","2013-05-28 08:36:52.569103-07"
</code></pre>