Bug #55647 [Opn->Csd]: PDOStatement::execute() returns false when executing an UPDATE stored procedure

Edit report at https://bugs.php.net/bug.php?id=55647&edit=1 ID: 55647 Updated by: ssufficool@php.net Reported by: rcavicchioni at gmail dot com Summary: PDOStatement::execute() returns false when executing an UPDATE stored procedure -Status: Open +Status: Closed Type: Bug Package: PDO related Operating System: CentOS 5.6 & 6 PHP Version: trunk-SVN-2011-09-08 (SVN) Block user comment: N Private report: N New Comment: Automatic comment on behalf of ssufficool Revision: http://git.php.net/?p=php-src.git;a=commit;h=c34a2757db80ee2a2f35583a73899330397cb35c Log: FIX BUG #55647 Previous Comments: ------------------------------------------------------------------------ [2011-09-08 18:38:34] rcavicchioni at gmail dot com Description: ------------ When using PDO dblib, PDOStatement::execute() is returning false with a stored procedure that only contains an UPDATE statement. The procedure actually succeeds and modifies the data as expected. I discovered this issue because we upgraded to PHP 5.3.8 from 5.3.6 using the RPMs from the Remi repository. I looked at the RPM spec file and this patch is being applied for PHP bug #50755: https://raw.github.com/remicollet/remirepo/master/php/php-5.3.7-pdo-dblib-50755.patch According to the comments in the spec file, the patch is based off the following commits: http://svn.php.net/viewvc?view=revision&revision=300002 http://svn.php.net/viewvc?view=revision&revision=300089 http://svn.php.net/viewvc?view=revision&revision=300646 http://svn.php.net/viewvc?view=revision&revision=300791 Before reporting a bug to the Remi repository, I decided that I would try to duplicate the bug in PHP-trunk and I was able to. Our environment: MSSQL 2008 FreeTDS 0.82 (from the EPEL repo) PHP-trunk CentOS 5.6 Here is a simple example of the type of stored procedure that we are using. CREATE PROCEDURE [dbo].[TestProc] @iID integer, @sFoo varchar(max) AS BEGIN UPDATE TestTable SET foo = @sFoo WHERE id = @iID; END The stored procedure does not return any results, yet is executed successfully. PDOStatement::execute() returns false, but it returns true in vanilla PHP 5.3.8. It seems that since the procedure does not return any results, it causes PDOStatement::execute() to return false not true. Test script: --------------- <?php $db = new PDO($dsn, $username, $password); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = 'EXEC TestProc ?, ?'; $stmt = $db->prepare($sql); $id = 123; $foo = 'Hello ...'; $stmt->bindParam(1, $id, PDO::PARAM_INT); $stmt->bindParam(2, $foo, PDO::PARAM_STR); $ret = $stmt->execute(); var_dump($ret); ?> Expected result: ---------------- bool(true) Actual result: -------------- bool(false) ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=55647&edit=1