Bug #81406 [NEW]: MYSQLI_CLIENT_COMPRESS does not work with aurora MySQL Compatible

From: martin dot barker at thisisbeacon dot com Operating system: Windows 10/11 PHP version: 8.0.10 Package: MySQLi related Bug Type: Bug Bug description:MYSQLI_CLIENT_COMPRESS does not work with aurora MySQL Compatible Description: ------------ When trying to connect to a MySQL Compatible Aurora RDS using MYSQLI_CLIENT_COMPRESS PHP just gets stuck on the first query set to the server, be that a set_charset method or an actual query, According to AWS Staff Wire Compression used in Aurora MySQL Compatible should work with any MySQL Client supporting it (https://forums.aws.amazon.com/thread.jspa?messageID=850833#850833), as PHP's MySQLi System is supposed to support it this should work. This may be a regression from https://bugs.php.net/bug.php?id=47017 Test script: --------------- $mysqli = new mysqli(); $mysqli->real_connect('hostname', "username", "password", "alexandria", 3306, '', MYSQLI_CLIENT_COMPRESS); if(!$mysqli){ die("unable to connect to DB"); } $mysqli->set_charset("utf8mb3"); Expected result: ---------------- PHP to use the compressed connection correctly and not just Freeze, Actual result: -------------- in the test script, the die code is not executed meaning that PHP thinks it connected correctly, but then the set_charset call will just freeze even past the 30-second default timeout. -- Edit bug report at https://bugs.php.net/bug.php?id=81406&edit=1 -- Fix committed: https://bugs.php.net/fix.php?id=81406&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=81406&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=81406&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=81406&r=needscript Try newer version: https://bugs.php.net/fix.php?id=81406&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=81406&r=support Expected behavior: https://bugs.php.net/fix.php?id=81406&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=81406&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=81406&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=81406&r=globals PHP version support discontinued: https://bugs.php.net/fix.php?id=81406&r=phptooold Daylight Savings: https://bugs.php.net/fix.php?id=81406&r=dst IIS Stability: https://bugs.php.net/fix.php?id=81406&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=81406&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=81406&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=81406&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=81406&r=mysqlcfg