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 Developer Edit
 [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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Tue Dec 16 07:00:01 2025 UTC