--source include/have_binlog_format_row.inc

--source include/master-slave.inc

# Not needed for MTR, but just in case

CREATE DATABASE db CHARACTER SET latin1;

CREATE TABLE db.t LIKE information_schema.GLOBAL_STATUS;

SHOW CREATE TABLE db.t;

--sync_slave_with_master

SHOW CREATE TABLE db.t;

--connection master

INSERT INTO db.t VALUES ('foo','bar');

--sync_slave_with_master

# Cleanup

--connection master

DROP DATABASE db;

--source include/rpl_end.inc

SHOW CREATE TABLE db.t;

Table	Create Table

t	CREATE TABLE `t` (

  `VARIABLE_NAME` varchar(64) NOT NULL,

  `VARIABLE_VALUE` varchar(2048) NOT NULL

) ENGINE=MEMORY DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci

connection slave;

SHOW CREATE TABLE db.t;

Table	Create Table

t	CREATE TABLE `t` (

  `VARIABLE_NAME` varchar(64) NOT NULL,

  `VARIABLE_VALUE` varchar(2048) NOT NULL

) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci

2023-06-27 22:16:37 13 [ERROR] Slave SQL: Column 0 of table 'db.t' cannot be converted from type 'varchar(192 octets)' to type 'varchar(64 octets) character set latin1', Gtid 0-1-3, Internal MariaDB error code: 1677

#230627 22:16:37 server id 1  end_log_pos 705 CRC32 0x9a36f132  Query   thread_id=9     exec_time=0     error_code=0

use `test`/*!*/;

SET TIMESTAMP=1687893397/*!*/;

CREATE TABLE `db`.`t` (

  `VARIABLE_NAME` varchar(64) NOT NULL,

  `VARIABLE_VALUE` varchar(2048) NOT NULL

) ENGINE=MEMORY

/*!*/;