From: ssufficool at roadrunner dot com
Operating system: Linux (Gentoo)
PHP version: 5.2.9
PHP Bug Type: PDO related
Bug description: PDO DBLIB Fails with OOM on large recordsets
Description:
------------
When pulling large recordsets with PDO DBLIB I get out of memory.
This type of large recordset query works fine on mssql_* functions using
the freetds library. This issue has been marked "Bogus" in the past. But
since this works with other functions using FreeTDS, this issue may lie in
the PDO layer.
Correct me if my understanding of Bogus is Bogus.
Reproduce code:
---------------
$pdo_ms = new PDO('dblib: host=host', 'user','pass');
/* We die here */
$rs = $pdo_ms->query("SELECT TOP 50000 from aVeryLargeTable");
Expected result:
----------------
A valid handle to a resultset in $rs
Actual result:
--------------
Available memory exhausted, tried to allocate....
--
Edit bug report at http://bugs.php.net/?id=47589&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=47589&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=47589&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=47589&r=trysnapshot60
Fixed in CVS:
http://bugs.php.net/fix.php?id=47589&r=fixedcvs
Fixed in CVS and need be documented:
http://bugs.php.net/fix.php?id=47589&r=needdocs
Fixed in release:
http://bugs.php.net/fix.php?id=47589&r=alreadyfixed
Need backtrace:
http://bugs.php.net/fix.php?id=47589&r=needtrace
Need Reproduce Script:
http://bugs.php.net/fix.php?id=47589&r=needscript
Try newer version:
http://bugs.php.net/fix.php?id=47589&r=oldversion
Not developer issue:
http://bugs.php.net/fix.php?id=47589&r=support
Expected behavior:
http://bugs.php.net/fix.php?id=47589&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=47589&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=47589&r=submittedtwice
register_globals:
http://bugs.php.net/fix.php?id=47589&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=47589&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=47589&r=dst
IIS Stability:
http://bugs.php.net/fix.php?id=47589&r=isapi
Install GNU Sed:
http://bugs.php.net/fix.php?id=47589&r=gnused
Floating point limitations:
http://bugs.php.net/fix.php?id=47589&r=float
No Zend Extensions:
http://bugs.php.net/fix.php?id=47589&r=nozend
MySQL Configuration Error:
http://bugs.php.net/fix.php?id=47589&r=mysqlcfg
