Project

General

Profile

« Previous | Next » 

Revision 9773

Added by Aaron Marcuse-Kubitza over 11 years ago

bugfix: inputs/GBIF/raw_occurrence_record_plants/run: table/make(): don't reset $table to plant_fraction_for_herbaria_filter for commands that use $table

View differences:

inputs/GBIF/raw_occurrence_record_plants/run
108 108
109 109 
	plant_fraction/make
110 110 
	use_local_remote
111 
	if remaking; then
112 
		table=plant_fraction_for_herbaria_filter table_esc= mk_drop|mysql_ANSI
113 
	fi
111 
	if remaking; then mk_drop|mysql_ANSI; fi
114 112 
	(benign_error=1 mysql <<EOF
115 113 
CREATE VIEW $table AS
116 114 
SELECT * FROM $full_table
117 115 
WHERE deleted IS NULL
118 116 
AND institution_code IN (SELECT * FROM herbaria_filter)
119 117 
EOF
120 
) || table=plant_fraction_for_herbaria_filter skip_table || return 0
118 
) || skip_table || return 0
121 119 
}
122 120 

  		




  123
  121
  
    
# table.tsv.gz/make() runtime: 35 min ("34m55.802s")


  		












Also available in:  Unified diff