[MDEV-4489] Replication of big5, cp932, gbk, sjis strings makes wrong values on slave Created: 2013-05-06 Updated: 2013-05-14 Resolved: 2013-05-14 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 10.0.2, 5.5.30, 5.1.67 |
| Fix Version/s: | 10.0.3, 5.5.31 |
| Type: | Bug | Priority: | Major |
| Reporter: | Alexander Barkov | Assignee: | Alexander Barkov |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
This does look to be a legitimate bug. This would apply to any character The problem here is that string parameters coming from prepared This can be captured by setting a breakpoint at str_to_hex and running
Using SHOW BINLOG EVENTS shows that the problem is from the server (binlogging) side:
0xHHHH is a MySQL extension. It's a hybrid thing. Binary log could use the X'HHHH' notation instead: which is an SQL standard thing, and which must always be a string. However, it seems the behaviour of X'HHHH' and of 0xHHHH
Proposed fix: |
| Comments |
| Comment by Alexander Barkov [ 2013-05-06 ] |
|
A patch sent for review. |
| Comment by Alexander Barkov [ 2013-05-14 ] |
|
Approved. Pushed into mariadb-5.5.31. |