Bug #67295 [Opn->Fbk]: PHP access to MySQL Stored Procedure with cursors makes incomplete table update
Edit report at https://bugs.php.net/bug.php?id=67295&edit=1
ID: 67295
Updated by: fjanisze@php.net
Reported by: wsekim at yahoo dot com
Summary: PHP access to MySQL Stored Procedure with cursors
makes incomplete table update
-Status: Open
+Status: Feedback
Type: Bug
Package: MySQLi related
Operating System: Windows 7 Pro SP1
PHP Version: 5.4.28
Block user comment: N
Private report: N
New Comment:
Can you attempt to reproduce this bug with a newer version? And if the problem is still appearing,
can you share the non working script along with the modified one (simpler) which work?
Previous Comments:
------------------------------------------------------------------------
[2014-05-16 21:01:48] wsekim at yahoo dot com
Description:
------------
A call with MySQLi triggers incomplete updates to a datatable when running a cursor-fetch loop in a
stored procedure.
The bug did not occur when testing the stored procedure in the MySQL Workbench, but arose when
calling the procedure through PHP MySQLi functions.
I am using an older version of PHP but the problem occurred on a new download of the Windows TS PHP
5.4.28 with php.ini modified only to support MySQLi access using CLI.
A test with a simpler cursor-fetch procedure, calling another stored procedure in the loop, appeared
to work fine.
Test script:
---------------
http://mikeswhitney.com/BugReportPHPMySQLMay2014.txt
Expected result:
----------------
Add 5 entries, into tbl_order_image, with image_source_path filled in with sequential values.
Actual result:
--------------
Adds 3 entries, into tbl_order_image, with correct sequential values for the first two entries.
However, a null value appears in the image_source_path of the 3rd entry
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=67295&edit=1
Thread (4 messages)