develooper Front page | perl.dbi.users | Postings from December 2006

Re: DBD::mysql - bug affecting storage of negative values in SQL_INTEGERand SQL_TINYINT

Thread Next
From:
Patrick Galbraith
Date:
December 6, 2006 13:12
Subject:
Re: DBD::mysql - bug affecting storage of negative values in SQL_INTEGERand SQL_TINYINT
Message ID:
45773236.3080000@mysql.com
Hi!

I need to get this patch in, and apologise for not doing so sooner. I've 
been swamped with work on other projects within mysql, and even have a 
patch of mine that I wish to get in there... not to mention a patch for 
multiple result sets my comaintainer, Alexey Stroganov, has sent me!

When it rains, it pours!

Thank you for your kind words,

Patrick

ps. CC-ing the list so people know I know that they know that I need to 
get a release out soon ;)

Will Spooner wrote:

> Hi Patrick,
>
> Just to add weight to this issue; it also causes problems for projects 
> that are based on the Ensembl code, including the two that I work on 
> (Gramene, www.gramene.org, and MaizeSequence, www.maizeseqeunce.org), 
> and a host of others listed here;
>
> http://www.ensembl.org/info/about/ensembl_powered.html
>
> We can work round the problem in most cases by downgrading to a local 
> copy of DBD-mysql-2.9. This solution, however, is unsuitable for large 
> multi-node compute clusters that we use for generating our data.
>
> Many thanks for your efforts; DBD::mysql is almost always fantastic!
>
> Will
>
> On Wed, 6 Dec 2006, Glenn Proctor wrote:
>
>> Hi Patrick
>>
>> I work on the open-source bioinformatics project Ensembl,
>> http://www.ensembl.org/ . The project is built on Perl and MySQL and
>> as you would expect we make heavy use of DBD::mysql.
>>
>> We've had reports from some users of problems with storing negative
>> numbers; it looks like they are describing this bug:
>>
>> http://rt.cpan.org/Public/Bug/Display.html?id=18976
>>
>> The comments on the RT report would suggest that the patch that
>> MSCHILLI submitted made it in to 3.0008, but this doesn't seem to be
>> the case (I can provide a test script if necessary).
>>
>> Do you know if the patch will make it in to the next release of
>> DBD::mysql? The bug in question is causing considerable problems for
>> us. If we can be of any assistance, or provide more information,
>> please let me know.
>>
>> Regards
>>
>> Glenn.
>>


-- 
Patrick Galbraith, Senior Systems Engineer 
MySQL AB, www.mysql.com

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad




Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About