#44289 [Opn->Fbk]: Output parameter not set if stored procedure returns rows

From: Date: Sat, 25 Apr 2009 14:55:15 +0000
Subject: #44289 [Opn->Fbk]: Output parameter not set if stored procedure returns rows
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-136272@lists.php.net to get a copy of this message 
 ID:               44289
 Updated by:       jani@php.net
 Reported By:      d at tpyo dot net
-Status:           Open
+Status:           Feedback
 Bug Type:         PDO related
 Operating System: Linux 2.6.22
 PHP Version:      5.2.5
 New Comment:

Please try using this CVS snapshot:

  http://snaps.php.net/php5.2-latest.tar.gz
 
For Windows:

  http://windows.php.net/snapshots/




Previous Comments:
------------------------------------------------------------------------

[2008-02-29 10:40:07] d at tpyo dot net

Description:
------------
It seems that if a stored procedure returns rows from a SELECT the
output parameters are lost.

Not sure if this is the intended behaviour, but since this works fine
from the MySQL CLI I'm inclined to believe it's not.

Reproduce code:
---------------
Stored procedures and PDO code for reproducing the problem:

http://undesigned.org.za/files/pdo-issue.phps


Expected result:
----------------
PDO_FOUND_ROWS_TEST_1(@test1): string(4) "Set!"
PDO_FOUND_ROWS_TEST_2(@test2): string(4) "Set!"


Actual result:
--------------
PDO_FOUND_ROWS_TEST_1(@test1): string(4) "Set!"
PDO_FOUND_ROWS_TEST_2(@test2): FAILED



------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=44289&edit=1

Thread (3 messages)

« previous php.bugs (#136272) next »