Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL)
-
None
Description
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
|
Attachments
Issue Links
- relates to
-
MDEV-31663 RBR fails with ER_KEY_NOT_FOUND on tables with Aria and certain character sets
- Open
-
MDEV-31664 Unexpected and/or excessive warnings upon cast in default
- Open
- mentioned in
-
Page Loading...