bug in update #63
Description
Please provide the following details.
- Operating System:
- PHP Version: <7.3.9>
- php-mysql-replication Version: <6.2>
- *mysql version (
SELECT VERSION();): <5.7.21-log >
Steps required to reproduce the problem.
CREATE TABLE `cache` (
`key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`value` varchar(16100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'memory引擎不支持text',
`expiration` int(11) NOT NULL,
UNIQUE KEY `cache_key_unique` (`key`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
insert cache values ('laravel_cache5c785c036466adea360111aa28563bfd556b5fba','i:1','-1942153413')
3.
update cache set key='laravel_cache5c785c036466adea360111aa28563bfd556b5fba', value='i:2', expiration='1586248983'
Expected Result.
Date: 2020-04-07T16:42:03+08:00
Log position: 67042
Event size: 168
Table: cache
Affected columns: 3
Changed rows: 1
Values: Array
(
[0] => Array
(
[before] => Array
(
[key] => laravel_cache5c785c036466adea360111aa28563bfd556b5fba
[value] => i:1
[expiration] => -1942153413
)
[after] => Array
(
[key] => laravel_cache5c785c036466adea360111aa28563bfd556b5fba
[value] => i:2
[expiration] => 1586248983
)
)
)
Actual Result.
Date: 2020-04-07T16:42:03+08:00
Log position: 67042
Event size: 168
Table: cache
Affected columns: 3
Changed rows: 1
Values: Array
(
[0] => Array
(
[before] => Array
(
[key] => laravel_cache5c785c036466adea360111aa28563bfd556b5fba
[value] => i:1
[expiration] => -1942153413
)
[after] => Array
(
[key] => laravel_cache5c785c036466adea360111aa28563bfd556b5fbai:2;=?^?%9
[value] =>
[expiration] =>
)
)
)