Edit report at http://bugs.php.net/bug.php?id=53483&edit=1
ID: 53483
Updated by: and...@php.net
Reported by: squarious at gmail dot com
Summary: using mysqli_stmt::send_long_data() makes execute()
fail
Status: Open
Type: Bug
Package: MySQLi related
Operating System: linux
PHP Version: 5.3.3
Block user comment: N
Private report: N
New Comment:
I can't reproduce the problem :(
Previous Comments:
------------------------------------------------------------------------
[2010-12-20 16:50:58] and...@php.net
libmysql + MySQL 5.1.55
and...@poohie:~/PHP_5_3$ ./php a.php
OK: Executed prepared statement with blob less than max_allowed_packet.
OK: Executed prepared statement with blob bigger than
max_allowed_packet, sent at chunks.
mysqlnd + MySQL 5.1.55
and...@poohie:~/PHP_5_3$ ./php a.php
OK: Executed prepared statement with blob less than max_allowed_packet.
OK: Executed prepared statement with blob bigger than
max_allowed_packet, sent at chunks.
------------------------------------------------------------------------
[2010-12-20 16:02:05] and...@php.net
libmysql + MySQL 5.0.90
and...@poohie:~PHP_5_3$ ./php a.php
OK: Executed prepared statement with blob less than max_allowed_packet.
OK: Executed prepared statement with blob bigger than
max_allowed_packet, sent at chunks.
libmysql + MySQL 5.5.8
and...@poohie:~/PHP_5_3$ ./php a.php
OK: Executed prepared statement with blob less than max_allowed_packet.
OK: Executed prepared statement with blob bigger than
max_allowed_packet, sent at chunks.
------------------------------------------------------------------------
[2010-12-20 15:55:06] and...@php.net
mysqlnd with MySQL 5.0.90
and...@poohie:~/PHP_5_3$ ./php a.php
OK: Executed prepared statement with blob less than max_allowed_packet.
Error executing prepared statement. Got a packet bigger than
'max_allowed_packet' bytes
------------------------------------------------------------------------
[2010-12-20 15:10:31] and...@php.net
with mysqlnd and MySQL 5.5.8 GA
and...@poohie:~/PHP_5_3$ ./php a.php
OK: Executed prepared statement with blob less than max_allowed_packet.
OK: Executed prepared statement with blob bigger than
max_allowed_packet, sent at chunks.
Seems there was a problem in 5.5.5
------------------------------------------------------------------------
[2010-12-08 16:24:53] and...@php.net
Looks a problem because of this MySQL Server bug
http://bugs.mysql.com/bug.php?id=26824
After trying the script with 5.3.4-dev , libmysql from Ubuntu 9.10 and
mysqlnd, and two different MySQL versions 5.1.51 and 5.5.5-m3.
MySQL 5.1
libmysql :
OK: Executed prepared statement with blob less than max_allowed_packet.
OK: Executed prepared statement with blob bigger than
max_allowed_packet, sent at chunks.
myslqnd:
OK: Executed prepared statement with blob less than max_allowed_packet.
and then few errors because of Packet out of order - an error packet
interleaving (see the MySQL bug description for more information)
MySQL 5.5
libmysql :
OK: Executed prepared statement with blob less than max_allowed_packet.
Error executing prepared statement. Incorrect arguments to
mysqld_stmt_execute
mysqlnd:
OK: Executed prepared statement with blob less than max_allowed_packet.
Error executing prepared statement. Incorrect arguments to
mysqld_stmt_execute
This needs more investigation with wireshark, something changed in the
server but in any case there was a problem. Haven't checked with MySQL
5.0, as I don't have one handy.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/bug.php?id=53483
--
Edit this bug report at http://bugs.php.net/bug.php?id=53483&edit=1
