Project

General

Profile

« Previous | Next » 

Revision 13634

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: schemas/public_.sql: tnrs_input_name: need to exclude unsafe taxon names as a workaround to #935 (TNRS crashes when scrubbing names with two infraspecific epithets)

View differences:

trunk/schemas/public_.sql
8840 8840 
 SELECT DISTINCT taxonlabel.taxonomicname
8841 8841 
   FROM (taxonlabel
8842 8842 
   LEFT JOIN "TNRS"."MatchedTaxon" ON (("MatchedTaxon"."concatenatedScientificName" = taxonlabel.taxonomicname)))
8843 
  WHERE ((taxonlabel.taxonomicname IS NOT NULL) AND ("MatchedTaxon"."concatenatedScientificName" IS NULL));
8843 
  WHERE (((taxonlabel.taxonomicname IS NOT NULL) AND ("MatchedTaxon"."concatenatedScientificName" IS NULL)) AND "TNRS".taxon_name_is_safe(taxonlabel.taxonomicname));
8844 8844 

  		




  8845
  8845
  
    

  		




  8846
  8846
  
    
--


  		












  

    
      trunk/schemas/vegbien.sql
    
  





  8840
  8840
  
    
 SELECT DISTINCT taxonlabel.taxonomicname


  		




  8841
  8841
  
    
   FROM (taxonlabel


  		




  8842
  8842
  
    
   LEFT JOIN "TNRS"."MatchedTaxon" ON (("MatchedTaxon"."concatenatedScientificName" = taxonlabel.taxonomicname)))


  		




  8843
  
  
    
  WHERE ((taxonlabel.taxonomicname IS NOT NULL) AND ("MatchedTaxon"."concatenatedScientificName" IS NULL));


  		




  
  8843
  
    
  WHERE (((taxonlabel.taxonomicname IS NOT NULL) AND ("MatchedTaxon"."concatenatedScientificName" IS NULL)) AND "TNRS".taxon_name_is_safe(taxonlabel.taxonomicname));


  		




  8844
  8844
  
    

  		




  8845
  8845
  
    

  		




  8846
  8846
  
    
--


  		












Also available in:  Unified diff