#42496 [Com]: cursor is not closed when using 2 clobs in a select query
| From: | iarenuno at eteo dot mondragon dot edu | Date: | Tue, 13 Nov 2007 21:38:44 +0000 |
| Subject: | #42496 [Com]: cursor is not closed when using 2 clobs in a select query | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-119610@lists.php.net to get a copy of this message | ||
ID: 42496
Comment by: iarenuno at eteo dot mondragon dot edu
Reported By: iddekingej at lycos dot com
Status: Open
Bug Type: OCI8 related
Operating System: win 2000
PHP Version: 5.2.4
New Comment:
I can confirm that 1.2.4 has the bug, but 1.2.3 ($Revision:
1.269.2.16.2.30 $) doesn't have it.
Saludos. Iñaki.
Previous Comments:
------------------------------------------------------------------------
[2007-11-09 11:28:26] br at absb dot de
We can reproduce the problem with OCI8 versions before 1.2.4: Version
1.2.3, $Revision: 1.269.2.16.2.32 $
------------------------------------------------------------------------
[2007-11-09 03:21:13] martin at catalyst dot net dot nz
> Does setting oci8.statement_cache_size = 0 change the behavior?
It does not in our tests, unfortunately.
------------------------------------------------------------------------
[2007-11-09 01:52:04] sixd@php.net
Does setting oci8.statement_cache_size = 0 change the behavior?
------------------------------------------------------------------------
[2007-11-08 23:52:44] martin at catalyst dot net dot nz
This Moodle bugreport is related:
http://tracker.moodle.org/browse/MDL-11429
Note that under moodle (using AdoDB) we are seeing the problem as soon
as the resultset contains at least one LOB. If the table has LOBs but
the resultset is empty, no cursors are leaked.
------------------------------------------------------------------------
[2007-11-08 23:38:57] martin at catalyst dot net dot nz
These are the revisions as reported in phpinfo() for the versions I've
tested:
grep -r Revision oci8-1.*/oci8.c
oci8-1.1.1/oci8.c: php_info_print_table_row(2, "Revision",
"$Revision: 1.274 $");
oci8-1.2.3/oci8.c: php_info_print_table_row(2, "Revision",
"$Revision: 1.269.2.16.2.29 $");
oci8-1.2.4/oci8.c: php_info_print_table_row(2, "Revision",
"$Revision: 1.269.2.16.2.38 $");
oci8-1.3.0/oci8.c: php_info_print_table_row(2, "Revision",
"$Revision: 1.269.2.16.2.38.4.1 $");
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/42496
--
Edit this bug report at http://bugs.php.net/?id=42496&edit=1