--TEST-- Bug #80107 mysqli_query() fails for ~16 MB long query when compression is enabled --EXTENSIONS-- mysqli --SKIPIF-- query("SHOW VARIABLES LIKE 'max_allowed_packet'"); if ($result->fetch_assoc()['Value'] < 0xffffff) { die('skip max_allowed_packet is less than 0xffffff'); } ?> --FILE-- query("DROP TABLE IF EXISTS test"); $mysqli->query("CREATE TABLE test (`blob` LONGBLOB NOT NULL) ENGINE=MyISAM"); $data = str_repeat("x", $data_size); $mysqli->query("INSERT INTO $db.test(`blob`) VALUE ('$data')"); var_dump(mysqli_error_list($mysqli)); $mysqli->close(); // Insert with compression enabled: $mysqli = mysqli_init(); my_mysqli_real_connect($mysqli, $host, $user, $passwd, $db, $port, $socket, MYSQLI_CLIENT_COMPRESS); $data = str_repeat("x", $data_size); $mysqli->query("INSERT INTO $db.test(`blob`) VALUE ('$data')"); var_dump(mysqli_error_list($mysqli)); $mysqli->close(); ?> --CLEAN-- --EXPECT-- array(0) { } array(0) { }