out of memory error when selecting column type longtext

out of memory error when selecting column type longtext

am 07.07.2006 21:05:10 von gerowam

I've been using DBD-MySQL for a long time and I just ran across this
error. So I get an error (two + exit code actually) when I execute the
following code.

$sth = $sakai_dbh->prepare("SELECT s.SHORT_DESC ".
"FROM SAKAI_SITE s " .
"WHERE s.TYPE='course' ");
$sth->execute();
while (($curr) = $sth->fetchrow_array()) { ### WE DIE HERE ON THE
FIRST ITERATION! ###
...
}
$sth->finish();

s.SHORT_DESC is a of type LONGTEXT, and when I select other entities of
that type I get the same error. Though, I can select anything not of
type LONGTEXT from this database no problem.
The error:
Out of memory!
Out of memory!
Callback called exit.

I am using Perl 5.8.8, on Fedora Core 5 Linux 2.6, MySQL 4.1, Perl:DBI
1.51, and DBD-mysql-3.0006_1. Modifying the database is out of the
question in this particular case.

Has anyone seen, fixed, or gotten around this? Should I file a bug report?

Thanks in advance,
.Gerow

--
Aaron Gerow
Open Source Developer
Digital Media - Information and Technology Services
Pacific Lutheran University
Tacoma, Washington


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org