Skip Menu |

This queue is for tickets about the DBD-PgPP CPAN distribution.

Report information
The Basics
Id: 14791
Status: resolved
Priority: 0/
Queue: DBD-PgPP

People
Owner: Nobody in particular
Requestors: trentequatre [...] yahoo.com
Cc:
AdminCc:

Bug Information
Severity: Important
Broken in: 0.05
Fixed in: 0.06



Subject: problems with returning long strings
hello, i've got a bug on long string result i use : 'ActivePerl-5.8.6.811-MSWin32-x86-122208' for the postgres : 'PostgreSQL 7.4.6 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-42)' the version of PgPP : '0.05' i got a error when my SELECT returns a 8ko string : DBD::PgPP::st execute failed: Unknown message type: '' at C:/dev/Perl/site/lib/DBD/PgPP.pm line 713 Can't call method "fetch" on an undefined value at C:/dev/Perl/site/lib/DBD/PgPP.pm line 403. i try my sql directly on the bdd and it worked so i try an easy query (with more AAAA) : my $sqls = "select 1, 'AAAAAAA'"; $sth = $dbh->prepare($sqls); $sth->execute(); while ( ($prefixe_fich, $donnees) = $sth->fetchrow_array) error occured for 4353 'A' and then i tried : my $sqls = "select 'AAAAAAA'"; and error occured for 4376 'A' i've seen the page at : 'http://www.cpan.org/authors/id/A/AR/ARC/DBD-PgPP-0.05.readme' and checked the point limitation point : 'Can't use BLOB data' so my question is 'Is the driver limited for the return values ?'
Date: Wed, 28 Sep 2005 10:36:55 +0100
From: Aaron Crane <arc [...] cpan.org>
To: Guest via RT <bug-DBD-PgPP [...] rt.cpan.org>
Subject: Re: [cpan #14791] problems with returning long strings
RT-Send-Cc:
Guest via RT writes: Show quoted text
> hello, i've got a bug on long string result > > DBD::PgPP::st execute failed: Unknown message type: '' at C:/dev/Perl/site/lib/DBD/PgPP.pm line 713 > Can't call method "fetch" on an undefined value at C:/dev/Perl/site/lib/DBD/PgPP.pm line 403.
I'm afraid this is a known bug that I haven't yet been able to fix. I've attached a patch which partially fixes the problem, but it still fails in some cases. (It works for most things, but goes into an infinite loop for strings of some very specific values.) There will be an updated release of DBD::PgPP once I've got this sorted out. -- Aaron Crane

Message body is not shown because sender requested not to inline it.

[ARC - Wed Sep 28 05:37:25 2005]: Thank you, your patch works perfectly for my case ;) Show quoted text
> I'm afraid this is a known bug that I haven't yet been able to fix. > I've attached a patch which partially fixes the problem, but it still > fails in some cases. (It works for most things, but goes into an > infinite loop for strings of some very specific values.) > > There will be an updated release of DBD::PgPP once I've got this > sorted > out.
This issue is believed to be fixed in DBD::PgPP 0.06. Please reopen this ticket if you can still reproduce the problem in that version. Apologies for the absurdly long delay. -- Aaron Crane