Bug #78265 utf8 on master and utf8mb4 on slave leads to "cannot be converted from type" err
| Submitted: | 28 Aug 2015 20:48 | Modified: | 31 Aug 2015 22:37 |
|---|---|---|---|
| Reporter: | Sveta Smirnova (OCA) | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Row Based Replication ( RBR ) | Severity: | S3 (Non-critical) |
| Version: | 5.6.26, 5.7.8, 5.7.9 | OS: | Any |
| Assigned to: | CPU Architecture: | Any |
[28 Aug 2015 20:48]
Sveta Smirnova
[30 Aug 2015 9:05]
MySQL Verification Team
Thank you Sveta for the test case and report. Thanks, Umesh
[31 Aug 2015 20:38]
Sveta Smirnova
Please also note what error message , printed says "Column 1 of table 'test.t1' cannot be converted from type 'varchar(765)' to type 'varchar(255)'" while affected column is "column 2", according to mysqlbinlog --verbose output. Not sure if this is result of this bug or should be reported separately.
[31 Aug 2015 22:37]
Sveta Smirnova
Note also anomaly in the error message regarding size of the column on master.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.