[fw-db] Out of memory error

Hi,

I run this:

$sqlxx = <<<EOT
SELECT
FORMAT(seconds_to_download,2) as secs
FROM page
EOT;

$db = $this->getAdapter();
return $db->fetchAll( $sqlxx );

And I get:

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to
allocate 1431655772 bytes) in
/usr/local/lib/php/Zend/Db/Statement/Mysqli.php on line 254

Copying this sql into MySQLyog works fine (16 rows returned). No errors.

Tests replacing the SQL::

This WORKS:

SELECT
seconds_to_download as secs
FROM page

This WORKS:

SELECT
FORMAT(33.333333,2) as secs
FROM page

This WORKS:

SELECT
FORMAT(NULL,2) as secs
FROM page

The column 'seconds_to_download' is a FLOAT that can contain NULLs. Anyone
got any idea what is going on? I am running MySQL 5.0.45

Thanks,

monk.e.boy

--
View this message in context: http://www.nabble.com/Out-of-memory-error-tp19108319p19108319.html
Sent from the Zend DB mailing list archive at Nabble.com.