Task #816

Updated by Aaron Marcuse-Kubitza over 10 years ago

* this will fix the 1.3 million[1] names scrubbed during the 6 days that while TNRS was broken[2], when it wasn't populating the critical field @Name_matched_accepted_family@ 

 fn1(((. +1337539+ 
 <pre><code class="SQL"> 
 SELECT COUNT(*) FROM "TNRS".tnrs 
 WHERE "Name_matched_accepted_family" IS NULL AND "Family_matched" IS NOT NULL 
 Total query runtime: 5090 ms. 
 </code></pre> 

 fn2(((. 2013-5-23..28 starting on 2013-5-23 
 <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 "Name_matched_rank" != 'family' /*this is also the case for family-only matches*/ 
 Total query runtime: 18606 4548 ms. 
 "2013-05-23 15:48:28.970796-07","2013-05-28 08:36:52.569103-07" 15:48:28.970796-07","2013-11-18 17:43:18.114637-08" 
 </code></pre>

Back