[MYSQL] load data 导致主从不一致 (无主键, 有double类型) 逻辑备份恢复导致数据不一致! (MYSQL BUG 114962)

SHELL> cat /home/mysql/aa.txt
ABCDEFGH,-0
ABCDEFGH,-0.0
ABCDEFGH,0.1
ABCDEFGH,-1.1

mysql> set global local_infile=ON;
mysql> create table db1.t20240511 (name char(10), id double);

load data local infile '/home/mysql/aa.txt' ignore into table db1.t20240511
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(name, id);

#master
mysqldump -A > xxx.sql

#slave
mysql < xxx.sql
mysql> change master to xxx;

Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction 'e0fd21e2-b69d-11ee-b935-000c29909eff:907119' at master log mysql-bin.000176, end_log_pos 1263. See error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any.