Project

General

Profile

« Previous | Next » 

Revision 13393

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: validation/aggregating/plots/bien3_validations_salvias_vegbien.sql: _plots_21_tnrs_output_names: needs to be run with `SET join_collapse_limit = DEFAULT; SET enable_hashjoin = off;` to produce the right query plan

View differences:

trunk/validation/aggregating/plots/bien3_validations_salvias_vegbien.sql
343 343 
  WHERE ((taxonlabel.source_id = ( SELECT source_by_shortname(:datasource::text) AS source_by_shortname)) AND (taxonlabel.taxonomicname IS NOT NULL));
344 344 

  		




  345
  345
  
    
-- _plots_21_tnrs_output_names


  		




  
  346
  
    
SET join_collapse_limit = DEFAULT;


  		




  
  347
  
    
SET enable_hashjoin = off;


  		




  346
  348
  
    
 SELECT DISTINCT taxon_scrub.scrubbed_taxon_name_no_author AS tnrs_output_name


  		




  347
  349
  
    
   FROM (taxonlabel


  		




  348
  350
  
    
   JOIN "TNRS".taxon_scrub ON ((taxon_scrub."concatenatedScientificName" = taxonlabel.taxonomicname)))


  		




  349
  351
  
    
  WHERE ((taxonlabel.source_id = ( SELECT source_by_shortname(:datasource::text) AS source_by_shortname)) AND (taxon_scrub."concatenatedScientificName" IS NOT NULL));


  		




  
  352
  
    
SET enable_hashjoin = DEFAULT;


  		




  
  353
  
    
SET join_collapse_limit = 1; -- turn it off


  		












Also available in:  Unified diff