[ensembl-dev] bug in gene_density_calc.pl

[Sharon Wei]

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/