[ensembl-dev] bug in gene_density_calc.pl

[Andy Yates]

Hi Sharon,

Ah it is. Thanks for letting me know. The code has been reverted back to 1.28's contents

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 17:45, Sharon Wei wrote:

> I just figured it out, actually the sql is for ensembl_production which has a different schema from the core database.
> So it should be fine. Sorry for the confusion.
> 
> Sharon
> 
> On 11/13/12 12:18 PM, Andy Yates wrote:
>> 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/
>> 
>> _______________________________________________
>> 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/
>