php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #59348 Non-result resources causes error
Submitted: 2010-08-09 07:59 UTC Modified: 2010-08-11 06:36 UTC
From: alex dot trofast at ingres dot com Assigned: grantc@php.net (profile)
Status: Closed Package: ingres (PECL)
PHP Version: 5.3.2 OS: Linux x86_64
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: alex dot trofast at ingres dot com
New email:
PHP Version: OS:

 

 [2010-08-09 07:59 UTC] alex dot trofast at ingres dot com 
Description:
------------
When a query is run that returns a non-result resource 
statement and this is not captured within a local variable it 
gets garbage collected and results in the following error:
Warning: ingres_query(): Error: 7 - Unable to close non-
result resource statement in /path/to/code on line XYZ
The query below would cause such an error.

Reproduce code:
---------------
ingres_query($connection,"set session read write ,isolation level read uncommitted");


Expected result:
----------------
The resource is garbage collected gracefully.

Actual result:
--------------
An error is produced.

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2010-08-09 10:53 UTC] grant dot croker at ingres dot com 
Actual test case:
$link = ingres_connect("demodb");
ingres_autocommit($link);
ini_set('ingres.array_index_start', 0);
//scrollable cannot be used when lobs are in the result set
ini_set('ingres.scrollable', 0);
ingres_query($link,"set lockmode session where 
readlock=nolock");
ingres_query($link,"set session read write ,isolation level 
read uncommitted");
 [2010-08-11 06:36 UTC] grant dot croker at ingres dot com 
This bug has been fixed in SVN.

In case this was a documentation problem, the fix will show up at the
end of next Sunday (CET) on pecl.php.net.

In case this was a pecl.php.net website problem, the change will show
up on the website in short time.
 
Thank you for the report, and for helping us make PECL better.

Submitted as r302098
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Mon Jun 24 12:01:31 2024 UTC