|
Note: The test case is based on problems reported in MDEV-31663 and MDEV-31664, so it may stop "working" (failing, that is), if those two are fixed. Maybe it can be re-written to be independent of them, but otherwise for debugging I suggest to use a revision which doesn't have fixes for MDEV-31663 and MDEV-31664.
--source include/have_binlog_format_row.inc
|
--source include/master-slave.inc
|
|
CREATE TABLE t (a INT, b CHAR(8), KEY(b)) ENGINE=Aria CHARACTER SET ucs2;
|
INSERT INTO t VALUES (1,'x');
|
ALTER TABLE t MODIFY a DECIMAL(65,10) DEFAULT(-CAST(POW(10,20) AS UNSIGNED));
|
UPDATE t SET b = 'updated';
|
--sync_slave_with_master
|
|
# Cleanup
|
--connection master
|
DROP TABLE t;
|
--source include/rpl_end.inc
|
|
10.4 9856bb42
|
Last_Error Could not execute Update_rows_v1 event on table test.t; Got overflow when converting '1e20' to UNSIGNED BIGINT. Value truncated, Error_code: 1916; Can't find record in 't', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log master-bin.000001, end_log_pos 1203
|
|