一个DDL导致MySQL主从停止有关问题及解决

一个DDL导致MySQL主从停止问题及解决

Create table tb(c varchar(1000))engine=innodb; Create table tc as select cast(c as signed integer) from tb; Show create table tc; CREATE TABLE `tc` ( `cast(c as signed integer)` bigint(1000) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=gbk

注：此问题只在Row based的binlog 时存在，多谢 @Mr_Mablevi 提醒