Bug #65929 [Opn]: RSET_HEADER pack size err PDO out/inout parameter

From: 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

« previous php.bugs (#230646) next »