Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.1(EOL), 10.2(EOL)
-
Can result in unexpected behaviour
Description
--source include/master-slave.inc
|
--source include/have_binlog_format_row.inc
|
|
|
set @a=1; |
set names swe7; |
create table t1 as select @a; |
set names utf8; |
show create table t1; |
select * from t1; |
|
|
--sync_slave_with_master
|
|
|
set names utf8; |
show create table t1; |
select * from t1; |
Last_Errno 1300
|
Last_Error Error 'Invalid swe7 character string: '\xC3\x89a'' on query. Default database: 'test'. Query: 'CREATE TABLE `t1` ( |
`Éa` bigint(20) DEFAULT NULL
|
)' |
The problem started happening in 10.1 tree after this commit:
commit e6f67c64cda4e4ca4f1463ae65f301358ed356a7
|
Author: Alexander Barkov <bar@mariadb.org>
|
Date: Mon Mar 16 21:55:10 2015 +0400
|
|
|
MDEV-6572 "USE dbname" with a bad sequence erroneously connects to a wrong database
|
I don't know if the change was intentional – it wasn't working quite well even before, even although replication did not abort, master and slave ended up with a different table definition; but still, replication failure is a regression, so it's worth checking what's happening.