Bug #65929 [Opn]: RSET_HEADER pack size err PDO out/inout parameter
| From: | nikic@php.net | Date: | Thu, 26 Nov 2020 14:20:56 +0000 |
| Subject: | Bug #65929 [Opn]: RSET_HEADER pack size err PDO out/inout parameter | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-230646@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=65929&edit=1
ID: 65929
Updated by: nikic@php.net
Reported by: johanafm at gmail dot com
Summary: RSET_HEADER pack size err PDO out/inout parameter
Status: Open
Type: Bug
Package: PDO MySQL
Operating System: OSX 10.8.5
PHP Version: 5.5.5
Block user comment: N
Private report: N
New Comment:
I can't reproduce the "premature end of data" etc warnings, but I don't get a
result either ($out stays zero). I had to disable emulated prepares to make it work at all.
Previous Comments:
------------------------------------------------------------------------
[2013-10-18 14:15:29] johanafm at gmail dot com
Description:
------------
As reported by phpinfo
pdo_mysql: mysqlnd 5.0.11-dev - 20120503 - $Id: 40933630edef551dfaca71298a83fad8d03d62d4 $
Test script:
---------------
# The php code below makes use of this stored proc
DELIMITER ##
CREATE PROCEDURE out_bug(OUT param INT UNSIGNED)
BEGIN
SET param := 3;
END##
DELIMITER ;
# php - prepard statement of above stored proc
$out = 0;
$s = $db->prepare('CALL out_bug(:out)');
$s->bindParam('out', $out, PDO::PARAM_INT | PDO::PARAM_INPUT_OUTPUT, 4);
$s->execute();
echo 'out is: ' . $out;
Expected result:
----------------
I would have expected the php code to execute without errors
and $out to contain the value '3' as set in the stored procedure.
Actual result:
--------------
Warning: PDOStatement::execute(): Premature end of data (mysqlnd_wireprotocol.c:1113)
Warning: PDOStatement::execute(): RSET_HEADER packet 1 bytes shorter than expected
Warning: PDOStatement::execute(): Error reading result set's header
Warning: PDOStatement::execute(): Premature end of data (mysqlnd_wireprotocol.c:1076)
Warning: PDOStatement::execute(): RSET_HEADER packet 4 bytes shorter than expected
Warning: PDOStatement::execute(): Error reading result set's header
out is: 0
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=65929&edit=1