ID: 36607
Updated by: tony2001@php.net
Reported By: jreed at myers dot com
-Status: Open
+Status: Feedback
Bug Type: OCI8 related
Operating System: Linux - 386
PHP Version: 5.1.2
New Comment:
Please try using this CVS snapshot:
http://snaps.php.net/php5.1-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5.1-win32-latest.zip
Please provide the backtrace if you're still able to reproduce it with
the latest snapshot.
Previous Comments:
------------------------------------------------------------------------
[2006-03-03 20:13:25] jreed at myers dot com
Description:
------------
When oci8.default_prefetch is set to anything but zero, executing a SQL
statement that uses a dbLink and only returns a single row causes Apache
to seg fault. If oci8.default_prefetch is set to zero then it works
fine. This problem only seems to occur if you do a SELECT *. If you
identify the exact columns to select then it works fine. Also, the
same statement works fine, even with SELECT *, if you connect to the
database directly. It only fails if accessing through a dbLink.
Reproduce code:
---------------
$sql = "
select
*
from
my_schema.my_table@my_db_link
where
table_id = $some_id
";
$stmt = ociparse($conn, $sql);
ociexecute($stmt, OCI_DEFAULT);
ocifetchinto($stmt, $row, OCI_ASSOC);
ocifreestatement($stmt);
Expected result:
----------------
$row is a populated associative array with all the columns from the
table row requested.
Actual result:
--------------
Apache seg faults immediately after the ociexecute() call.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=36607&edit=1