[ensembl-dev] bug in gene_density_calc.pl

[Sharon Wei]

Hi Ensembl Developers,

There seems to be bugs in 
ensembl/misc-scripts/density_feature/gene_density_calc.pl in the past 
release 69.

The following sqls are not working

line 127
-SQL=>"select distinct display_label, description from 
analysis_description where is_current = 1 and logic_name = 
'knowngenedensity'"
should be
-SQL=>"select distinct display_label, description from 
analysis_description ad join analysis a using (analysis_id) where  
a.logic_name = 'knowngenedensity'"

line 151:

-SQL=>"select distinct display_label, description from 
analysis_description where is_current = 1 and logic_name = 'genedensity'"
Should be
-SQL=>"select distinct display_label, description from 
analysis_description ad join analysis a using (analysis_id) where  
a.logic_name = 'genedensity'"


Sharon