php-mysql-replication icon indicating copy to clipboard operation
php-mysql-replication copied to clipboard

mysql bigint field return a string in after/before Array, should return int in php I think.

Open hetao29 opened this issue 1 year ago • 1 comments

Please provide the following details.

  • Operating System: ubuntu 22.04
  • PHP Version: 8.3.7
  • php-mysql-replication Version: 8.1.0
  • *mysql version (SELECT VERSION();): 8.4.0

Because

** PDO set \PDO::ATTR_STRINGIFY_FETCHES => false, the bigint will return int. PDO::ATTR_STRINGIFY_FETCHES

** Mysqli also return int. MYSQLI_OPT_INT_AND_FLOAT_NATIVE

** if >PHP_INT_MAX return string or return int, the pdo/mysqli do this.

hetao29 avatar Aug 28 '24 12:08 hetao29

https://github.com/hetao29/php-mysql-replication/commit/418625f36dcdb9b3fcbb24e94783556a26ee8d6d

hetao29 avatar Aug 30 '24 04:08 hetao29