« Return to Thread: Out of memory error

Out of memory error

by monk.e.boy :: Rate this Message:

Reply to Author | View in Thread

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

 « Return to Thread: Out of memory error