[ensembl-dev] bug in gene_density_calc.pl

[Andy Yates]

Hi Sharon,

Yes that does seem to be wrong. You should find the code fixed in CVS now

Andy

Andrew Yates                   Ensembl Core Software Project Leader
EMBL-EBI                       Tel: +44-(0)1223-492538
Wellcome Trust Genome Campus   Fax: +44-(0)1223-494468
Cambridge CB10 1SD, UK         http://www.ensembl.org/

On 13 Nov 2012, at 16:34, Sharon Wei wrote:

> 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
> 
> _______________________________________________
> Dev mailing list    Dev at ensembl.org
> Posting guidelines and subscribe/unsubscribe info: http://lists.ensembl.org/mailman/listinfo/dev
> Ensembl Blog: http://www.ensembl.info/