Project

General

Profile

Task #816

Updated by Aaron Marcuse-Kubitza over 10 years ago

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

 fn1(((. +1337539+ 
 @SELECT COUNT(*) FROM "TNRS".tnrs@ 
 @WHERE "Name_matched_accepted_family" IS NULL AND "Family_matched" IS NOT NULL@ 
 @Total query runtime: 5090 ms.@ 

 fn2(((. starting on 2013-5-23 
 @SELECT min(batch), max(batch) FROM "TNRS".tnrs@ 
 @WHERE "Name_matched_accepted_family" IS NULL AND "Family_matched" IS NOT NULL@ 
 @Total query runtime: 4548 ms.@ 
 @"2013-05-23 15:48:28.970796-07","2013-11-18 17:43:18.114637-08"@

Back