--source include/have_binlog_format_row.inc

--source include/master-slave.inc

CREATE TABLE t1 (a BLOB);

INSERT INTO t1 VALUES (0);

SET SQL_MODE= 'ORACLE';

CREATE TABLE t2 SELECT * FROM t1;

--sync_slave_with_master

# Cleanup

--connection master

DROP TABLE t1, t2;

--source include/rpl_end.inc

2019-05-29 15:19:53 13 [ERROR] Slave SQL: Column 0 of table 'test.t2' cannot be converted from type 'tinyblob' to type 'longblob', Gtid 0-1-3, Internal MariaDB error code: 1677

2019-05-29 15:19:53 13 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master-bin.000001' position 708

master-bin.000001	708	Gtid	1	750	BEGIN GTID 0-1-3

master-bin.000001	750	Query	1	862	use `test`; CREATE TABLE "t2" (

  "a" blob DEFAULT NULL

)

master-bin.000001	862	Annotate_rows	1	917	CREATE TABLE t2 SELECT * FROM t1

master-bin.000001	917	Table_map	1	963	table_id: 33 (test.t2)

master-bin.000001	963	Write_rows_v1	1	1000	table_id: 33 flags: STMT_END_F

master-bin.000001	1000	Query	1	1073	COMMIT

--source include/have_binlog_format_row.inc

--source include/master-slave.inc

CREATE TABLE t1 (a DATE);

INSERT INTO t1 VALUES (NULL);

SET SQL_MODE= 'ORACLE';

CREATE TABLE t2 SELECT * FROM t1;

--sync_slave_with_master

# Cleanup

--connection master

DROP TABLE t1, t2;

--source include/rpl_end.inc

2019-05-29 19:53:05 13 [ERROR] Slave SQL: Column 0 of table 'test.t2' cannot be converted from type 'date' to type 'datetime', Gtid 0-1-3, Internal MariaDB error code: 1677

2019-05-29 19:53:05 13 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'master-bin.000001' position 707