Bug #74967 [Com]: mysqli.reconnect = 1: MYSQLI_OPT_INT_AND_FLOAT_NATIVE lost

Edit report at https://bugs.php.net/bug.php?id=74967&edit=1 ID: 74967 Comment by: noname at withgod dot jp Reported by: spam2 at rhsoft dot net Summary: mysqli.reconnect = 1: MYSQLI_OPT_INT_AND_FLOAT_NATIVE lost Status: Open Type: Bug Package: MySQLi related Operating System: Linux PHP Version: 7.0.21 Block user comment: N Private report: N New Comment: still existing same bug in php 7.4.12. Previous Comments: ------------------------------------------------------------------------ [2017-07-22 02:57:28] spam2 at rhsoft dot net Description: ------------ if you are using persistent connections (p:hostname) and after some idle time mysqld has closed the connection you lose the MYSQLI_OPT_INT_AND_FLOAT_NATIVE setting due the automatic reconnect when the application is written with declare(strict_types=1); and used mysqli_options($conn, MYSQLI_OPT_INT_AND_FLOAT_NATIVE, true) any typesafe comparison based on database rows then fails this is really serious and make persistent connections dangerous to useless noticed this recently after a benchmark worked fine with 9000 requests/second and later random requests depending if the application chosed the readonly-slave or the master things started to break ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=74967&edit=1