out of memory error when selecting column type longtext

"A. Gerow" <[email protected]>
Newsgroups gmane.comp.db.mysql.perl
Organization PLU
Message-ID <[email protected]>
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/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.