php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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
 [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: Fri May 03 10:01:31 2024 UTC