php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #59185 Unable to close statements
Submitted: 2010-04-30 06:17 UTC Modified: 2010-04-30 11:19 UTC
From: grant dot croker at ingres dot com Assigned:
Status: Closed Package: ingres (PECL)
PHP Version: 5.2.13 OS: Linux
Private report: No CVE-ID: None
 [2010-04-30 06:17 UTC] grant dot croker at ingres dot com
Description:
------------
When executing a simple script that creates a table and 
inserts a row, OpenAPI errors are seen.

Reproduce code:
---------------
<?php

$database="demodb";

$conn = ingres_connect($database);

if ($conn) 
{
    echo "Connection succeeded.";
    $rc=ingres_query($conn, "create table boolean_test (idx integer not null, bool integer not null)");
    $param = array(1,1);
	$rc=ingres_query($conn, "insert into boolean_test values (?,?)",$param);
    if ($rc) 
    {
		echo "Insert succeeded.";
		$param = array(1);
		$rc=ingres_query($conn, "select * from boolean_test where idx = ?",$param);
        if ($rc) 
        {

            while ( $object = ingres_fetch_object($rc)) 
            {
				echo $object->idx . " " . $object->bool;
			}
		}

	} else {
		echo "Insert failed.";
	}
    ingres_close($conn);
} else {
    echo "Connection failed.";
}

?>


Expected result:
----------------
Connection succeeded.Insert succeeded.1 1

Actual result:
--------------
Connection succeeded.Insert succeeded.
Warning: ingres_query(): ii_success : Server or API error - 
no error message available, status 7 in 
/home/grant/public_html/php/pecl/2.0/ingres/insert_test_stmt.
php on line 17

Warning: ingres_query(): ii_success : Server or API error - 
no error message available, status 7 in 
/home/grant/public_html/php/pecl/2.0/ingres/insert_test_stmt.
php on line 17

Warning: ingres_query(): _close_statement : failed  in 
/home/grant/public_html/php/pecl/2.0/ingres/insert_test_stmt.
php on line 17


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2010-04-30 11:19 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.


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sun Apr 28 13:01:29 2024 UTC