Project

General

Profile

« Previous | Next » 

Revision 12626

Added by Aaron Marcuse-Kubitza almost 11 years ago

bugfix: schemas/vegbien.sql: _plots_06_list_of_plots_with_stem_measurements: LEFT JOIN to project instead of inner joining, to get Postgres to use the right query plan. this is the last change needed to make query #6 runnable.

View differences:

trunk/schemas/vegbien.sql
7308 7308 
    plot.authorlocationcode AS plot_code
7309 7309 
   FROM ((public.plot
7310 7310 
   JOIN public.locationevent USING (location_id))
7311 
   JOIN public.project USING (project_id))
7311 
   LEFT JOIN public.project USING (project_id))
7312 7312 
  WHERE ((plot.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname)) AND (EXISTS ( SELECT NULL::unknown AS unknown
7313 7313 
   FROM (((((public.location
7314 7314 
   JOIN public.locationevent locationevent_1 USING (location_id))

Also available in: Unified diff