#49287 [NEW]: MySQLi client compression broken

From: shooreek at gmail dot com Operating system: WinXP SP3 PHP version: 5.3.0 PHP Bug Type: MySQLi related Bug description: MySQLi client compression broken Description: ------------ It seems like mysqli do not understand compression protocol. When you are using flag MYSQLI_CLIENT_COMPRESS in mysqli_real_connect - it connects, but can't properly handle server (compressed?) answer. MySQL server 5.0.67-community-nt-log with compression enabled: mysql> show variables like '%have_comp%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | have_compress | YES | +---------------+-------+ 1 row in set (0.00 sec) I can connect to MySQL server using command line client with flag '-C' (use compression): C:\Documents and Settings\U>mysql -C Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 14 Server version: 5.0.67-community-nt-log MySQL Community Edition (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show status like '%compr%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | Compression | ON | +---------------+-------+ 1 row in set (0.00 sec) mysql> I think that something is wrong with mysqli and flag MYSQLI_CLIENT_COMPRESS Reproduce code: --------------- $mysqli = mysqli_init(); if (!$mysqli) { die('mysqli_init failed'); } if (!$mysqli->real_connect('localhost', '', '', NULL, NULL, NULL, MYSQLI_CLIENT_COMPRESS)) { die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); } $mysqli->query("show status like '%compre%'"); $mysqli->close(); Expected result: ---------------- Normal query execution without any errors. Actual result: -------------- PHP Some times it crushes. Sometimes it do not. Error log: PHP Warning: mysqli::query(): MySQL server has gone away in C:\Documents and Settings\U\Desktop\compress_test.php on line 42 PHP Warning: mysqli::query(): Error reading result set's header in C:\Documents and Settings\U\Desktop\compress_test.php on line 42 MySQL Error log: 090818 17:36:04 [Warning] Aborted connection 8 to db: 'unconnected' user: 'U' host: 'localhost' (Got a packet bigger than 'max_allowed_packet' bytes) someimes: 090818 17:31:13 [Warning] Aborted connection 61 to db: 'unconnected' user: 'U' host: 'localhost' (Got an error reading communication packets) -- Edit bug report at http://bugs.php.net/?id=49287&edit=1 -- Try a snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=49287&r=trysnapshot52 Try a snapshot (PHP 5.3): http://bugs.php.net/fix.php?id=49287&r=trysnapshot53 Try a snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=49287&r=trysnapshot60 Fixed in SVN: http://bugs.php.net/fix.php?id=49287&r=fixed Fixed in SVN and need be documented: http://bugs.php.net/fix.php?id=49287&r=needdocs Fixed in release: http://bugs.php.net/fix.php?id=49287&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=49287&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=49287&r=needscript Try newer version: http://bugs.php.net/fix.php?id=49287&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=49287&r=support Expected behavior: http://bugs.php.net/fix.php?id=49287&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=49287&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=49287&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=49287&r=globals PHP 4 support discontinued: http://bugs.php.net/fix.php?id=49287&r=php4 Daylight Savings: http://bugs.php.net/fix.php?id=49287&r=dst IIS Stability: http://bugs.php.net/fix.php?id=49287&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=49287&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=49287&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=49287&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=49287&r=mysqlcfg