Details
- 
    Bug 
- 
    Status: Open (View Workflow)
- 
    Minor 
- 
    Resolution: Unresolved
- 
    10.6, 10.11, 10.4(EOL), 10.5(EOL), 10.9(EOL), 10.10(EOL), 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...