Project

General

Profile

« Previous | Next » 

Revision 13059

Added by Aaron Marcuse-Kubitza over 10 years ago

validation/aggregating/specimens/qualitative_validations_specimens.sql: _specimens_12_distinct_collector_name_collect_num_date_w_count: turn off join_collapse_limit instead of enable_mergejoin/enable_hashjoin, because join_collapse_limit is something that we will eventually want to turn off for all queries, which would avoid this query needing special handling. (on the other hand, enable_mergejoin/enable_hashjoin may be necessary for some queries and we probably won't turn them off for all queries.)

View differences:

trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql
94 94 
Note: character set issues may cause mis-matches. This query is a good way to reveal character set issues, either in source db or in BIEN
95 95 
';
96 96 

  		




  97
  
  
    
SET enable_mergejoin = off;


  		




  98
  
  
    
SET enable_hashjoin = off;


  		




  
  97
  
    
SET join_collapse_limit = 1; -- turn it off


  		




  99
  98
  
    
CREATE VIEW _specimens_12_distinct_collector_name_collect_num_date_w_count AS


  		




  100
  99
  
    
SELECT


  		




  101
  100
  
    
  (SELECT fullname FROM party WHERE party.party_id = collector_id) AS "collectorName"


  		




  ......




  110
  109
  
    
GROUP BY "collectorName", "collectionNumber", "dateCollected"


  		




  111
  110
  
    
ORDER BY "collectorName", "collectionNumber", "dateCollected"


  		




  112
  111
  
    
;


  		




  113
  
  
    
RESET enable_hashjoin;


  		




  114
  
  
    
RESET enable_mergejoin;


  		




  
  112
  
    
RESET join_collapse_limit;


  		




  115
  113
  
    

  		




  116
  114
  
    
CREATE VIEW _specimens_13_count_of_all_verbatim_and_decimal_lat_long AS


  		




  117
  115
  
    
SELECT


  		












Also available in:  Unified diff