#37292 [NEW]: loading CLOBs crashes php in oci8
| From: | crescentfreshpot at yahoo dot com | Date: | Wed, 03 May 2006 13:46:07 +0000 |
| Subject: | #37292 [NEW]: loading CLOBs crashes php in oci8 | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-96546@lists.php.net to get a copy of this message | ||
From: crescentfreshpot at yahoo dot com
Operating system: WinXP
PHP version: 5.1.3
PHP Bug Type: OCI8 related
Bug description: loading CLOBs crashes php in oci8
Description:
------------
OCI-Lob->read()/load() crashes php when reading clobs.
using 10g instant client, oracle v10.1.0.2.0.
Works in 5.1.3RC2 and prior (prior to fix for bug #36934 ).
Reproduce code:
---------------
sql:
alter session set current_schema = scott;
create table lobtest (lobdata clob);
insert into lobtest (lobdata) values('data data data data data data data
data');
commit;
php:
error_reporting(E_ALL);
//oci_internal_debug(1);
// uncommenting above shows the script crashes at
// OCILobRead2 at (ext\oci8\oci8_lob.c:242)
// introduced in the fix for bug #36934
$conn = oci_connect('scott', 'tiger', 'xxx')
or die('Cannot connect');
$stmt = oci_parse($conn, "select lobdata from lobtest");
oci_execute($stmt);
list($lob) = oci_fetch_row($stmt);
oci_free_statement($stmt); // 5.1.2 crashes without this
if($lob) {
$data = $lob->read(256);
//$data = $lob->load(); // this fails too
var_dump($data);
$lob->free(); // 5.1.2 crashes without this
}
Expected result:
----------------
string(39) "data data data data data data data data"
Actual result:
--------------
php crash
--
Edit bug report at http://bugs.php.net/?id=37292&edit=1
--
Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=37292&r=trysnapshot44
Try a CVS snapshot (PHP 5.1): http://bugs.php.net/fix.php?id=37292&r=trysnapshot51
Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=37292&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=37292&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=37292&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=37292&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=37292&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=37292&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=37292&r=support
Expected behavior: http://bugs.php.net/fix.php?id=37292&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=37292&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=37292&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=37292&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=37292&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=37292&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=37292&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=37292&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=37292&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=37292&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=37292&r=mysqlcfg